Questetra BPMS: Process, Batch Extract as TSV<\/div>
Extracts process data as a multiline TSV string from local or remote workflow platform via API. Field-Items are specified in CSV format such as “string:0,date:2,select:3”. Range is specified by date: Start Date, End Date, or any date type.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A1: Set Target Platform URL (eg. “${var[applicationRoot]}” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A2: Set Workflow-App ID ( eg “123” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A3: Set Max Num of Extraction (default “100” limit “1000”)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Set DataItem IDs to Extract (eg “string:0,date:2,select:3” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C1: Set data to be used in Date Range (“start”, “end”, “5”:ID)#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C2: Set Range FROM ( e.g., “2022-12-01” )#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C3: Set Range TO ( e.g., “2022-12-31” )#{EL}<\/sup><\/span><\/li>\n
- C4: Change Sort Order from Oldest First to Newest First<\/li>\n
- D1: Select STRING that stores Extracted TSV (update) *<\/span><\/li>\n
- D2: Select NUMERIC that stores Num of Extracted Process (update)<\/li>\n
- D3: Select NUMERIC that stores Num of Process in Range (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strPlatformUrl = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n if( strPlatformUrl === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: Target PlatformURL} is empty \\n" );\n }\n engine.log( " AutomatedTask Config: Target PlatformURL: " + strPlatformUrl );\nconst strProcessModelInfoId = configs.get ( "StrConfA2" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n if( strProcessModelInfoId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A2: ProcessModelInfoId} is empty \\n" );\n }\n engine.log( " AutomatedTask Config: Workflow App ID: " + strProcessModelInfoId );\nlet strLimit = configs.get ( "StrConfA3" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n if( strLimit === "" ){\n strLimit = "100";\n }else if( isNaN( parseInt(strLimit) ) || parseInt(strLimit) < 0 ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A3: Max Num of Extraction} must be a positive integer \\n" );\n }else if( parseInt(strLimit) > 1000 ){\n engine.log( " AutomatedTask ConfigWarning: " +\n " {A3: Max Num of Extraction} is limited to 1000" );\n strLimit = "1000";\n }\nconst strDataitemIds = configs.get ( "StrConfB1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n if( strDataitemIds === "" ){ \/\/ processInstanceId,string:0,date:2,select:3\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {B1: DataitemIds} is empty \\n" );\n }\n engine.log( " AutomatedTask Config: Dataitem IDs: " + strDataitemIds );\n const arrDataitemIds = strDataitemIds.split(",");\nlet strDateRange = configs.get ( "StrConfC1" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n if( strDateRange === "start" ){ \/\/ "start" or "end" or {ID of DATE data}\n engine.log( " AutomatedTask Config: DateRange is applied to StartDatetime" );\n }else if( strDateRange === "" ){ \/\/ default\n strDateRange = "start";\n engine.log( " AutomatedTask Config: DateRange is applied to StartDatetime" );\n }else if( strDateRange === "end" ){\n engine.log( " AutomatedTask Config: DateRange is applied to EndDatetime" );\n }else if( parseInt(strDateRange, 10) >= 0 ){\n engine.log( " AutomatedTask Config: DateRange is applied to DateData " + strDateRange );\n }else{ \/\/ isNaN( parseInt(strDateRange) ) || parseInt(strDateRange) < 0\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {C1: Date-Range data} must be 'start' 'end' or an integer \\n" );\n }\n\nconst regBpmsYMD = \/^\\d{4}-\\d{2}-\\d{2}$\/;\nconst regBpmsYMDHM = \/^\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}$\/;\nlet strRangeFrom = configs.get ( "StrConfC2" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n if( strRangeFrom === "" ){ \/\/ default\n strRangeFrom = "#today.addDays(-7)";\n }else if( ! regBpmsYMD.test(strRangeFrom) && ! regBpmsYMDHM.test(strRangeFrom) ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {From} must be 'YYYY-MM-DD' or 'YYYY-MM-DD HH:MM' \\n" );\n }\n engine.log( " AutomatedTask Config: Range From: " + strRangeFrom );\nlet strRangeTo = configs.get ( "StrConfC3" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n if( strRangeTo === "" ){ \/\/ default\n strRangeTo = "#today";\n }else if( ! regBpmsYMD.test(strRangeTo) && ! regBpmsYMDHM.test(strRangeTo) ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {To} must be 'YYYY-MM-DD' or 'YYYY-MM-DD HH:MM' \\n" );\n }\n engine.log( " AutomatedTask Config: Range To: " + strRangeTo );\n\nlet boolNewestFirst = configs.getObject( "BoolConfC4" ); \/\/ Toggle \/\/\/\/\/\/\/\/\/\/\/\/\/\/\n if( boolNewestFirst ){\n engine.log( " AutomatedTask Config: Sort Order: Descending (Newest First)");\n }else{\n engine.log( " AutomatedTask Config: Sort Order: Ascending (Oldest First)");\n }\nconst strPocketTsv = configs.getObject( "SelectConfD1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst numPocketExtracted = configs.getObject( "SelectConfD2" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\nconst numPocketRange = configs.getObject( "SelectConfD3" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Get Process Instances\n\/\/\/ Questetra Workflow API\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360014835832-M418\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360014835832-M418\n\/\/ request1, prepare \nlet request1Uri = strPlatformUrl + "API\/OR\/ProcessInstance\/list";\nlet request1Obj = {}; \/\/ (define Range Criteria for Questetra ProcessInstance Search)\n request1Obj.processModelInfoId = parseInt(strProcessModelInfoId); \/\/ int\n \/\/ request1 - sort key\n if( strDateRange === "end" ){\n request1Obj.sortProperty = "processInstanceEndDatetime";\n }else{\n request1Obj.sortProperty = "processInstanceStartDatetime";\n }\n if( boolNewestFirst ){\n request1Obj.sortDirection = "DESC";\n }else{\n request1Obj.sortDirection = "ASC";\n }\n \/\/ request1 - Date Range\n if( strDateRange === "start" ){\n request1Obj.processInstanceStartDateFrom = strRangeFrom; \/\/ Datetime available\n request1Obj.processInstanceStartDateTo = strRangeTo;\n }else if( strDateRange === "end" ){\n request1Obj.processInstanceEndDateFrom = strRangeFrom;\n request1Obj.processInstanceEndDateTo = strRangeTo;\n }else{\n request1Obj.data= [];\n request1Obj.data[0] = {};\n request1Obj.data[0].type = "date"; \/\/ Datetime NOT available\n request1Obj.data[0].number = parseInt(strDateRange); \/\/ int number\n request1Obj.data[0].method = "after-equals";\n if( regBpmsYMDHM.test(strRangeFrom) ){ \/\/ if "2022-01-31 12:34"\n request1Obj.data[0].value = strRangeFrom.slice(0,10);\n }else{\n request1Obj.data[0].value = strRangeFrom;\n }\n request1Obj.data[1] = {};\n request1Obj.data[1].type = "date";\n request1Obj.data[1].number = parseInt(strDateRange);\n request1Obj.data[1].method = "before-equals";\n if( regBpmsYMDHM.test(strRangeTo) ){\n request1Obj.data[1].value = strRangeTo.slice(0,10);\n }else{\n request1Obj.data[1].value = strRangeTo;\n }\n }\n \/\/ request1 - Extraction\n const regDataitemId = \/^(\\w+):(\\w+)$\/;\n request1Obj.fields = [];\n for( let i = 0; i < arrDataitemIds.length; i++ ){ \/\/ processInstanceId,string:0,date:2,select:3\n if( ! regDataitemId.test(arrDataitemIds[i]) ){ \/\/ "processInstanceId", "processInstanceTitle", ...\n }else{ \/\/ string:0,date:2,select:3\n let objTmp = {};\n objTmp.type = arrDataitemIds[i].replace( \/(\\w+):(\\w+)\/, '$1' );\n objTmp.number = parseInt(arrDataitemIds[i].replace( \/(\\w+):(\\w+)\/, '$2' ));\n request1Obj.fields.push( objTmp );\n }\n }\n engine.log( " AutomatedTask Criteria: \\n" + JSON.stringify( request1Obj ) );\n \/\/ request1 - Rest Parameters\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request1 = request1.queryParam( "limit", strLimit );\n request1 = request1.queryParam( "criteria", JSON.stringify( request1Obj ) );\n\n\/\/ request1, try\nconst response1 = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\n\/\/ response1, parse\nconst response1Obj = JSON.parse( response1Body );\nengine.log( " AutomatedTask Parsed: Number of Received Instances: " + response1Obj.processInstances.length );\nengine.log( " AutomatedTask Parsed: Number of Filtered Instances: " + response1Obj.count );\n\/*\n\/\/engine.log( response1Body ); \/\/ debug\n\/\/ Request Example 1 \/\/\/\/\/\/\/\/\/\/\n{\n "processModelInfoId":1422,\n "sortProperty":"processInstanceStartDatetime",\n "sortDirection":"ASC",\n "processInstanceStartDateFrom":"2021-12-01",\n "processInstanceStartDateTo":"#today",\n "fields":[\n {"type":"string","number":11},\n {"type":"date","number":10}]}\n ]\n}\n\/\/ Response Example 1\n{\n "count": 15,\n "processInstances": [\n {\n "activeTokenNodeName": null,\n "data": {\n "10": {\n "dataType": "DATE",\n "id": 55498187,\n "processDataDefinitionNumber": 10,\n "subType": "DATE_YM",\n "value": "2021-11",\n "viewOrder": 15\n },\n "11": {\n "dataType": "STRING",\n "id": 55498188,\n "processDataDefinitionNumber": 11,\n "subType": null,\n "value": "Transportation",\n "viewOrder": 16\n }\n },\n "processInstanceDebug": false,\n "processInstanceEndDatetime": "2021-12-03T14:52:21+0900",\n "processInstanceId": 1641335,\n "processInstanceIdForView": "p1641335",\n "processInstanceInitQgroupId": 5,\n "processInstanceInitQgroupName": "Development Department",\n "processInstanceInitQuserId": 86,\n "processInstanceInitQuserName": "SUZUKI Ichiro",\n "processInstanceSequenceNumber": 5918,\n "processInstanceStartDatetime": "2021-12-03T12:03:46+0900",\n "processInstanceState": "ENDED",\n "processInstanceTitle": "Tokyo-Kyoto 20211119",\n "processModelInfoCategory": "2-Management",\n "processModelInfoId": 1422,\n "processModelInfoName": "222-reimbursement",\n "processModelVersion": 43,\n "starred": false\n },\n {\n "activeTokenNodeName": null,\n "data": {\n "10": {\n "dataType": "DATE",\n "id": 55498238,\n "processDataDefinitionNumber": 10,\n "subType": "DATE_YM",\n "value": "2021-11",\n "viewOrder": 15\n },\n "11": {\n "dataType": "STRING",\n "id": 55498239,\n "processDataDefinitionNumber": 11,\n "subType": null,\n "value": "Transportation",\n "viewOrder": 16\n }\n },\n "processInstanceDebug": false,\n "processInstanceEndDatetime": "2021-12-03T14:52:09+0900",\n "processInstanceId": 1641336,\n "processInstanceIdForView": "p1641336",\n "processInstanceInitQgroupId": 5,\n "processInstanceInitQgroupName": "Development Department",\n "processInstanceInitQuserId": 86,\n "processInstanceInitQuserName": "SUZUKI Ichiro",\n "processInstanceSequenceNumber": 5919,\n "processInstanceStartDatetime": "2021-12-03T12:06:54+0900",\n "processInstanceState": "ENDED",\n "processInstanceTitle": "Tokyo-Kyoto 20211109",\n "processModelInfoCategory": "2-Management",\n "processModelInfoId": 1422,\n "processModelInfoName": "222-reimbursement",\n "processModelVersion": 43,\n "starred": false\n }\n ]\n}\n\/\/ Request Example 2 \/\/\/\/\/\/\/\/\/\/\n{\n "processModelInfoId":1422,\n "sortProperty":"processInstanceStartDatetime",\n "sortDirection":"ASC",\n "data":[\n {\n "type":"date",\n "number":5,\n "method":"after-equals",\n "value":"2021-12-01"\n },\n {\n "type":"date",\n "number":5,\n "method":"before-equals",\n "value":"#today"\n }\n ],\n "fields":[\n {\n "type":"decimal",\n "number":12\n },\n {\n "type":"date",\n "number":10\n },\n {\n "type":"string",\n "number":11\n }\n ]\n}\n\/\/ Response Example 2\n{\n "count": 9,\n "processInstances": [\n {\n "activeTokenNodeName": null,\n "data": {\n "10": {\n "dataType": "DATE",\n "id": 56086017,\n "processDataDefinitionNumber": 10,\n "subType": "DATE_YM",\n "value": "2021-12",\n "viewOrder": 15\n },\n "11": {\n "dataType": "STRING",\n "id": 56086018,\n "processDataDefinitionNumber": 11,\n "subType": null,\n "value": "Transportation",\n "viewOrder": 16\n },\n "12": {\n "dataType": "DECIMAL",\n "id": 56086019,\n "processDataDefinitionNumber": 12,\n "subType": null,\n "value": "418",\n "viewOrder": 17\n }\n },\n "processInstanceDebug": false,\n "processInstanceEndDatetime": "2021-12-21T10:32:20+0900",\n "processInstanceId": 1655495,\n "processInstanceIdForView": "p1655495",\n "processInstanceInitQgroupId": 3,\n "processInstanceInitQgroupName": "Sales",\n "processInstanceInitQuserId": 16,\n "processInstanceInitQuserName": "SATO Jiro",\n "processInstanceSequenceNumber": 5925,\n "processInstanceStartDatetime": "2021-12-20T07:07:43+0900",\n "processInstanceState": "ENDED",\n "processInstanceTitle": "Shinjuku-Tokyo",\n "processModelInfoCategory": "2-Management",\n "processModelInfoId": 1422,\n "processModelInfoName": "222-reimbursement",\n "processModelVersion": 43,\n "starred": false\n },\n {\n "activeTokenNodeName": null,\n "data": {\n "10": {\n "dataType": "DATE",\n "id": 56086051,\n "processDataDefinitionNumber": 10,\n "subType": "DATE_YM",\n "value": "2021-12",\n "viewOrder": 15\n },\n "11": {\n "dataType": "STRING",\n "id": 56086052,\n "processDataDefinitionNumber": 11,\n "subType": null,\n "value": "Transportation",\n "viewOrder": 16\n },\n "12": {\n "dataType": "DECIMAL",\n "id": 56086053,\n "processDataDefinitionNumber": 12,\n "subType": null,\n "value": "220",\n "viewOrder": 17\n }\n },\n "processInstanceDebug": false,\n "processInstanceEndDatetime": "2021-12-21T10:32:59+0900",\n "processInstanceId": 1655496,\n "processInstanceIdForView": "p1655496",\n "processInstanceInitQgroupId": 3,\n "processInstanceInitQgroupName": "Sales",\n "processInstanceInitQuserId": 16,\n "processInstanceInitQuserName": "SATO Jiro",\n "processInstanceSequenceNumber": 5926,\n "processInstanceStartDatetime": "2021-12-20T07:08:16+0900",\n "processInstanceState": "ENDED",\n "processInstanceTitle": "Kyoto-KarasumaOike",\n "processModelInfoCategory": "2-Management",\n "processModelInfoId": 1422,\n "processModelInfoName": "222-reimbursement",\n "processModelVersion": 43,\n "starred": false\n }\n ]\n}\n*\/\n\n\/\/ build TSV\nlet strTsv = "";\nfor( let h = 0; h < response1Obj.processInstances.length; h++ ){\n for( let i = 0; i < arrDataitemIds.length; i++ ){\n if( arrDataitemIds[i] === "processInstanceId" ){\n strTsv += response1Obj.processInstances[h].processInstanceId;\n }else if( arrDataitemIds[i] === "processInstanceTitle" ){\n if( response1Obj.processInstances[h].processInstanceTitle !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceTitle;\n }\n }else if( arrDataitemIds[i] === "processInstanceState" ){\n if( response1Obj.processInstances[h].processInstanceState !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceState;\n }\n }else if( arrDataitemIds[i] === "processInstanceStartDatetime" ){\n if( response1Obj.processInstances[h].processInstanceStartDatetime !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceStartDatetime;\n }\n }else if( arrDataitemIds[i] === "processInstanceEndDatetime" ){\n if( response1Obj.processInstances[h].processInstanceEndDatetime !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceEndDatetime;\n }\n }else if( arrDataitemIds[i] === "processModelInfoId" ){\n if( response1Obj.processInstances[h].processModelInfoId !== null ){\n strTsv += response1Obj.processInstances[h].processModelInfoId;\n }\n }else if( arrDataitemIds[i] === "processModelInfoName" ){\n if( response1Obj.processInstances[h].processModelInfoName !== null ){\n strTsv += response1Obj.processInstances[h].processModelInfoName;\n }\n }else if( arrDataitemIds[i] === "processModelInfoCategory" ){\n if( response1Obj.processInstances[h].processModelInfoCategory !== null ){\n strTsv += response1Obj.processInstances[h].processModelInfoCategory;\n }\n }else if( arrDataitemIds[i] === "processInstanceInitQuserId" ){\n if( response1Obj.processInstances[h].processInstanceInitQuserId !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceInitQuserId;\n }\n }else if( arrDataitemIds[i] === "processInstanceInitQuserName" ){\n if( response1Obj.processInstances[h].processInstanceInitQuserName !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceInitQuserName;\n }\n }else if( arrDataitemIds[i] === "processInstanceInitQgroupId" ){\n if( response1Obj.processInstances[h].processInstanceInitQgroupId !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceInitQgroupId;\n }\n }else if( arrDataitemIds[i] === "processInstanceInitQgroupName" ){\n if( response1Obj.processInstances[h].processInstanceInitQgroupName !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceInitQgroupName;\n }\n }else if( arrDataitemIds[i] === "processModelVersion" ){\n if( response1Obj.processInstances[h].processModelVersion !== null ){\n strTsv += response1Obj.processInstances[h].processModelVersion;\n }\n }else if( arrDataitemIds[i] === "processInstanceDebug" ){\n if( response1Obj.processInstances[h].processInstanceDebug !== null ){\n strTsv += response1Obj.processInstances[h].processInstanceDebug;\n }\n }else if( arrDataitemIds[i] === "starred" ){\n if( response1Obj.processInstances[h].starred !== null ){\n strTsv += response1Obj.processInstances[h].starred;\n }\n }else if( regDataitemId.test(arrDataitemIds[i]) ){\n const dataId = arrDataitemIds[i].replace( \/(\\w+):(\\w+)\/, '$2' );\n if( response1Obj.processInstances[h].data[ dataId ] == undefined ){\n strTsv += "#N\/A";\n }else if( response1Obj.processInstances[h].data[ dataId ].dataType === "STRING" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "DECIMAL" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "DATE" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "DATETIME" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "QUSER" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "QGROUP" || \n response1Obj.processInstances[h].data[ dataId ].dataType === "DISCUSSION" ){\n if( response1Obj.processInstances[h].data[ dataId ].value !== null ){\n strTsv += response1Obj.processInstances[h].data[ dataId ].value\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n }\n }else if( response1Obj.processInstances[h].data[ dataId ].dataType === "SELECT" ){\n if( response1Obj.processInstances[h].data[ dataId ].value !== null ){\n for( let j = 0; j < response1Obj.processInstances[h].data[ dataId ].value.length; j++ ){\n strTsv += response1Obj.processInstances[h].data[ dataId ].value[j].display\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== response1Obj.processInstances[h].data[ dataId ].value.length - 1 ){\n strTsv += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else if( response1Obj.processInstances[h].data[ dataId ].dataType === "FILE2" ){\n if( response1Obj.processInstances[h].data[ dataId ].value !== null ){\n for( let j = 0; j < response1Obj.processInstances[h].data[ dataId ].value.length; j++ ){\n strTsv += response1Obj.processInstances[h].data[ dataId ].value[j].name\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== response1Obj.processInstances[h].data[ dataId ].value.length - 1 ){\n strTsv += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else{\n strTsv += "#TYPE!";\n }\n }\n if( i !== arrDataitemIds.length - 1 ){\n strTsv += "\\t";\n }\n }\n if( h !== response1Obj.processInstances.length - 1 ){\n strTsv += "\\n";\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketTsv !== null ){ \/\/ STRING\n engine.setData( strPocketTsv, strTsv );\n}\nif( numPocketExtracted !== null ){\n engine.setData( numPocketExtracted,\n new java.math.BigDecimal( response1Obj.processInstances.length ) );\n}\nif( numPocketRange !== null ){\n engine.setData( numPocketRange,\n new java.math.BigDecimal( response1Obj.count ) );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/*\nNotes:\n- When a process reaches this automated task, a request is thrown to the target workflow platform.\n - Business data accumulated in the workflow platform can be automatically extracted via API.\n - With "Timer Start Event", you can automate weekly or monthly aggregation and reporting tasks.\n - The target workflow platform is set by URL. (REST API Server)\n - `https:\/\/example.questetra.net\/`\n - If the target is the same platform, setting by variables is convenient. (System variable)\n - `${var[applicationRoot]}`\n- The output TSV text will be generated as "the simplest tab-delimited string".\n - TAB codes and line feed codes in each data will be converted to " " (half-width space).\n - Double-quote characters are also retained in their unescaped state.\n- The extraction range is specified by date.\n - Process Start Date and Process End Date\n - e.g.: `2021-12-15` - `2022-01-31`\n - e.g.: `2021-12-15` - `2022-01-31 23:59`\n - e.g.: `2021-12-15` - `#today\n - e.g.: `#today.addDays(-7)` - `#today` (default)\n - Any DATE type data.\n - e.g.: `2021-12-15` - `2022-01-31` (default)\n - e.g.: `2021-12-15` - `#today` (default) Any date type data.\n - e.g.: `#today.addDays(-7)` - `#today` (default)\n - Dynamic values will be set for each case (initial of process \/ automated task config)\n - R2271: Output of Date and Datetime Data via EL syntax\n - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271\n- The extraction items and their order are specified by CSV. (Extraction CSV)\n - e.g.: `string:0,date:2,select:3`.\n - e.g.: `processInstanceId,decimal:10,date:2,select:3,processInstanceTitle`.\n - "Process ID" and "Title" can also be extracted.\n\nAPPENDIX:\n- Extraction CSV (e.g.: `string:0,date:2,select:3`)\n - How to specify the data type\n - String: `string\n - Numeric: `decimal`.\n - Select: `select`.\n - Date: `date`.\n - Datetime: `datetime`.\n - File: `file`.\n - User: `quser`.\n - Organization: `qgroup`.\n - Table: `list`.\n - Discussion: `discussion`.\n - How to specify process title, etc. (process properties)\n - Process ID: `processInstanceId`.\n - Title: `processInstanceTitle`.\n - State: `processInstanceState`.\n - Start Time: `processInstanceStartDatetime`.\n - End Time: `processInstanceEndDatetime`.\n - App ID: `processModelInfoId`\n - App Name: `processModelInfoName`\n - Category: `processModelInfoCategory`\n - Start User ID: `processInstanceInitQuserId`\n - Start User: `processInstanceInitQuserName`.\n - Start Organization ID: `processInstanceInitQgroupId`\n - Start Organization: `processInstanceInitQgroupName`\n - Version: `processModelVersion`\n - Debug: `processInstanceDebug`\n - Star: `starred`\n - If a file type is specified, the file name will be extracted (multiple: space separated)\n - If a select type is specified, the display text will be extracted (multiple: space separated)\n - If an undefined data ID is specified, `#N\/A` will be output.\n - If an unsupported data type is specified, `#TYPE!` will be output.\n- Authorization settings for automated communication\n - Add the client on the target Workflow Platform (server side) in advance. (System Admin privilege required)\n - "API Clients" > "OAuth2 Clients" > "Add OAuth2 Client"\n - Redirect URL\n - `https:\/\/s.questetra.net\/oauth2callback`\n - Add "HTTP Authorization Setting" for the Workflow app. (App Administrator privilege required)\n - "App Settings" > (App Details) > "App" > "HTTP Authorization Setting > "Add"\n - `OAuth2`\n - Name: (Any name)\n - e.g.: `For TSV extraction`\n - Authorization Endpoint URL: (refer to the registration information on the server side)\n - e.g.: `https:\/\/example.questetra.net\/oauth2\/authorize`\n - Token Endpoint URL: (refer to the registration information on the server side)\n - e.g.: `https:\/\/example.questetra.net\/oauth2\/token`\n - Scope: `read`.\n - Client ID: (refer to the server-side registration information)\n - e.g.: `KXkYNxxxxXvJBmyyyyyIvEwuzzzzzli`.\n - Client Secret: (refer to the server-side registration information)\n - e.g.: `IHYWfxxxxxEZ1GuyyyyysdAM`.\n- REST API Specification\n - "Questetra Workflow API" (swagger)\n - https:\/\/online-demo-en.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API\n - or "https:\/\/{YOUR_PlatformId}.questetra.net\/s\/swagger\/index.html"\n- There is another method for extracting business data via API: the ReportId method.\n - Extraction conditions (Report) are saved in advance on the Workflow Platform where data is stored\n - "Questetra BPMS: Process, Batch Extract by Filter as TSV"\n - https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/\n - Since you only need to specify Report Id, you can easily model aggregate operations.\n - However, if an item is added, the number of columns in the extracted TSV will increase.\n - Also, the display order of the extracted TSVs is not reproduced. (You will need to reorder them.)\n\n\nNotes (ja):\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306b\u62bd\u51fa\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u6295\u3052\u3089\u308c\u307e\u3059\u3002\n - \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u5185\u306b\u84c4\u7a4d\u3055\u308c\u305f\u696d\u52d9\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002\uff08API\u7d4c\u7531\u62bd\u51fa\uff09\n - "\u30bf\u30a4\u30de\u30fc\u958b\u59cb\u30a4\u30d9\u30f3\u30c8" \u3068\u4f75\u7528\u3059\u308c\u3070\u3001\u9031\u6b21\u3084\u6708\u6b21\u306e\u96c6\u8a08\u696d\u52d9\u30fb\u30ec\u30dd\u30fc\u30c8\u696d\u52d9\u3092\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\u3002\n - \u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306f URL \u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08REST API \u63a5\u7d9a\u5148\uff09\n - `https:\/\/example.questetra.net\/`\n - \u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u304c\u540c\u4e00\u57fa\u76e4\u306e\u5834\u5408\u3001\u5909\u6570\u306b\u3088\u308b\u8a2d\u5b9a\u304c\u4fbf\u5229\u3067\u3059\u3002\uff08\u30b7\u30b9\u30c6\u30e0\u5909\u6570\uff09\n - `${var[applicationRoot]}`\n- \u51fa\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n - \u5404\u30c7\u30fc\u30bf\u5185\u306eTAB\u30b3\u30fc\u30c9\u3084\u6539\u884c\u30b3\u30fc\u30c9\u306f " " \uff08\u534a\u89d2\u30b9\u30da\u30fc\u30b9\uff09\u306b\u5909\u63db\u3055\u308c\u307e\u3059\u3002\n - \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u3082\u3001\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u3066\u3044\u306a\u3044\u72b6\u614b\u3067\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n- \u62bd\u51fa\u7bc4\u56f2\u306f\u65e5\u4ed8\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\n - \u30d7\u30ed\u30bb\u30b9\u958b\u59cb\u65e5\u6642\u30fb\u30d7\u30ed\u30bb\u30b9\u7d42\u4e86\u65e5\u6642\n - e.g.: `2021-12-15` - `2022-01-31`\n - e.g.: `2021-12-15` - `2022-01-31 23:59`\n - e.g.: `2021-12-15` - `#today`\n - e.g.: `#today.addDays(-7)` - `#today` (default)\n - \u4efb\u610f\u306e\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\n - e.g.: `2021-12-15` - `2022-01-31`\n - e.g.: `2021-12-15` - `#today`\n - e.g.: `#today.addDays(-7)` - `#today` (default)\n - \u6848\u4ef6\u3054\u3068\u306b\u52d5\u7684\u306a\u5024\u304c\u30bb\u30c3\u30c8\u3055\u308c\u308b\u8a2d\u5b9a\uff08\u6848\u4ef6\u30c7\u30fc\u30bf\u521d\u671f\u5024\uff0f\u81ea\u52d5\u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\uff09\n - R2271: EL\u5f0f\u306b\u3088\u308b\u65e5\u4ed8\u65e5\u6642\u3068\u3057\u3066\u306e\u51fa\u529b\uff08\u30c7\u30fc\u30bf\u8a2d\u5b9a\u5f0f\uff09\n - https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271\n- \u62bd\u51fa\u9805\u76ee\u3068\u305d\u306e\u9806\u5e8f\u306fCSV\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\uff08\u62bd\u51faCSV\uff09\n - e.g.: `string:0,date:2,select:3`\n - e.g.: `processInstanceId,decimal:10,date:2,select:3,processInstanceTitle`\n - \u6848\u4ef6\u306e\u300c\u30d7\u30ed\u30bb\u30b9ID\u300d\u3084\u300c\u30bf\u30a4\u30c8\u30eb\u300d\u3082\u62bd\u51fa\u53ef\u80fd\u3067\u3059\n\nAPPENDIX (ja):\n- \u62bd\u51faCSV (e.g.: `string:0,date:2,select:3`)\n - \u30c7\u30fc\u30bf\u578b\u306e\u6307\u5b9a\u65b9\u6cd5\uff1a\n - \u6587\u5b57\uff1a `string`\n - \u6570\u5024\uff1a `decimal`\n - \u9078\u629e\uff1a `select`\n - \u65e5\u4ed8\uff1a `date`\n - \u65e5\u6642\uff1a `datetime`\n - \u30d5\u30a1\u30a4\u30eb\uff1a `file`\n - \u30e6\u30fc\u30b6\uff1a `quser`\n - \u7d44\u7e54\uff1a `qgroup`\n - \u30c6\u30fc\u30d6\u30eb\uff1a `list`\n - \u63b2\u793a\u677f\uff1a `discussion`\n - \u6848\u4ef6\u30bf\u30a4\u30c8\u30eb\u7b49\uff08\u30d7\u30ed\u30bb\u30b9\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\uff09\u306e\u6307\u5b9a\u65b9\u6cd5\uff1a\n - \u30d7\u30ed\u30bb\u30b9ID\uff1a `processInstanceId`\n - \u4ef6\u540d\uff1a `processInstanceTitle`\n - \u72b6\u614b\uff1a `processInstanceState`\n - \u958b\u59cb\u65e5\u6642\uff1a `processInstanceStartDatetime`\n - \u7d42\u4e86\u65e5\u6642\uff1a `processInstanceEndDatetime`\n - \u30a2\u30d7\u30eaID\uff1a `processModelInfoId`\n - \u30a2\u30d7\u30ea\u540d\uff1a `processModelInfoName`\n - \u30ab\u30c6\u30b4\u30ea\uff1a `processModelInfoCategory`\n - \u958b\u59cb\u30e6\u30fc\u30b6ID\uff1a `processInstanceInitQuserId`\n - \u958b\u59cb\u30e6\u30fc\u30b6\uff1a `processInstanceInitQuserName`\n - \u958b\u59cb\u7d44\u7e54ID\uff1a `processInstanceInitQgroupId`\n - \u958b\u59cb\u7d44\u7e54\uff1a `processInstanceInitQgroupName`\n - \u30d0\u30fc\u30b8\u30e7\u30f3\uff1a `processModelVersion`\n - \u30c7\u30d0\u30c3\u30b0\uff1a `processInstanceDebug`\n - \u30b9\u30bf\u30fc\u2606\uff1a `starred`\n - \u30d5\u30a1\u30a4\u30eb\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n - \u9078\u629e\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n - \u672a\u5b9a\u7fa9\u306e\u30c7\u30fc\u30bf\u9805\u76eeID\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001`#N\/A` \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n - \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001`#TYPE!` \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n- \u81ea\u52d5\u901a\u4fe1\u306e\u8a8d\u53ef\u8a2d\u5b9a\n - \u63a5\u7d9a\u5148\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u5074\uff08\u30b5\u30fc\u30d0\u5074\uff09\u3067\u3001\u4e88\u3081\u63a5\u7d9a\u5143\u3092\u767b\u9332\u3057\u307e\u3059\u3002\uff08\u8981\u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u6a29\u9650\uff09\n - \uff3bAPI\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff3d\uff1e\uff3bOAuth2\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff3d\uff1e\uff3bOAuth2\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u8ffd\u52a0\uff3d\n - \u30ea\u30c0\u30a4\u30ec\u30af\u30c8URL\uff08Redirect URL\uff09\n - `https:\/\/s.questetra.net\/oauth2callback`\n - \u63a5\u7d9a\u5143\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u306e\uff3bHTTP\u8a8d\u8a3c\u8a2d\u5b9a\uff3d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08\u30a2\u30d7\u30ea\u7ba1\u7406\u6a29\u9650\uff09\n - \uff3b\u30a2\u30d7\u30ea\u8a2d\u5b9a\uff3d\uff1e\uff08\u30a2\u30d7\u30ea\u8a73\u7d30\uff09\uff1e\uff3b\u30a2\u30d7\u30ea\uff3d\uff1e\uff3bHTTP\u8a8d\u8a3c\u8a2d\u5b9a\uff3d\uff1e\uff3b\u8ffd\u52a0\uff3d\n - `OAuth2`\n - \u540d\u524d\uff1a (\u4efb\u610f\u306e\u540d\u524d)\n - e.g.: `\u6848\u4ef6\u30c7\u30fc\u30bfTSV\u62bd\u51fa\u7528`\n - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff1a (\u30b5\u30fc\u30d0\u5074\u306e\u767b\u9332\u60c5\u5831\u3092\u53c2\u7167)\n - e.g.: `https:\/\/example.questetra.net\/oauth2\/authorize`\n - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff1a (\u30b5\u30fc\u30d0\u5074\u306e\u767b\u9332\u60c5\u5831\u3092\u53c2\u7167)\n - e.g.: `https:\/\/example.questetra.net\/oauth2\/token`\n - \u30b9\u30b3\u30fc\u30d7\uff1a `read`\n - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\uff1a (\u30b5\u30fc\u30d0\u5074\u306e\u767b\u9332\u60c5\u5831\u3092\u53c2\u7167)\n - e.g.: `KXkYNxxxxxXvJBmyyyyyIvEwuzzzzzli`\n - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\uff1a (\u30b5\u30fc\u30d0\u5074\u306e\u767b\u9332\u60c5\u5831\u3092\u53c2\u7167)\n - e.g.: `IHYWfxxxxxEZ1GuyyyyysdAM`\n- REST API \u4ed5\u69d8\n - "Questetra Workflow API" (swagger)\n - https:\/\/online-demo-ja.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API\n - or "https:\/\/{YOUR_PlatformId}.questetra.net\/s\/swagger\/index.html"\n- \u696d\u52d9\u30c7\u30fc\u30bf\u306eAPI\u7d4c\u7531\u62bd\u51fa\u306b\u306f\u3001\u4ed6\u306b\u300cReportId \u65b9\u5f0f\u300d\u304c\u3042\u308a\u307e\u3059\u3002\n - \u30c7\u30fc\u30bf\u304c\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u5074\u3067\u3001\u3042\u3089\u304b\u3058\u3081\u62bd\u51fa\u6761\u4ef6\uff08Report\uff09\u3092\u4fdd\u5b58\u3057\u3066\u304a\u304f\u65b9\u5f0f\n - "Questetra BPMS: \u6848\u4ef6, \u4fdd\u5b58\u6e08\u30d5\u30a3\u30eb\u30bf\u3067TSV\u4e00\u62ec\u62bd\u51fa"\n - https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/\n - Report Id \u3092\u6307\u5b9a\u3059\u308b\u3060\u3051\u306a\u306e\u3067\u3001\u96c6\u8a08\u696d\u52d9\u3092\u7c21\u5358\u306b\u30e2\u30c7\u30ea\u30f3\u30b0\u3067\u304d\u307e\u3059\u3002\n - \u3057\u304b\u3057\u3001\u305f\u3068\u3048\u3070\u62bd\u51fa\u6761\u4ef6\uff08\u4fdd\u5b58\u6e08\u30d5\u30a3\u30eb\u30bf\uff09\u306e\u9805\u76ee\u304c\u8ffd\u52a0\u524a\u9664\u3055\u308c\u308b\u3068\u3001\u62bd\u51faTSV\u306e\u5217\u6570\u304c\u5897\u6e1b\u3057\u307e\u3059\u3002\n - \u307e\u305f\u3001\u62bd\u51faTSV\u306e\u8868\u793a\u9806\u304c\u518d\u73fe\u3055\u308c\u307e\u305b\u3093\u3002\uff08\u4e26\u3079\u66ff\u3048\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\uff09\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- questetra-bpms-process-batch-extract-as-tsv-2022.xml<\/a>\n
- \n
- 2022-01-25 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- questetra-bpms-process-batch-extract-as-tsv-2023.xml<\/a>\n
- \n
- 2023-08-15 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- questetra-bpms-process-batch-extract-as-tsv-2026.xml<\/a>\n
- \n
- 2026-05-07 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- Due to the deprecation of the method
authSetting(String)<\/code> at v18.<\/li>\n\n\n\n- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
The Add-on import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- When a process reaches this automated task a request is thrown to the target workflow platform.\n
- \n
- Business data accumulated in the workflow platform can be automatically extracted via API.<\/li>\n\n\n\n
- With a [Timer Start Event] you can automate weekly or monthly aggregation and reporting tasks.<\/li>\n\n\n\n
- The target workflow platform is set by URL. (REST API Server)\n
- \n
https:\/\/example.questetra.net\/<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- If the target is the same platform, setting by variables is convenient. (System variable)\n
- \n
${var[applicationRoot]}<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n- The output TSV text will be generated as the simplest tab-delimited string.\n
- \n
- TAB codes and line feed codes in each data will be converted to ” ” (half-width space).<\/li>\n\n\n\n
- Double-quote characters are also retained in their unescaped state.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- The extraction range is specified by date.\n
- \n
- Process Start Date and Process End Date\n
- \n
- e.g.:
2021-12-15<\/code> –2022-01-31<\/code><\/li>\n\n\n\n- e.g.:
2021-12-15<\/code> –2022-01-31 23:59<\/code><\/li>\n\n\n\n- e.g.:
2021-12-15<\/code> – `#today<\/li>\n\n\n\n- e.g.:
#today.addDays(-7)<\/code> –#today<\/code> (default)<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Any DATE type data.\n
- \n
- e.g.:
2021-12-15<\/code> –2022-01-31<\/code> (default)<\/li>\n\n\n\n- e.g.:
2021-12-15<\/code> –#today<\/code> (default) Any date type data.<\/li>\n\n\n\n- e.g.:
#today.addDays(-7)<\/code> –#today<\/code> (default)<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Dynamic values will be set for each case (initial of process \/ automated task config)\n
- \n
- R2271: Output of Date and Datetime Data via EL syntax\n
- \n
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- The extraction items and their order are specified by CSV. (Extraction CSV)\n
- \n
- e.g.:
string:0,date:2,select:3<\/code>.<\/li>\n\n\n\n- e.g.:
processInstanceId,decimal:10,date:2,select:3,processInstanceTitle<\/code>.\n- \n
- “Process ID” and “Title” can also be extracted.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Questetra](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/questetra-bpms-process-batch-extract-as-tsv-2022-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Extracts](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/questetra-bpms-process-batch-extract-as-tsv-2022-config-en-481x630.png?resize=481%2C630&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- Extraction CSV (e.g.:
string:0,date:2,select:3<\/code>)\n- \n
- How to specify the data type\n
- \n
- String: string<\/li>\n\n\n\n
- Numeric:
decimal<\/code>.<\/li>\n\n\n\n- Select:
select<\/code>.<\/li>\n\n\n\n- Date:
date<\/code>.<\/li>\n\n\n\n- Datetime:
datetime<\/code>.<\/li>\n\n\n\n- File:
file<\/code>.<\/li>\n\n\n\n- User:
quser<\/code>.<\/li>\n\n\n\n- Organization:
qgroup<\/code>.<\/li>\n\n\n\n- Table:
list<\/code>.<\/li>\n\n\n\n- Discussion:
discussion<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n- How to specify process title, etc. (process properties)\n
- \n
- Process ID:
processInstanceId<\/code>.<\/li>\n\n\n\n- Title:
processInstanceTitle<\/code>.<\/li>\n\n\n\n- State:
processInstanceState<\/code>.<\/li>\n\n\n\n- Start Time:
processInstanceStartDatetime<\/code>.<\/li>\n\n\n\n- End Time:
processInstanceEndDatetime<\/code>.<\/li>\n\n\n\n- App ID:
processModelInfoId<\/code><\/li>\n\n\n\n- App Name:
processModelInfoName<\/code><\/li>\n\n\n\n- Category:
processModelInfoCategory<\/code><\/li>\n\n\n\n- Start User ID:
processInstanceInitQuserId<\/code><\/li>\n\n\n\n- Start User:
processInstanceInitQuserName<\/code>.<\/li>\n\n\n\n- Start Organization ID:
processInstanceInitQgroupId<\/code><\/li>\n\n\n\n- Start Organization:
processInstanceInitQgroupName<\/code><\/li>\n\n\n\n- Version:
processModelVersion<\/code><\/li>\n\n\n\n- Debug:
processInstanceDebug<\/code><\/li>\n\n\n\n- Star:
starred<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- If a file type is specified, the file name will be extracted (multiple: space separated)<\/li>\n\n\n\n
- If a select type is specified, the display text will be extracted (multiple: space separated)<\/li>\n\n\n\n
- If an undefined data ID is specified,
#N\/A<\/code> will be output.<\/li>\n\n\n\n- If an unsupported data type is specified,
#TYPE!<\/code> will be output.<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Authorization settings for automated communication\n
- \n
- Add the client on the target Workflow Platform (server side) in advance. (System Admin privilege required)\n
- \n
- “API Clients” > “OAuth2 Clients” > “Add OAuth2 Client”<\/li>\n\n\n\n
- Redirect URL\n
- \n
https:\/\/s.questetra.net\/oauth2callback<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Add “HTTP Authorization Setting” for the Workflow app. (App Administrator privilege required)\n
- \n
- “App Settings” > (App Details) > “App” > “HTTP Authorization Setting > “Add”\n
- \n
OAuth2<\/code><\/li>\n\n\n\n- Name: (Any name)\n
- \n
- e.g.:
For TSV extraction<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Authorization Endpoint URL: (refer to the registration information on the server side)\n
- \n
- e.g.:
https:\/\/example.questetra.net\/oauth2\/authorize<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Token Endpoint URL: (refer to the registration information on the server side)\n
- \n
- e.g.:
https:\/\/example.questetra.net\/oauth2\/token<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n- Scope:
read<\/code>.<\/li>\n\n\n\n- Client ID: (refer to the server-side registration information)\n
- \n
- e.g.:
KXkYNxxxxXvJBmyyyyyIvEwuzzzzzli<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n- Client Secret: (refer to the server-side registration information)\n
- \n
- e.g.:
IHYWfxxxxxEZ1GuyyyyysdAM<\/code>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n- REST API Specification\n
- \n
- “Questetra Workflow API” (swagger)\n
- \n
- https:\/\/online-demo-en.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API<\/a><\/li>\n\n\n\n
- or “https:\/\/<\/a>{YOUR_PlatformId}.questetra.net\/s\/swagger\/index.html”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- There is another method for extracting business data via API: the ReportId method.\n
- \n
- Extraction conditions (Report) are saved in advance on the Workflow Platform where data is stored\n
- \n
- “Questetra BPMS: Process, Batch Extract by Filter as TSV”<\/li>\n\n\n\n
- https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Since you only need to specify Report Id, you can easily model aggregate operations.<\/li>\n\n\n\n
- However, if an item is added the number of columns in the extracted TSV will increase.<\/li>\n\n\n\n
- Also, the display order of the extracted TSVs is not reproduced. (You will need to reorder them.)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- or “https:\/\/<\/a>{YOUR_PlatformId}.questetra.net\/s\/swagger\/index.html”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- https:\/\/online-demo-en.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API<\/a><\/li>\n\n\n\n
- REST API Specification\n
- Client Secret: (refer to the server-side registration information)\n
- Scope:
- Token Endpoint URL: (refer to the registration information on the server side)\n
- Authorization Endpoint URL: (refer to the registration information on the server side)\n
- Name: (Any name)\n
- Add “HTTP Authorization Setting” for the Workflow app. (App Administrator privilege required)\n
- Title:
- Select:
- How to specify the data type\n
- Extraction CSV (e.g.:
- e.g.:
- The extraction items and their order are specified by CSV. (Extraction CSV)\n
- https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- e.g.:
- e.g.:
- e.g.:
- Process Start Date and Process End Date\n
- The output TSV text will be generated as the simplest tab-delimited string.\n
- If the target is the same platform, setting by variables is convenient. (System variable)\n
- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- <\/i><\/span> A1: Set Target Platform URL (eg. “${var[applicationRoot]}” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n