{"id":185963,"date":"2026-06-02T16:30:39","date_gmt":"2026-06-02T07:30:39","guid":{"rendered":"https:\/\/support.questetra.com\/?p=185963"},"modified":"2026-06-16T11:36:23","modified_gmt":"2026-06-16T02:36:23","slug":"questetra-bpms-tasks-extract-by-report-id-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-tasks-extract-by-report-id-2026\/","title":{"rendered":"Questetra BPMS #\u30bf\u30b9\u30af\u51e6\u7406: \u30ec\u30dd\u30fc\u30c8ID\u3067\u30c7\u30fc\u30bf\u62bd\u51fa"},"content":{"rendered":"\n

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

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

\u30bf\u30b9\u30af\u30c7\u30fc\u30bf\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\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\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, 10) ) || parseInt(strLimit, 10) < 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, 10) > 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\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Get Workitems\n\/\/ request1, prepare\nlet request1Uri = strTargetUrl + "API\/OR\/Workitem\/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\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 );\nconst arrWorkitems = response1Obj.workitems || [];\n\nengine.log( " AutomatedTask Parsed: Number of Received Workitems: " + arrWorkitems.length );\nengine.log( " AutomatedTask Parsed: Number of Total Workitems: "    + response1Obj.count );\n\nconst arrColIds = parseColumnIds( strColIds );\nconst strTsv    = buildTsv( arrWorkitems, 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( arrWorkitems.length ) );\n}\nif(               numPocketFiltered   !== null ){\n  engine.setData( numPocketFiltered,   new java.math.BigDecimal( response1Obj.count ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Sample Response \/ \u30ec\u30b9\u30dd\u30f3\u30b9\u30b5\u30f3\u30d7\u30eb ================================================\n\/* \n{\n  "count": 55,\n  "workitems": [\n    {\n      "allocateDatetime": "2026-05-29T10:00:17+0900",\n      "allocatedQgroupId": 3,\n      "allocatedQgroupName": "Sales",\n      "allocatedQuserId": 473,\n      "allocatedQuserName": "\u7530\u4e2d \u82b1\u5b50",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 143855494,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": "2026-05-29 11:00",\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 143855497,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "samplechem202605",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 143855498,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": "\u7530\u4e2d \u82b1\u5b50 \\u003Ctanaka.hanako@example.com\\u003E",\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144978825,\n      "nodeName": "3.\u5b9f\u65bd\u5831\u544a\u3000 (\u898b\u8fbc\u6848\u4ef6\u767b\u9332)",\n      "nodeNumber": 7,\n      "offerDatetime": "2026-05-29T10:00:17+0900",\n      "parentProcessInstanceId": 2965305,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2965365,\n      "processInstanceIdForView": "p2965365",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1023,\n      "processInstanceStartDatetime": "2026-05-21T16:26:51+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e 2026-05-29 11:00",\n      "processModelId": 143449093,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 104,\n      "read": false,\n      "starred": false,\n      "startDatetime": null,\n      "state": "ALLOCATED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": null\n    },\n    {\n      "allocateDatetime": "2026-05-29T10:00:16+0900",\n      "allocatedQgroupId": null,\n      "allocatedQgroupName": null,\n      "allocatedQuserId": 16,\n      "allocatedQuserName": "\u4f50\u85e4 \u592a\u90ce",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 143855494,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": "2026-05-29 11:00",\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 143855497,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "samplechem202605",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 143855498,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": "\u7530\u4e2d \u82b1\u5b50 \\u003Ctanaka.hanako@example.com\\u003E",\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144978807,\n      "nodeName": "3b.\u540c\u5e2d\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af",\n      "nodeNumber": 37,\n      "offerDatetime": "2026-05-29T10:00:16+0900",\n      "parentProcessInstanceId": 2965305,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2965365,\n      "processInstanceIdForView": "p2965365",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1023,\n      "processInstanceStartDatetime": "2026-05-21T16:26:51+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e 2026-05-29 11:00",\n      "processModelId": 143449093,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 104,\n      "read": false,\n      "starred": false,\n      "startDatetime": null,\n      "state": "ALLOCATED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": "2026-06-01T11:00:00+0900"\n    },\n    {\n      "allocateDatetime": "2026-05-29T07:56:27+0900",\n      "allocatedQgroupId": 3,\n      "allocatedQgroupName": "Sales",\n      "allocatedQuserId": 16,\n      "allocatedQuserName": "\u4f50\u85e4 \u592a\u90ce",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 144974395,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": null,\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 144974398,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "sample-lead-001",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 144974399,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": null,\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144974447,\n      "nodeName": "0. FollowUp (FirstTouch)",\n      "nodeNumber": 63,\n      "offerDatetime": "2026-05-29T07:56:27+0900",\n      "parentProcessInstanceId": 2976616,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2976911,\n      "processInstanceIdForView": "p2976911",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1047,\n      "processInstanceStartDatetime": "2026-05-29T07:56:25+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "LEAD \u5c71\u7530 \u4e00\u90ce 2026-05-29 sample-lead-001",\n      "processModelId": 144422810,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 106,\n      "read": false,\n      "starred": false,\n      "startDatetime": "2026-05-29T08:12:37+0900",\n      "state": "STARTED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": null\n    }\n  ]\n}\n*\/\n\n\n\n\/\/\/\/ == Function Definitions \/ \u95a2\u6570\u5b9a\u7fa9 ================================================\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\nfunction buildTsv( arrWorkitems, arrColIds ){\n  const arrLines = [];\n  for( let i = 0; i < arrWorkitems.length; i++ ){\n    const objWorkitem = arrWorkitems[i];\n    const arrCells    = [];\n    for( let j = 0; j < arrColIds.length; j++ ){\n      arrCells.push( stringifyColumn( objWorkitem, arrColIds[j] ) );\n    }\n    arrLines.push( arrCells.join( "\\t" ) );\n  }\n  return arrLines.join( "\\n" );\n}\n\nfunction stringifyColumn( objWorkitem, strColId ){\n  if( isWorkitemPropertyName( strColId ) ){\n    return sanitizeTsvCell( objWorkitem[strColId] );\n  }\n\n  const objDataItems = objWorkitem.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" || 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  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 isWorkitemPropertyName( strColId ){\n  const objProperties = {\n    "allocateDatetime": true,\n    "allocatedQgroupId": true,\n    "allocatedQgroupName": true,\n    "allocatedQuserId": true,\n    "allocatedQuserName": true,\n    "directAllocated": true,\n    "endDatetime": true,\n    "failType": true,\n    "id": true,\n    "nodeName": true,\n    "nodeNumber": true,\n    "offerDatetime": true,\n    "read": true,\n    "startDatetime": true,\n    "state": true,\n    "swimlaneType": true,\n    "timeLimitDatetime": true,\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 objProperties[strColId] === true;\n}\n\n\/*\n### Notes-en:\n- When a Workitem arrives at this Automated Step, an extraction request is sent.\n- Target URL requires a trailing `\/`.\n- The extracted TSV is saved as the "simplest tab-separated string".\n- Only the data displayed in the list specified by the `ReportID` will be stored.\n- Configure the TSV column order in B0 using Data Item IDs (CSV).\n    - Example: `0,47,2,8`\n- To store property data of the Task (Workitem) or Case (Process Instance) in a TSV column, set the following variable names instead of the Data Item ID. (Example: `id,state,processInstanceId,0,47`)\n    - Workitem ID: `id` (eg: "144978825")\n    - Workitem Node\/Step Name: `nodeName` (eg: "3.\u5b9f\u65bd\u5831\u544a")\n    - Workitem Node\/Step Number: `nodeNumber` (eg: "7")\n    - Workitem State: `state` (eg: "ALLOCATED")\n    - Workitem Allocated User ID: `allocatedQuserId`\n    - Workitem Allocated User Name: `allocatedQuserName`\n    - Issue ID: `processInstanceId` (eg: "2965365")\n    - Title: `processInstanceTitle` (eg: "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n    - ...and other Process Instance properties.\n\n#### Task (Workitem) Properties\n- `allocateDatetime`: Task allocation datetime (eg: "2026-05-29T10:00:17+0900")\n- `allocatedQgroupId`: Allocated Qgroup ID (eg: "3")\n- `allocatedQgroupName`: Allocated Qgroup Name (eg: "Sales")\n- `allocatedQuserId`: Allocated Quser ID (eg: "473")\n- `allocatedQuserName`: Allocated Quser Name (eg: "SUZUKI, Ichiro")\n- `directAllocated`: Direct allocation flag ("true" or "false")\n- `endDatetime`: Task end datetime (Processing completed time)\n- `failType`: Failure type (null if success)\n- `id`: Workitem (Task) ID (eg: "144978825")\n- `nodeName`: Step \/ Node Name (eg: "3.\u5b9f\u65bd\u5831\u544a")\n- `nodeNumber`: Step \/ Node Number (eg: "7")\n- `offerDatetime`: Task offered datetime (eg: "2026-05-29T10:00:17+0900")\n- `read`: Read flag ("true" or "false")\n- `startDatetime`: Task start datetime (Processing started time)\n- `state`: Task State (eg: "OFFERED", "ALLOCATED", "STARTED", "ENDED")\n- `swimlaneType`: Swimlane Type (eg: "NORMAL")\n- `timeLimitDatetime`: Task time limit datetime\n\n#### Case (Process Instance) Properties\n- `parentProcessInstanceId`: Parent App Process Instance ID\n- `processInstanceDebug`: Debug Mode ("false" or "true")\n- `processInstanceEndDatetime`: Case End Datetime\n- `processInstanceId`: Case ID (eg: "2965365")\n- `processInstanceIdForView`: Case ID with 'p' (eg: "p2965365")\n- `processInstanceInitQgroupId`: Starting User's Organization ID\n- `processInstanceInitQgroupName`: Starting User's Organization Name\n- `processInstanceInitQuserId`: Starting User's User ID\n- `processInstanceInitQuserName`: Starting User's User Name\n- `processInstanceSequenceNumber`: Sequence Number managed at App level (eg: "1023")\n- `processInstanceStartDatetime`: Case Start Datetime (eg: "2026-05-21T16:26:51+0900")\n- `processInstanceState`: Case State (eg: "STARTED")\n- `processInstanceTitle`: Case Title (eg: "DEMO Sample Chemical...")\n- `processModelId`: App ID \/ Process Model ID\n- `processModelInfoCategory`: App Category Name (eg: "5-\u55b6\u696d\u90e8")\n- `processModelInfoId`: App Category ID (eg: "3713")\n- `processModelInfoName`: App Name \/ Process Model Name\n- `processModelVersion`: App Version (eg: "104")\n- `starred`: App Starred ("false" or "true")\n\n### Notes-ja:\n- \u3053\u306e\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\u306b\u30bf\u30b9\u30af\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\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\u30bf\u30b9\u30af\u30ea\u30b9\u30c8\u8868\u793a\u6642\u306eURI\u672b\u5c3e\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - `https:\/\/example.questetra.net\/OR\/Workitem\/listView?reportId=123456789`\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\u3092\u7528\u3044\u305fCSV\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08\u4f8b: `0,47,2,8`\uff09\n    - TSV\u5217\u306b\u30bf\u30b9\u30af\u51e6\u7406\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: `id,state,processInstanceId,0,47`\uff09\n        - \u30bf\u30b9\u30afID: `id` (eg: "144978825")\n        - \u5de5\u7a0b\u540d: `nodeName` (eg: "3.\u5b9f\u65bd\u5831\u544a")\n        - \u5de5\u7a0b\u30ca\u30f3\u30d0\u30fc: `nodeNumber` (eg: "7")\n        - \u30bf\u30b9\u30af\u72b6\u614b: `state` (eg: "ALLOCATED" \u307e\u305f\u306f "OFFERED" \u306a\u3069)\n        - \u5272\u5f53\u30e6\u30fc\u30b6\u30fcID: `allocatedQuserId`\n        - \u5272\u5f53\u30e6\u30fc\u30b6\u30fc\u540d: `allocatedQuserName`\n        - \u30b1\u30fc\u30b9ID: `processInstanceId` (eg:"2965365")\n        - \u4ef6\u540d: `processInstanceTitle` (eg:"DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n        - ...\u305d\u306e\u4ed6\u30d7\u30ed\u30bb\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30d7\u30ed\u30d1\u30c6\u30a3\u3082\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002\n\n#### \u30bf\u30b9\u30af\u51e6\u7406\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\uff09\u30d7\u30ed\u30d1\u30c6\u30a3\u3011\n- \u30bf\u30b9\u30af\u5272\u5f53\u65e5\u6642: `allocateDatetime` (\u4f8b: "2026-05-29T10:00:17+0900")\n- \u5272\u5f53\u7d44\u7e54ID: `allocatedQgroupId` (\u4f8b: "3")\n- \u5272\u5f53\u7d44\u7e54\u540d: `allocatedQgroupName` (\u4f8b: "Sales")\n- \u5272\u5f53\u30e6\u30fc\u30b6ID: `allocatedQuserId` (\u4f8b: "473")\n- \u5272\u5f53\u30e6\u30fc\u30b6\u540d: `allocatedQuserName` (\u4f8b: "\u9234\u6728 \u30a4\u30c1\u30ed\u30fc")\n- \u76f4\u63a5\u5272\u5f53\u30d5\u30e9\u30b0: `directAllocated` ("true" \u307e\u305f\u306f "false")\n- \u30bf\u30b9\u30af\u7d42\u4e86\u65e5\u6642(\u51e6\u7406\u65e5\u6642): `endDatetime`\n- \u5931\u6557\u30bf\u30a4\u30d7: `failType`\n- \u30bf\u30b9\u30afID: `id` (\u4f8b: "144978825")\n- \u5de5\u7a0b\u540d: `nodeName` (\u4f8b: "3.\u5b9f\u65bd\u5831\u544a")\n- \u5de5\u7a0b\u30ca\u30f3\u30d0\u30fc: `nodeNumber` (\u4f8b: "7")\n- \u53d7\u4ed8\u958b\u59cb\u65e5\u6642(\u30aa\u30d5\u30a1\u30fc\u65e5\u6642): `offerDatetime` (\u4f8b: "2026-05-29T10:00:17+0900")\n- \u65e2\u8aad\u30d5\u30e9\u30b0: `read` ("true" \u307e\u305f\u306f "false")\n- \u30bf\u30b9\u30af\u51e6\u7406\u958b\u59cb\u65e5\u6642: `startDatetime`\n- \u30bf\u30b9\u30af\u72b6\u614b: `state` (\u4f8b: "OFFERED", "ALLOCATED", "STARTED", "ENDED", "FAILED")\n- \u30b9\u30a4\u30e0\u30ec\u30fc\u30f3\u30bf\u30a4\u30d7: `swimlaneType` (\u4f8b: "NORMAL")\n- \u30bf\u30b9\u30af\u51e6\u7406\u671f\u9650\u65e5\u6642: `timeLimitDatetime`\n\n#### \u30b1\u30fc\u30b9\uff08\u6848\u4ef6\u30fb\u30d7\u30ed\u30bb\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\uff09\u30d7\u30ed\u30d1\u30c6\u30a3\n- \u89aa\u30a2\u30d7\u30ea\u306e\u30b1\u30fc\u30b9ID: `parentProcessInstanceId`\n- \u30c7\u30d0\u30c3\u30b0\u30e2\u30fc\u30c9: `processInstanceDebug` ("false" \u307e\u305f\u306f "true")\n- \u30b1\u30fc\u30b9\u7d42\u4e86\u6642\u523b: `processInstanceEndDatetime`\n- \u30b1\u30fc\u30b9ID: `processInstanceId` (\u4f8b: "2965365")\n- \u30b1\u30fc\u30b9ID(p\u4ed8): `processInstanceIdForView` (\u4f8b: "p2965365")\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54ID: `processInstanceInitQgroupId`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54\u540d: `processInstanceInitQgroupName`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6ID: `processInstanceInitQuserId`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d: `processInstanceInitQuserName`\n- \u30b1\u30fc\u30b9\u9023\u756a(\u30a2\u30d7\u30ea\u30ec\u30d9\u30eb\u3067\u7ba1\u7406\u3055\u308c\u308b\u5909\u6570): `processInstanceSequenceNumber` (\u4f8b: "1023")\n- \u30b1\u30fc\u30b9\u958b\u59cb\u65e5\u6642: `processInstanceStartDatetime` (\u4f8b: "2026-05-21T16:26:51+0900")\n- \u72b6\u614b: `processInstanceState` (\u4f8b: "STARTED", "ENDED", "FAILED" )\n- \u4ef6\u540d: `processInstanceTitle` (\u4f8b: "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n- \u30a2\u30d7\u30eaID: `processModelId` (\u4f8b: "143449093")\n- \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30ea\u540d: `processModelInfoCategory` (\u4f8b: "5-\u55b6\u696d\u90e8")\n- \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30eaID: `processModelInfoId` (\u4f8b: "3713")\n- \u30a2\u30d7\u30ea\u540d: `processModelInfoName` (\u4f8b: "552-NEW-Lead-Followup...")\n- \u30a2\u30d7\u30ea\u30d0\u30fc\u30b8\u30e7\u30f3: `processModelVersion` (\u4f8b: "104")\n- \u30a2\u30d7\u30ea\u306e\u2605\u6709\u7121: `starred` ("false" \u307e\u305f\u306f "true")\n\n\n### APPENDIX-en\n- If the number of tasks 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\n### APPENDIX-ja:\n- \u30d5\u30a3\u30eb\u30bf\u62bd\u51fa\u7d50\u679c\u306e\u30bf\u30b9\u30af\u51e6\u7406\u6570\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\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\u5834\u5408\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