{"id":185231,"date":"2026-05-28T15:37:41","date_gmt":"2026-05-28T06:37:41","guid":{"rendered":"https:\/\/support.questetra.com\/?p=185231"},"modified":"2026-06-19T11:44:25","modified_gmt":"2026-06-19T02:44:25","slug":"questetra-bpms-cases-extract-by-report-id-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-cases-extract-by-report-id-2026\/","title":{"rendered":"Questetra BPMS #Cases: Extract by Report ID"},"content":{"rendered":"\n

Questetra BPMS #Cases: Extract by Report ID<\/strong><\/h4>\n\n\n\n

translate<\/span> Questetra BPMS #\u30b1\u30fc\u30b9: \u30ec\u30dd\u30fc\u30c8ID\u3067\u30c7\u30fc\u30bf\u62bd\u51fa<\/a><\/p>\n\n\n\n

Extracts case data via API in TSV format. The data is extracted using the ReportID of the filtered list configured in the Web UI and stored in TSV format. The order of the data columns is configured using a CSV file of data item IDs.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
AuthzConfU<\/dt>
U: Select HTTP_Authz Setting *<\/span><\/dd>\n
StrConfA1<\/dt>
A1: Set Workflow-platform URL (eg. “${var[applicationRoot]}” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA2<\/dt>
A2: Set ReportID (eg. “1234” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA3<\/dt>
A3: Set Max Num of Records (eg. “100” )#{EL}<\/sup><\/span><\/dd>\n
StrConfB0<\/dt>
B0: Set TSV Column Order using DataItemID (eg “0,1,3,0” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfB1<\/dt>
B1: Select STRING for Extracted TSV (update) *<\/span><\/dd>\n<\/div>\n
SelectConfB2<\/dt>
B2: Select NUMERIC for Extracted Count (update)<\/dd>\n
SelectConfB3<\/dt>
B3: Select NUMERIC for Total Count of List (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script for 'engine type: 3' ("GraalJS standard mode")\n\/\/ cf 'engine type: 2' renamed from "GraalJS" to "GraalJS Nashorn compatible mode" (at 20230526)\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst objAuthzSetting     = configs.getObject( "AuthzConfU" );   \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  engine.log( " AutomatedTask Config: Authz Setting: " + objAuthzSetting.getName() );\nconst strTargetUrl        = configs.get      ( "StrConfA1" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strTargetUrl      === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A1: TargetPlatformURL} is empty \\n" );\n  }\n  if( ! strTargetUrl.endsWith( "\/" ) ){\n    strTargetUrl += "\/";\n  }\nconst strReportId         = configs.get      ( "StrConfA2" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strReportId       === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A2: ReportID} is empty \\n" );\n  }\nlet   strLimit            = configs.get      ( "StrConfA3" );    \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n  if( strLimit          === "" ){\n      strLimit = "1000";\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 strColIds           = configs.get      ( "StrConfB0" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst strPocketTsv        = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst numPocketExtracted  = configs.getObject( "SelectConfB2" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\nconst numPocketFiltered   = configs.getObject( "SelectConfB3" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Some workflow data is referenced via Expression Language in Config.)\n\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Get Processes\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 = strTargetUrl + "API\/OR\/ProcessInstance\/list";\nlet request1    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1    = request1.authSetting( objAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n    request1    = request1.queryParam( "reportId", strReportId );\n    request1    = request1.queryParam( "limit", strLimit );\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\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\/\/ response1, parse\n\/* \n\n{\n  "count": 120,\n  "processInstances": [\n    {\n      "activeTokenNodeName": [\n        "\u30b7\u30b0\u30ca\u30eb\u5f85\u6a5f",\n        "\u505c\u6b62\u4f9d\u983c\u5f85\u6a5f"\n      ],\n      "data": {\n        "0": {\n          "dataType": "SELECT",\n          "formType": "SELECT",\n          "id": 144747204,\n          "processDataDefinitionNumber": 0,\n          "subType": null,\n          "value": [\n            {\n              "display": "Professional",\n              "value": "PROFESSIONAL"\n            }\n          ],\n          "viewOrder": 8\n        },\n        "25": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 144747206,\n          "processDataDefinitionNumber": 25,\n          "subType": null,\n          "value": "\u682a\u5f0f\u4f1a\u793e\u56db\u6b21\u5143\u30c7\u30fc\u30bf",\n          "viewOrder": 11\n        },\n        "3": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 144747207,\n          "processDataDefinitionNumber": 3,\n          "subType": null,\n          "value": "suzuki@example.net",\n          "viewOrder": 9\n        },\n      },\n      "parentProcessInstanceId": null,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2974547,\n      "processInstanceIdForView": "p2974547",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 30,\n      "processInstanceStartDatetime": "2026-05-27T11:25:34+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "\u682a\u5f0f\u4f1a\u793e\u56db\u6b21\u5143\u30c7\u30fc\u30bf",\n      "processModelId": 144353892,\n      "processModelInfoCategory": "6-\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8",\n      "processModelInfoId": 2078,\n      "processModelInfoName": "611-\u554f\u5408\u5bfe\u5fdc\u30d7\u30ed\u30bb\u30b9",\n      "processModelVersion": 222,\n      "starred": false\n    },\n    {\n      ...\n    },\n    {\n      ...\n    }\n  ]\n}\n*\/\n\nconst response1Obj = JSON.parse( response1Body );\nconst arrInstances = response1Obj.processInstances || [];\n\nengine.log( " AutomatedTask Parsed: Number of Received Instances: " + response1Obj.processInstances.length );\nengine.log( " AutomatedTask Parsed: Number of Total Instances: "    + response1Obj.count );\n\nconst arrColIds = parseColumnIds( strColIds );\nconst strTsv    = buildTsv( arrInstances, arrColIds );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData(   strPocketTsv,       strTsv );\nif(               numPocketExtracted  !== null ){\n  engine.setData( numPocketExtracted,  new java.math.BigDecimal( arrInstances.length ) );\n}\nif(               numPocketFiltered   !== null ){\n  engine.setData( numPocketFiltered,   new java.math.BigDecimal( response1Obj.count ) );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Function Definitions \/ \u95a2\u6570\u5b9a\u7fa9 ================================================\n\n\/**\n * Parses B0 CSV.\n * B0 is required and accepts Data Item IDs and the process-property names listed in the notes.\n *\/\nfunction parseColumnIds( strColIds ){\n  if( strColIds === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B0: TSV Column Order} is empty \\n" );\n  }\n\n  const arrColIds = strColIds.split( "," ).map(function( strColId ){\n    return strColId.trim();\n  });\n\n  for( let i = 0; i < arrColIds.length; i++ ){\n    if( arrColIds[i] === "" ){\n      throw new Error( "\\n AutomatedTask ConfigError:" +\n                       " Config {B0: TSV Column Order} contains an empty column ID \\n" );\n    }\n  }\n  return arrColIds;\n}\n\n\/**\n * Builds TSV lines according to the B0 column order.\n *\/\nfunction buildTsv( arrInstances, arrColIds ){\n  const arrLines = [];\n  for( let i = 0; i < arrInstances.length; i++ ){\n    const objInstance = arrInstances[i];\n    const arrCells    = [];\n    for( let j = 0; j < arrColIds.length; j++ ){\n      arrCells.push( stringifyColumn( objInstance, arrColIds[j] ) );\n    }\n    arrLines.push( arrCells.join( "\\t" ) );\n  }\n  return arrLines.join( "\\n" );\n}\n\nfunction stringifyColumn( objInstance, strColId ){\n  if( isProcessPropertyName( strColId ) ){\n    return sanitizeTsvCell( objInstance[strColId] );\n  }\n\n  const objDataItems = objInstance.data || {};\n  if( objDataItems[strColId] === undefined ){\n    return "";\n  }\n  return stringifyDataItem( objDataItems[strColId] );\n}\n\nfunction stringifyDataItem( objDataItem ){\n  if( objDataItem === null || objDataItem === undefined ){\n    return "";\n  }\n  if( objDataItem.value === null || objDataItem.value === undefined ){\n    return "";\n  }\n\n  const strDataType = objDataItem.dataType + "";\n  const value       = objDataItem.value;\n\n  if( strDataType === "SELECT" ){\n    return sanitizeTsvCell( joinValuesByProperty( value, "display" ) );\n  }\n  if( strDataType === "FILE" || strDataType === "FILE2" ){\n    return sanitizeTsvCell( joinValuesByProperty( value, "name" ) );\n  }\n  if( strDataType === "QUSER" ){\n    return sanitizeTsvCell( stringifyQuserOrQgroupValue( value ) );\n  }\n  if( strDataType === "QGROUP" ){\n    return sanitizeTsvCell( stringifyQuserOrQgroupValue( value ) );\n  }\n  if( strDataType === "STRING" ||\n      strDataType === "DECIMAL" ||\n      strDataType === "DATE" ||\n      strDataType === "DATETIME" ||\n      strDataType === "DISCUSSION" ){\n    return sanitizeTsvCell( value );\n  }\n\n  \/\/ Table type data and other unsupported data types are not extracted.\n  return "N\/A";\n}\n\nfunction joinValuesByProperty( value, strPropertyName ){\n  if( ! Array.isArray( value ) ){\n    if( typeof value === "object" && value !== null ){\n      return value[strPropertyName] || "";\n    }\n    return value;\n  }\n\n  const arrValues = [];\n  for( let i = 0; i < value.length; i++ ){\n    if( value[i] !== null && value[i] !== undefined ){\n      if( typeof value[i] === "object" ){\n        arrValues.push( value[i][strPropertyName] || "" );\n      }else{\n        arrValues.push( value[i] );\n      }\n    }\n  }\n  return arrValues.join( " " );\n}\n\nfunction stringifyQuserOrQgroupValue( value ){\n  if( Array.isArray( value ) ){\n    const arrValues = [];\n    for( let i = 0; i < value.length; i++ ){\n      arrValues.push( stringifyQuserOrQgroupValue( value[i] ) );\n    }\n    return arrValues.join( " " );\n  }\n  if( typeof value !== "object" || value === null ){\n    return value;\n  }\n\n  if( value.name    !== undefined && value.name    !== null ){ return value.name;    }\n  if( value.display !== undefined && value.display !== null ){ return value.display; }\n  if( value.qname   !== undefined && value.qname   !== null ){ return value.qname;   }\n  if( value.email   !== undefined && value.email   !== null ){ return value.email;   }\n\n  return JSON.stringify( value );\n}\n\nfunction sanitizeTsvCell( value ){\n  if( value === null || value === undefined ){\n    return "";\n  }\n  return ( value + "" ).replace( \/\\r?\\n\/g, " " ).replace( \/\\t\/g, " " );\n}\n\nfunction isProcessPropertyName( strColId ){\n  const objProcessProperties = {\n    "parentProcessInstanceId": true,\n    "processInstanceDebug": true,\n    "processInstanceEndDatetime": true,\n    "processInstanceId": true,\n    "processInstanceIdForView": true,\n    "processInstanceInitQgroupId": true,\n    "processInstanceInitQgroupName": true,\n    "processInstanceInitQuserId": true,\n    "processInstanceInitQuserName": true,\n    "processInstanceSequenceNumber": true,\n    "processInstanceStartDatetime": true,\n    "processInstanceState": true,\n    "processInstanceTitle": true,\n    "processModelId": true,\n    "processModelInfoCategory": true,\n    "processModelInfoId": true,\n    "processModelInfoName": true,\n    "processModelVersion": true,\n    "starred": true\n  };\n  return objProcessProperties[strColId] === true;\n}\n\n\n\/*\nNotes-en:\n- When a Case (Process Instance) arrives at this Automated Step, an extraction request is sent.\n    - The target Workflow Platform is set via URL. (REST API connection destination)\n        - `https:\/\/karasuma-oike-000.questetra.net\/`\n        - Note that a trailing `\/` is required.\n    - If the same Platform, you can substitute the URL by using a [System Variable].\n        - `${var[applicationRoot]}`\n- The extracted TSV is saved as the "simplest tab-separated string".\n    - TAB codes and newline codes within each data field are converted to " " (half-width spaces).\n    - Double quotes are also retained in an unescaped state.\n- Only the data displayed in the list specified by the `ReportID` will be stored. (However, the column order is random).\n    - Configure the TSV column order in B0 using Data Item IDs (`processDataDefinitionNumber`) as comma-separated values (CSV).\n        - Example: `0,47,2,8`\n    - To store property data of the Case (Process Instance) in a TSV column, set the following variable names instead of the Data Item ID. (Example: `processInstanceId,0,47,2,8`)\n        - Parent App Process Instance ID: `parentProcessInstanceId`\n        - Debug Mode: `processInstanceDebug` ("false" or "true")\n        - Issue End Datetime: `processInstanceEndDatetime`\n        - Issue ID: `processInstanceId` (eg: "1234")\n        - Issue ID (with 'p'): `processInstanceIdForView` (eg: "p1234")\n        - Starting User's Organization ID: `processInstanceInitQgroupId` (eg: "null")\n        - Starting User's Organization Name: `processInstanceInitQgroupName` (eg: "null")\n        - Starting User's User ID: `processInstanceInitQuserId` (eg: "null")\n        - Starting User's User Name: `processInstanceInitQuserName` (eg: "null")\n        - Sequence Number (Variable managed at the App level): `processInstanceSequenceNumber` (eg: "29")\n        - Issue Start Datetime: `processInstanceStartDatetime` (eg: "2026-05-26T08:55:40+0900")\n        - State: `processInstanceState` (eg: "STARTED")\n        - Title: `processInstanceTitle` (eg: "Inquiry OHTANI, Shohei")\n        - App ID (Process Model ID): `processModelId` (eg: "144353892")\n        - App Category Name: `processModelInfoCategory` (eg: "6-Marketing-Dept")\n        - App Category ID: `processModelInfoId` (eg: "2078")\n        - App Name (Process Model Name): `processModelInfoName` (eg: "611-Adv-Process")\n        - App Version: `processModelVersion` (eg: "222")\n        - App Starred (Favorited): `starred` (eg: "false")\n\nNotes-ja:\n- \u3053\u306e\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\u306b\u30b1\u30fc\u30b9\uff08\u6848\u4ef6\uff09\u304c\u5230\u9054\u3057\u305f\u969b\u3001\u62bd\u51fa\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u6295\u3052\u3089\u308c\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:\/\/karasuma-oike-000.questetra.net\/`\n        - \u672b\u5c3e\u306e `\/` \u304c\u5fc5\u8981\u3067\u3042\u308b\u70b9\u306b\u6ce8\u610f\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\uff3b\u30b7\u30b9\u30c6\u30e0\u5909\u6570\uff3d\u306b\u3088\u308b\u8a2d\u5b9a\u3067\u4ee3\u7528\u53ef\u80fd\u5229\u3067\u3059\u3002\n        - `${var[applicationRoot]}`\n- \u62bd\u51faTSV\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u683c\u7d0d\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- ReportID \u306f\u3001\u30ea\u30b9\u30c8\u8868\u793a\u6642\u306eURI\u672b\u5c3e\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - \n- ReportID \u3067\u6307\u5b9a\u3057\u305f\u30ea\u30b9\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3060\u3051\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\uff08\u305f\u3060\u3057\u5217\u9806\u4e0d\u540c\uff09\n    - TSV\u5217\u9806\u306f\u30c7\u30fc\u30bf\u9805\u76eeID\uff08processDataDefinitionNumber\uff09\u3092\u7528\u3044\u305fCSV\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n        - \u4f8b: `0,47,2,8`\n    - TSV\u5217\u306b\u30b1\u30fc\u30b9\uff08\u6848\u4ef6\uff09\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3055\u305b\u305f\u3044\u5834\u5408\u3001\u30c7\u30fc\u30bf\u9805\u76eeID\u306e\u4ee3\u308f\u308a\u306b\u6b21\u306e\u5909\u6570\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002 \uff08\u4f8b: `processInstanceId,0,47,2,8`\uff09\n        - \u89aa\u30a2\u30d7\u30ea\u306e\u30b1\u30fc\u30b9ID: `parentProcessInstanceId`\n        - \u30c7\u30d0\u30c3\u30b0\u30e2\u30fc\u30c9: `processInstanceDebug` ("false" or "true")\n        - \u30b1\u30fc\u30b9\u7d42\u4e86\u6642\u523b: `processInstanceEndDatetime`\n        - \u30b1\u30fc\u30b9ID: `processInstanceId` (eg:"1234")\n        - \u30b1\u30fc\u30b9ID(p\u4ed8): `processInstanceIdForView` (eg:"p1234")\n        - \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54ID: `processInstanceInitQgroupId` (eg:"null")\n        - \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54\u540d: `processInstanceInitQgroupName` (eg:"null")\n        - \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6ID: `processInstanceInitQuserId` (eg:"null")\n        - \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d: `processInstanceInitQuserName` (eg:"null")\n        - \u30b1\u30fc\u30b9\u9023\u756a(\u30a2\u30d7\u30ea\u30ec\u30d9\u30eb\u3067\u7ba1\u7406\u3055\u308c\u308b\u5909\u6570): `processInstanceSequenceNumber` (eg: "29")\n        - \u30b1\u30fc\u30b9\u958b\u59cb\u65e5\u6642: `processInstanceStartDatetime` (eg:"2026-05-26T08:55:40+0900")\n        - \u72b6\u614b: `processInstanceState` (eg:"STARTED")\n        - \u4ef6\u540d: `processInstanceTitle` (eg:"\u554f\u3044\u5408\u308f\u305b OHTANI, Shohei")\n        - \u30a2\u30d7\u30eaID: `processModelId` (eg:"144353892")\n        - \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30ea\u540d: `processModelInfoCategory` (eg:"6-\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8")\n        - \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30eaID: `processModelInfoId` (eg:"2078")\n        - \u30a2\u30d7\u30ea\u540d: `processModelInfoName` (eg:"611-\u5e83\u544a\u51fa\u7a3f\u30d7\u30ed\u30bb\u30b9")\n        - \u30a2\u30d7\u30ea\u540d: `processModelVersion` (eg:"222")\n        - \u30a2\u30d7\u30ea\u306e\u2605\u6709\u7121: `starred` (eg:"false")\n\n\nAPPENDIX-en\n- If the number of processes of the filter extraction result is 1000 or more, the data after 1001 will not be stored.\n    - Even if 1000 or less, there is a possibility of timeout when there are many data items.\n    - To control the number of extraction results\n        - Extract only the processes whose status status is `Running`\n        - Extract only the date data of the previous month\n            - After: `#today.addMonths(-1).getFirstTimeInMonth()`\n            - Before: `#today.addMonths(-1).getLastTimeInMonth()`\n- "HTTP Authorization Setting" is required for automatic communication (OAuth2 API connection).\n    - Register [API Client] (OAuth2) in advance as the connection destination. (Requires System Admin privileges)\n        - Scope\n            - Read-only API Access\n        - Redirect URL\n            - `https:\/\/s.questetra.net\/oauth2callback`\n        - Make a __note__ of your registration details.\n            - Client ID\n            - Client Secret (Consumer Secret)\n            - Authorization Endpoint URL\n            - Token Endpoint URL\n    - Set "HTTP Authorization Setting" in the App as client. (Select this setting name in Addon config)\n        - Authorization Endpoint URL:\n            - _(See your note above)_\n            - Example: `https:\/\/example.questetra.net\/oauth2\/authorize`\n        - Token Endpoint URL:\n            - _(See your note above)_\n            - Example: `https:\/\/example.questetra.net\/oauth2\/token`\n        - Scope:\n            - `read`\n        - Client ID\n            - _(See your note above)_\n        - Client Secret:\n            - _(See your note above)_\n- Table type data is not supported for extraction.\n    - If an unsupported type, "`N\/A`" is output.\n    - The file names are extracted for the File type. (Multiple: Space-separated)\n    - The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)\n\n\nAPPENDIX-ja:\n- \u30d5\u30a3\u30eb\u30bf\u62bd\u51fa\u7d50\u679c\u306e\u6848\u4ef6\u6570\uff08\u30d7\u30ed\u30bb\u30b9\u6570\uff09\u304c1000\u4ef6\u4ee5\u4e0a\u3042\u308b\u5834\u5408\u30011001\u4ef6\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u306f\u683c\u7d0d\u3055\u308c\u307e\u305b\u3093\u3002\n    - \u62bd\u51fa\u7d50\u679c\u304c1000\u4ef6\u4ee5\u4e0b\u3068\u306a\u308b\u30b1\u30fc\u30b9\u3067\u3082\u3001\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u6570\u304c\u591a\u3044\u5834\u5408\u306a\u3069\u3001\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n    - \u62bd\u51fa\u7d50\u679c\u306e\u6570\u3092\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3059\u308b\u5de5\u592b\n        - \u72b6\u614b\u30b9\u30c6\u30fc\u30bf\u30b9\u304c `\u672a\u7d42\u4e86` \u306e\u6848\u4ef6\uff08\u30d7\u30ed\u30bb\u30b9\uff09\u306b\u7d5e\u3063\u3066\u62bd\u51fa\u3059\u308b\n        - \u6848\u4ef6\u5185\u306e\u65e5\u4ed8\u30c7\u30fc\u30bf\u304c\u524d\u6708\u306e\u3082\u306e\u306b\u7d5e\u3063\u3066\u62bd\u51fa\u3059\u308b\n            - \u4ee5\u964d\/After: `#today.addMonths(-1).getFirstTimeInMonth()`\n            - \u4ee5\u524d\/Before: `#today.addMonths(-1).getLastTimeInMonth()`\n- \u81ea\u52d5\u901a\u4fe1\uff08OAuth2 API\u63a5\u7d9a\uff09\u306e\u305f\u3081\u306b "HTTP\u8a8d\u8a3c\u8a2d\u5b9a" \u304c\u5fc5\u8981\u3067\u3059\u3002\n    - \u3042\u3089\u304b\u3058\u3081\u63a5\u7d9a\u5148\u306b\u3001\uff3bAPI\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff3d\uff08OAuth2\uff09\u3092\u767b\u9332\u3057\u307e\u3059\u3002\uff08\u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u8005\u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\uff09\n        - \u30b9\u30b3\u30fc\u30d7\uff08Scope\uff09\n            - \u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b API \u3078\u306e\u30a2\u30af\u30bb\u30b9 \/ Read-only API Access\n        - \u30ea\u30c0\u30a4\u30ec\u30af\u30c8URL\uff08Redirect URL\uff09\n            - `https:\/\/s.questetra.net\/oauth2callback`\n        - \u767b\u9332\u5185\u5bb9\u3092 __\u30e1\u30e2__ \u3057\u307e\u3059\u3002\n            - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\uff08Client ID\uff09\n            - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\uff08Consumer Secret\uff09\n            - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff08Authorization Endpoint URL\uff09\n            - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff08Token Endpoint URL\uff09\n    - \u901a\u4fe1\u5143\u3067\u3042\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u306b\u3066\uff3bHTTP\u8a8d\u8a3c\u8a2d\u5b9a\uff3d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08\u3053\u306e\u8a2d\u5b9a\u540d\u3092Addon\u30b3\u30f3\u30d5\u30a3\u30b0\u3067\u9078\u629e\uff09\n        - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8 URL:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n            - \u4f8b\uff1a `https:\/\/example.questetra.net\/oauth2\/authorize`\n        - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8 URL:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n            - \u4f8b\uff1a `https:\/\/example.questetra.net\/oauth2\/token`\n        - \u30b9\u30b3\u30fc\u30d7:\n            - `read`\n        - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n        - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n- \u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u5185\u306e\u30c7\u30fc\u30bf\u306f\u62bd\u51fa\u30b5\u30dd\u30fc\u30c8\u5916\u3067\u3059\u3002\n    - \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u306f "`N\/A`" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\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\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n