{"id":185245,"date":"2026-05-28T15:45:18","date_gmt":"2026-05-28T06:45:18","guid":{"rendered":"https:\/\/support.questetra.com\/?p=185245"},"modified":"2026-06-03T12:34:48","modified_gmt":"2026-06-03T03:34:48","slug":"questetra-bpms-cases-extract-by-report-id-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-cases-extract-by-report-id-2026\/","title":{"rendered":"Questetra BPMS #\u30b1\u30fc\u30b9: \u30ec\u30dd\u30fc\u30c8ID\u3067\u30c7\u30fc\u30bf\u62bd\u51fa"},"content":{"rendered":"\n

Questetra BPMS #\u30b1\u30fc\u30b9: \u30ec\u30dd\u30fc\u30c8ID\u3067\u30c7\u30fc\u30bf\u62bd\u51fa<\/strong><\/h4>\n\n\n\n

translate<\/span> Questetra BPMS #Cases: Extract by Report ID<\/a><\/p>\n\n\n\n

\u6848\u4ef6\u30c7\u30fc\u30bf\uff08\u30b1\u30fc\u30b9\u30c7\u30fc\u30bf\uff09\u3092API\u7d4c\u7531\u3067TSV\u62bd\u51fa\u3057\u307e\u3059\u3002Web UI \u3067\u7d5e\u308a\u8fbc\u307f\u8a2d\u5b9a\u3055\u308c\u305f\u30ea\u30b9\u30c8\u306e ReportID \u3092\u4f7f\u7528\u3057\u3066\u62bd\u51fa\u3057\u3001TSV \u5f62\u5f0f\u3067\u683c\u7d0d\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u5217\u306e\u4e26\u3073\u306f\u30c7\u30fc\u30bf\u9805\u76eeID\u306eCSV\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
AuthzConfU<\/dt>
U: HTTP\u8a8d\u8a3c\u8a2d\u5b9a\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span><\/dd>\n
StrConfA1<\/dt>
A1: \u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u5148\u306eWF\u57fa\u76e4URL\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “${var[applicationRoot]}” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA2<\/dt>
A2: ReportID \u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “1234” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA3<\/dt>
A3: \u62bd\u51fa\u30ec\u30b3\u30fc\u30c9\u6570\u306e\u6700\u5927\u5024\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “100” )#{EL}<\/sup><\/span><\/dd>\n
StrConfB0<\/dt>
B0: \u62bd\u51faTSV\u5217\u306e\u4e26\u3073\u9806\u3092\u30c7\u30fc\u30bf\u9805\u76eeID\u3067\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “0,1,3,0” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfB1<\/dt>
B1: \u62bd\u51faTSV\u3092\u683c\u7d0d\u3059\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0) *<\/span><\/dd>\n<\/div>\n
SelectConfB2<\/dt>
B2: \u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfB3<\/dt>
B3: \u5143\u30ea\u30b9\u30c8\u306e\u7dcf\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/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\/ja\/articles\/360014835832-M418\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/ja\/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\/ja\/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