Questetra BPMS: Process, Extract as TSV<\/div>
Extracts process data as a single-line TSV string. Items are specified in a CSV format such as “0,2,3”. Tab code and line feed code are automatically deleted. The File-type extracts the file name, and the Select-type extracts the displayed text of the selected choices. Discussion-type, Table-type and Guide-Panel type cannot be extracted (Warning Log).<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> B: Set WF Platform URL (${var[applicationRoot]} or https:\/\/<\/a>..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C: Set Process ID ( e.g., “123” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> D: Set DataItem IDs to Extract ( e.g., “0,2,3” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> E: Select STRING DATA for Extracted TSV (update)<\/li>\n
- <\/i><\/span> F: Select STRING DATA for Extracted TSV (append)<\/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\/\/ about Questetra Workflow API\n\/\/ See https:\/\/online-demo-ja.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API\n\/\/ or "https:\/\/{YOUR}.questetra.net\/s\/swagger\/index.html"\n\n\/\/ about Questetra OAuth2 (for System Admin)\n\/\/ Get ID&Secret: System Settings > API Clients > OAuth2 Clients > Add OAuthw Client\n\/\/ (config "Redirect URL" = "https:\/\/s.questetra.net\/oauth2callback" )\n\/\/ (Scope: "read" or "any" )\n\/\/ Set ID&Secret: Workflow App > Detail > OAuth2 Setting > (Get Refresh Token)\n\n\/\/ Notes:\n\/\/ Tab code and line feed code in Workflow data will be deleted.\n\/\/ Workflow\u30c7\u30fc\u30bf\u5185\u306e\u30bf\u30d6\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u62bd\u51fa\u6642\u306b\u524a\u9664\u3055\u308c\u307e\u3059\n\/\/ Specify "Title" to extract Title and "Id" to extract ID. ( e.g. "Title,Id,0,2,3" )\n\/\/ \u6848\u4ef6\u30bf\u30a4\u30c8\u30eb\u306e\u62bd\u51fa\u306b\u306f "Title" \u3092\u3001ID\u306e\u62bd\u51fa\u306b\u306f "Id" \u3092\u6307\u5b9a\u3057\u307e\u3059 ( \u4f8b "Title,Id,0,2,3" )\n\/\/ If an undefined dataitem ID or Guide Panel ID is specified, "#N\/A" is output.\n\/\/ \u672a\u5b9a\u7fa9\u306e\u30c7\u30fc\u30bf\u9805\u76eeID\u3084\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u306eID\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001"#N\/A" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n\/\/ If an unsupported type is specified, "#TYPE!" is output.\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\/\/ The file names are extracted for the File type. (Multiple: Space-separated)\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\/\/ The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)\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\/\/ It supports loop processing.\n\/\/ \u30eb\u30fc\u30d7\u51e6\u7406\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\uff08\u62bd\u51fa\u7d50\u679c\u306e\u8ffd\u8a18\uff09\n\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 applicationRoot = configs.get( "conf_ApplicationRoot" ) + ""; \/\/ required\nconst processId = configs.get( "conf_ProcessId" ) + ""; \/\/ required\nconst dataitemIds = configs.get( "conf_DataitemIds" ) + ""; \/\/ required\nconst dataIdE = configs.get( "conf_DataIdE" ) + ""; \/\/ not required\nconst dataIdF = configs.get( "conf_DataIdF" ) + ""; \/\/ not required\n\/\/ 'java.lang.String' (String Obj) to javascript primitive 'string'\n\nengine.log( " AutomatedTask Config: Application Root: " + applicationRoot );\nengine.log( " AutomatedTask Config: Process ID: " + processId );\nengine.log( " AutomatedTask Config: Dataitem IDs: " + dataitemIds );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet strBeforeAppend = engine.findDataByNumber( dataIdF );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ get ProcessInstance via Questetra Workflow API\n\/\/ com.questetra.bpms.core.event.scripttask.HttpClientWrapper\nlet apiRequest = httpClient.begin(); \/\/ HttpRequestWrapper\n apiRequest = apiRequest.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n apiRequest = apiRequest.queryParam( "processInstanceId", processId );\nconst apiUri = applicationRoot + "API\/OR\/ProcessInstance\/view";\n\n\/\/ request to API\nengine.log( " AutomatedTask Trying: GET " + apiUri );\nconst response = apiRequest.get( apiUri );\nconst responseCode = response.getStatusCode() + "";\nengine.log( " AutomatedTask ApiResponse: Status " + responseCode );\nif( responseCode !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n responseCode + "\\n" + response.getResponseAsString() + "\\n" );\n}\nconst responseStr = response.getResponseAsString() + "";\nconst responseObj = JSON.parse( responseStr );\n\/\/engine.log( responseStr ); \/\/test\n\n\/\/ retrieve JSON\nlet strNewline = "";\nlet arrDataitemIds = dataitemIds.split(","); \/\/ e.g. "Title,Id,0,2,3"\nfor( let i = 0; i < arrDataitemIds.length; i++ ){\n if( arrDataitemIds[i] === "Id" ){\n strNewline += responseObj.processInstance.processInstanceId;\n }else if( arrDataitemIds[i] === "Title" ){\n if( responseObj.processInstance.processInstanceTitle !== null ){\n strNewline += responseObj.processInstance.processInstanceTitle;\n }\n }else{\n if( responseObj.processInstance.data[ arrDataitemIds[i] ] == undefined ){\n strNewline += "#N\/A";\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "STRING" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DECIMAL" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DATE" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "DATETIME" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "QUSER" || \n responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "QGROUP" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n }\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "SELECT" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n for( let j = 0; j < responseObj.processInstance.data[ arrDataitemIds[i] ].value.length; j++ ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value[j].display\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== responseObj.processInstance.data[ arrDataitemIds[i] ].value.length - 1 ){\n strNewline += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else if( responseObj.processInstance.data[ arrDataitemIds[i] ].dataType === "FILE2" ){\n if( responseObj.processInstance.data[ arrDataitemIds[i] ].value !== null ){\n for( let j = 0; j < responseObj.processInstance.data[ arrDataitemIds[i] ].value.length; j++ ){\n strNewline += responseObj.processInstance.data[ arrDataitemIds[i] ].value[j].name\n .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n if( j !== responseObj.processInstance.data[ arrDataitemIds[i] ].value.length - 1 ){\n strNewline += " "; \/\/ (Multiple: Space-separated)\n }\n }\n }\n }else{\n strNewline += "#TYPE!";\n }\n }\n if( i !== arrDataitemIds.length - 1 ){\n strNewline += "\\t";\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strNewline === "" ){\n engine.log( " AutomatedTask DataUpdating: Extracted Text empty" );\n}\nif( dataIdE !== "" ){ \n engine.setDataByNumber( dataIdE, strNewline );\n}\nif( dataIdF !== "" ){ \n if( strBeforeAppend !== null ){\n engine.setDataByNumber( dataIdF, strBeforeAppend + "\\n" + strNewline );\n }else{\n engine.setDataByNumber( dataIdF, strNewline );\n }\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\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-Extract-as-TSV.xml<\/a><\/li>\n\n\n\n
- Questetra-BPMS-Process-Extract-as-TSV-2023.xml<\/a>\n
- \n
- 2023-08-21 (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-Extract-as-TSV-2026.xml<\/a>\n
- \n
- 2026-05-22 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- the deprecation of the method
authSetting(String)<\/code> at v18.0<\/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
2021-07-01 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/questetra-bpms-process-extract-as-tsv-2021\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Tab code and line feed code in the Workflow data will be deleted during extraction.<\/li>\n\n\n\n
- Specify “Title” to extract Title and “Id” to extract ID ( e.g. “Title,Id,0,2,3” ).<\/li>\n\n\n\n
- If an undefined Data Item ID or Guide Panel ID is specified, “#N\/A” will be output.<\/li>\n\n\n\n
- If an unsupported type is specified, “#TYPE!” will be output.<\/li>\n\n\n\n
- When a file type is specified, the file name will be extracted (multiple: Space-separated).<\/li>\n\n\n\n
- When the selection type is specified, the displayed text will be extracted (multiple: Space-separated).<\/li>\n\n\n\n
- Loop processing is supported (adding the extraction results).<\/li>\n<\/ol>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/extract-as-tsv-en.png?ssl=1\")
<\/figure>\n\n\n\n![\"Extracts](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- Questetra-BPMS-Process-Extract-as-TSV-2023.xml<\/a>\n
- <\/i><\/span> B: Set WF Platform URL (${var[applicationRoot]} or https:\/\/<\/a>..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n