{"id":113093,"date":"2021-09-15T11:39:48","date_gmt":"2021-09-15T02:39:48","guid":{"rendered":"https:\/\/support.questetra.com\/?p=113093"},"modified":"2026-03-18T16:22:35","modified_gmt":"2026-03-18T07:22:35","slug":"questetra-bpms-process-batch-extract-by-filter-as-tsv-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/","title":{"rendered":"Questetra BPMS #Process: Batch Extract by Filter as TSV"},"content":{"rendered":"\n<div style=\"text-align: center; background: #FFFF66; margin: 1em; padding: 1em;\">\n<h3><span class=\"material-icons\">warning<\/span> PAGE UPDATED<\/h3>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2026\/\">https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2026\/<\/a>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Questetra BPMS: Process, Batch Extract by Filter as TSV<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> U: Select HTTP_Authz Setting<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A1: Set Target Platform URL (eg. &#8220;${var[applicationRoot]}&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A2: Set Filter ID (ReportID) (eg. &#8220;1234&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> A3: Set Max Num of Extraction (eg. &#8220;100&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B1: Select STRING that stores Extracted TSV (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B2: Select NUMERIC that stores Num of Extracted Process (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B3: Select NUMERIC that stores Num of Filtered Process (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting     = configs.get      ( &quot;AuthzConfU&quot; );   \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  engine.log( &quot; AutomatedTask Config: Authz Setting: &quot; + strAuthzSetting );\nconst strTargetUrl        = configs.get      ( &quot;StrConfA1&quot; );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strTargetUrl      === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: TargetPlatformURL} is empty \\n&quot; );\n  }\nconst strReportId         = configs.get      ( &quot;StrConfA2&quot; );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strReportId       === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A2: FilterID} is empty \\n&quot; );\n  }\nlet   strLimit            = configs.get      ( &quot;StrConfA3&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n  if( strLimit          === &quot;&quot; ){\n      strLimit = &quot;1000&quot;;\n  }else if( isNaN( parseInt(strLimit) ) || parseInt(strLimit) &lt; 0 ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A3: Max Num of Extraction} must be a positive integer \\n&quot; );\n  }else if( parseInt(strLimit) &gt; 1000 ){\n    engine.log( &quot; AutomatedTask ConfigWarning: &quot; +\n                &quot; {A3: Max Num of Extraction} is limited to 1000&quot; );\n    strLimit = &quot;1000&quot;;\n  }\nconst strPocketTsv        = configs.getObject( &quot;SelectConfB1&quot; ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst numPocketExtracted  = configs.getObject( &quot;SelectConfB2&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\nconst numPocketFiltered   = configs.getObject( &quot;SelectConfB3&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\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\/\/\/\/ == 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 + &quot;API\/OR\/ProcessInstance\/list&quot;;\nlet request1    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1    = request1.authSetting( strAuthzSetting ); \/\/ with &quot;Authorization: Bearer XX&quot;\n    request1    = request1.queryParam( &quot;reportId&quot;, strReportId );\n    request1    = request1.queryParam( &quot;limit&quot;, strLimit );\n    \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n\/\/ request1, try\nconst response1     = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + request1Uri );\nconst response1Code = response1.getStatusCode() + &quot;&quot;;\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\/\/ response1, parse\n\/* \nengine.log( response1Body ); \/\/ debug\n{\n  &quot;count&quot;: 3,\n  &quot;processInstances&quot;: [\n    {\n      &quot;activeTokenNodeName&quot;: [\n        &quot;Task 1&quot;\n      ],\n      &quot;data&quot;: {\n        &quot;0&quot;: {\n          &quot;dataType&quot;: &quot;STRING&quot;,\n          &quot;id&quot;: 51199977,\n          &quot;processDataDefinitionNumber&quot;: 0,\n          &quot;subType&quot;: null,\n          &quot;value&quot;: null,\n          &quot;viewOrder&quot;: 1\n        },\n        &quot;1&quot;: {\n          &quot;dataType&quot;: &quot;STRING&quot;,\n          &quot;id&quot;: 51199978,\n          &quot;processDataDefinitionNumber&quot;: 1,\n          &quot;subType&quot;: null,\n          &quot;value&quot;: &quot;I am a cat.  I was lifted up lightly on his palm.\\n\\nWhen I accustomed myself to that position&quot;,\n          &quot;viewOrder&quot;: 2\n        },\n        &quot;3&quot;: {\n          # # #\n         },\n        &quot;6&quot;: {\n          &quot;dataType&quot;: &quot;SELECT&quot;,\n          &quot;id&quot;: 51200370,\n          &quot;processDataDefinitionNumber&quot;: 6,\n          &quot;subType&quot;: null,\n          &quot;value&quot;: [\n            {\n              &quot;display&quot;: &quot;NO&quot;,\n              &quot;value&quot;: &quot;false&quot;\n            }\n          ],\n          &quot;viewOrder&quot;: 7\n        }\n      },\n      &quot;processInstanceDebug&quot;: false,\n      &quot;processInstanceEndDatetime&quot;: &quot;2021-08-05T14:41:53+0900&quot;,\n      &quot;processInstanceId&quot;: 1536916,\n      &quot;processInstanceIdForView&quot;: &quot;p1536916&quot;,\n      &quot;processInstanceInitQgroupId&quot;: 1,\n      &quot;processInstanceInitQgroupName&quot;: &quot;Org&quot;,\n      &quot;processInstanceInitQuserId&quot;: 14,\n      &quot;processInstanceInitQuserName&quot;: &quot;SouthPole&quot;,\n      &quot;processInstanceSequenceNumber&quot;: 1,\n      &quot;processInstanceStartDatetime&quot;: &quot;2021-08-05T14:25:02+0900&quot;,\n      &quot;processInstanceState&quot;: &quot;ENDED&quot;,\n      &quot;processInstanceTitle&quot;: &quot;Input Test&quot;,\n      &quot;processModelInfoCategory&quot;: &quot;TestUse&quot;,\n      &quot;processModelInfoId&quot;: 2454,\n      &quot;processModelInfoName&quot;: &quot;Input Output test for all data types&quot;,\n      &quot;processModelVersion&quot;: 1,\n      &quot;starred&quot;: false\n    }\n  ]\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\n\nengine.log( &quot; AutomatedTask Parsed: Number of Received Instances: &quot; + response1Obj.processInstances.length );\nengine.log( &quot; AutomatedTask Parsed: Number of Filtered Instances: &quot; + response1Obj.count );\n\nlet strTsv = &quot;&quot;;\nfor( let h = 0; h &lt; response1Obj.processInstances.length; h++ ){\n  strTsv += response1Obj.processInstances[h].processModelInfoName.replace( \/\\t\/g, &quot; &quot; ) + &#39;\\t&#39;;\n  if(         response1Obj.processInstances[h].processModelInfoCategory !== null ){\n    strTsv += response1Obj.processInstances[h].processModelInfoCategory.replace( \/\\t\/g, &quot; &quot; ) + &#39;\\t&#39;;\n  }else{ strTsv += &#39;\\t&#39;; }\n  strTsv += response1Obj.processInstances[h].processInstanceId + &#39;\\t&#39;;\n  if(         response1Obj.processInstances[h].processInstanceTitle !== null ){\n    strTsv += response1Obj.processInstances[h].processInstanceTitle.replace( \/\\t\/g, &quot; &quot; ) + &#39;\\t&#39;;\n  }else{ strTsv += &#39;\\t&#39;; }\n  strTsv += response1Obj.processInstances[h].processInstanceState + &#39;\\t&#39;;\n  strTsv += response1Obj.processInstances[h].processInstanceInitQuserName + &#39;\\t&#39;;\n  strTsv += response1Obj.processInstances[h].processInstanceStartDatetime.slice(0,19).replace(&#39;T&#39;,&#39; &#39;) + &#39;\\t&#39;;\n  if(         response1Obj.processInstances[h].processInstanceEndDatetime !== null ){\n    strTsv += response1Obj.processInstances[h].processInstanceEndDatetime.slice(0,19).replace(&#39;T&#39;,&#39; &#39;) + &#39;\\t&#39;;\n  }else{ strTsv += &#39;\\t&#39;; }\n\n  Object.keys(response1Obj.processInstances[h].data).forEach(function(key){\n    if( response1Obj.processInstances[h].data[key].dataType === &quot;STRING&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;DECIMAL&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;DATE&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;DATETIME&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;QUSER&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;QGROUP&quot; || \n        response1Obj.processInstances[h].data[key].dataType === &quot;DISCUSSION&quot; ){\n      if( response1Obj.processInstances[h].data[key].value !== null ){\n        strTsv += response1Obj.processInstances[h].data[key].value\n                        .replace( \/\\n\/g, &#39; &#39; ).replace( \/\\t\/g, &#39; &#39; );\n      }\n    }else if( response1Obj.processInstances[h].data[key].dataType === &quot;SELECT&quot; ){\n      if( response1Obj.processInstances[h].data[key].value !== null ){\n        for( let j = 0; j &lt; response1Obj.processInstances[h].data[key].value.length; j++ ){\n          strTsv += response1Obj.processInstances[h].data[key].value[j].display;\n          if( j !== response1Obj.processInstances[h].data[key].value.length - 1 ){\n            strTsv += &quot; &quot;; \/\/ (Multiple: Space-separated)\n          }\n        }\n      }\n    }else if( response1Obj.processInstances[h].data[key].dataType === &quot;FILE2&quot; ){\n      if( response1Obj.processInstances[h].data[key].value !== null ){\n        for( let j = 0; j &lt; response1Obj.processInstances[h].data[key].value.length; j++ ){\n          strTsv += response1Obj.processInstances[h].data[key].value[j].name;\n          if( j !== response1Obj.processInstances[h].data[key].value.length - 1 ){\n            strTsv += &quot; &quot;; \/\/ (Multiple: Space-separated)\n          }\n        }\n      }\n    }else{ \/\/ &quot;LIST&quot; is not supported\n      strTsv += &quot;N\/A&quot;;\n    }\n    strTsv += &quot;\\t&quot;;\n  });\n  strTsv = strTsv.slice( 0, -1 ); \/\/ delete last &quot;\\t&quot;\n\n  if( h !== response1Obj.processInstances.length - 1 ){\n    strTsv += &quot;\\n&quot;;\n  }\n}\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( response1Obj.processInstances.length ) );\n}\nif(               numPocketFiltered   !== null ){\n  engine.setData( numPocketFiltered,   new java.math.BigDecimal( response1Obj.count ) );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes-en:\n- When the process reaches this automatated task, an extraction request is sent to the target workflow platform.\n    - The target workflow platform is set by the URL. (REST API connection destination)\n        - `https:\/\/example.questetra.net\/`\n    - If the target is the same platform, variable settings are also possible. (System variable)\n        - `${var[applicationRoot]}`\n- The output TSV text is stored as the simplest tab-delimited string.\n    - The TAB code and line feed code in each data are converted to &quot; &quot; (space).\n    - Double quotes are also preserved unescaped.\n- Only &quot;Display items&quot; are stored in TSV according to the display settings of the filter.\n    - However, regardless of the filter settings, the 8 properties are stored in the first column of TSV.\n        - AppName, Category, Process ID, Title, Satus, Start User, Start Time, End Time\n    - If you need to change the order or delete the column, put &quot;TSV String, Convert&quot; in the downstream.\n        - https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/\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- &quot;HTTP Authorization Setting&quot; is required for automatic communication (OAuth2 API connection).\n    - Register &quot;API Client&quot; (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 &quot;HTTP Authorization Setting&quot; 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, &quot;`N\/A`&quot; 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\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306b\u5bfe\u3057\u3066\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:\/\/example.questetra.net\/`\n    - \u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u304c\u540c\u4e00\u57fa\u76e4\u306e\u5834\u5408\u3001\u5909\u6570\u306b\u3088\u308b\u8a2d\u5b9a\u304c\u4fbf\u5229\u3067\u3059\u3002\uff08\u30b7\u30b9\u30c6\u30e0\u5909\u6570\uff09\n        - `${var[applicationRoot]}`\n- \u51fa\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u5404\u30c7\u30fc\u30bf\u5185\u306eTAB\u30b3\u30fc\u30c9\u3084\u6539\u884c\u30b3\u30fc\u30c9\u306f &quot; &quot; \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- \u30d5\u30a3\u30eb\u30bf\u306e\u8868\u793a\u8a2d\u5b9a\u306b\u5f93\u3063\u3066\u300c\u8868\u793a\u30c7\u30fc\u30bf\u300d\u3060\u3051\u304cTSV\u306b\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u305f\u3060\u3057\u3001\u30d5\u30a3\u30eb\u30bf\u306e\u8868\u793a\u8a2d\u5b9a\u306b\u95a2\u308f\u3089\u305a\u3001\u6848\u4ef6\u30d7\u30ed\u30d1\u30c6\u30a3\uff08\uff18\u9805\u76ee\uff09\u306fTSV\u5148\u982d\u5217\u306b\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n        - \u30a2\u30d7\u30ea\u540d, \u30ab\u30c6\u30b4\u30ea, \u30d7\u30ed\u30bb\u30b9ID, \u4ef6\u540d, \u72b6\u614b, \u958b\u59cb\u30e6\u30fc\u30b6, \u958b\u59cb\u65e5\u6642, \u7d42\u4e86\u65e5\u6642\n        - AppName, Category, Process ID, Title, Satus, Start User, Start Time, End Time\n    - \u4e26\u3073\u9806\u3092\u5909\u66f4\u3057\u305f\u3044\u5834\u5408\u3084\u7279\u5b9a\u5217\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4e0b\u6d41\u5de5\u7a0b\u306b\u300eTSV \u6587\u5b57\u5217, \u5909\u63db\u300f\u3092\u7f6e\u304f\u306a\u3069\u3057\u307e\u3059\u3002\n        - https:\/\/support.questetra.com\/ja\/addons\/tsv-string-convert-2021\/\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 &quot;HTTP\u8a8d\u8a3c\u8a2d\u5b9a&quot; \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 &quot;`N\/A`&quot; \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\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAABGtJREFUWEfF\nl39IlWcUxz+vmr\/zx1zOlZtLs5VClJpNJzLFaCEW7I9Qm9DcH17FPzYYSAQm\/VFaIxX6cUW2YcoG\nBSKhzMXERQgtzdxcCiq6iW5ms4vpbWrTdzyve6\/3vvd9vXdbw\/PPC885zznf5zznfM\/zSmywSG7H\nr8MfmfeQyEBmHxJvAKF\/77cg8zMSD5DpRKKZIp6549s1gC+IYIkywAT4uuMUWADMeFPFB0ytt2d9\nAGZMSHwKBLgZWGtmReYTTJiN9hsDqOMKUPwvA2u3XaWIEj1f+gDMfIlE3gsKvupG5itM5Gt9OgNw\n4+T7t+xnV8guxdeyvEzfTB8DlgF38DplwhHA6p1f1fMUGRDJueRzZL+eTYhPCBJrW2VkHj17xI3R\nG5z\/4TwT1gljMDLF9jWx5mW12kf0Cq44rpjyhHIi\/CNcnnL06Sin75+mabjJyNaKNzvU7lgDUEc1\n8JF21+ZNm6lPr2d36G5FNf3HNFGBUcQGxxqCmVmYofanWmr6a5h7PqdnV0MRHwvFKgBBMjCj1+cN\n7zRwPPY4npKnYjppnWRxeZHooGhDACLooGWQ7sfdlHaV6tkJnggTZLUKwMz7SDRqLUviSqg6UEXg\npkCbSgAYnx9nZnEGy6IFURsJLycQ7B1ssxEAhmeHCfMNI\/fbXO5O33UGIVOAiSY1A58BhVqr1ndb\nlaKzF1Fg+R353Jm6Y1uOC43j0tuXSNqSpKzNP59XMrUnbA9VfVWU95TrZeFzivhQzUAvEvvsrTK3\nZnIt4xrbArbZlheWF7j440VOdZ\/STb+olWPRx5AkCW8Pb3w8fbj5y02OfnNULwMPMJGgZuCJ3WBR\njAvfLKQ2tdYh\/Q8tD0lpSTEqLErjS6k8UEmA1xpz9\/7eS2Jzoh5gC0W8pAKQtRZnks5QtrdMOYkq\nHZMdZLVlGRZfQWwBl9MuIzpHFUFQ8Tfi9fcUIb1QACf3nqQ8sRxfz7Wh2flrJ5mtmS4BuHUFI09H\nyP46m6HZISeH4tQth1oQtWMvDUMNnPjuhIsrMONUhILvr2ddV1pJOBFt5iF5MLs0S+NQo1NrVSRW\nKFdmf3rRDWXfl3FlQAxWjcg4FKFhG6a\/mq70tOh1VQQbNo810z7RjpfkRVpEGjFBMeRE5ThE6X\/S\nrwQ3D+g+BxzaUJeIcmNyOZt8ViEcewDawyytLNHzuIfUV1JtKuufVmVNEFVeR57Cig6iISJDKq5M\nriRjawbJ4cmG1S8AdE112YhoRV7h3vQ9Zc\/t327r8YCGioVrg2EkVIdfO0x1SjU7Q3Y6jGEVkQg4\nNjeGOLUQDzzYHrRd+Vbcr1BGtEY0w0ho1xnHQi1SeeGtCxyJOoK\/l0iYs4gZcGvilnL6\/B35+Hn5\nkdOeo+0ag3Es\/K3zIFHDCSDC+cHIg4T7hSvLYjiJfq8frLexpGhLUcBt423auzd4kKhmbjzJDIvB\ntcLFk0x1sKGP0v8nE\/\/wWb6WiQ38MVFBbOivmX1RbdjPqevK\/k8WfwE\/RrEwX153\/wAAAABJRU5E\nrkJggg==\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"download\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1OfabiN3K7bs3KJ0bcFeu2FxTxKPC4TIp\/view?usp=drivesdk\" target=\"_blank\">Questetra-Bpms-Process-Batch-Extract-by-Filter-as-Tsv.xml<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1KKtCx95rKU6SlaGnZ-m0rsry86ULS9dc\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1KKtCx95rKU6SlaGnZ-m0rsry86ULS9dc\/view?usp=sharing\">Questetra-Bpms-Process-Batch-Extract-by-Filter-as-Tsv-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-09-14 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/\">https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"notes\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>When the process reaches this automated task, an extraction request is sent to the target workflow platform.\n<ul class=\"wp-block-list\">\n<li>The target workflow platform is set by the URL. (REST API connection destination)\n<ul class=\"wp-block-list\">\n<li><code>https:\/\/example.questetra.net\/<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If the target is the same platform, variable settings are also possible. (System variable)\n<ul class=\"wp-block-list\">\n<li><code>${var[applicationRoot]}<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The output TSV text is stored as the simplest tab-delimited string.\n<ul class=\"wp-block-list\">\n<li>The TAB code and line feed code in each piece of data are converted to a single space.<\/li>\n\n\n\n<li>Double quotes are also preserved unescaped.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Only data that is displayed according to the filter&#8217;s display settings is stored in the TSV. (Ascending order of data definition number)\n<ul class=\"wp-block-list\">\n<li>However, regardless of the filter settings, the 8 properties are stored in the first column of TSV.\n<ul class=\"wp-block-list\">\n<li>AppName, Category, Process ID, Title, Status, Start User, Start Time, End Time<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If you need to change the order or delete a specific column, put &#8220;TSV String, Convert&#8221; downstream in the process..\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/\">https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"capture\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"113081\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.\" class=\"wp-image-113081\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"630\" data-attachment-id=\"113085\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?fit=1199%2C937&amp;ssl=1\" data-orig-size=\"1199,937\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?fit=806%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en-806x630.png?resize=806%2C630&#038;ssl=1\" alt=\"Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.\" class=\"wp-image-113085\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?resize=806%2C630&amp;ssl=1 806w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?resize=403%2C315&amp;ssl=1 403w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?resize=768%2C600&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-config-en.png?w=1199&amp;ssl=1 1199w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"appendix\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the number of processes of the filter extraction result is 1000 or more, the data after 1001 will not be stored.\n<ul class=\"wp-block-list\">\n<li>Even if 1000 or less, there is a possibility of timeout when there are many data items.<\/li>\n\n\n\n<li>To control the number of extraction results:\n<ul class=\"wp-block-list\">\n<li>Extract only the processes whose status status is <code>Running<\/code><\/li>\n\n\n\n<li>Extract only the date data of the previous month\n<ul class=\"wp-block-list\">\n<li>After: <code>#today.addMonths(-1).getFirstTimeInMonth()<\/code><\/li>\n\n\n\n<li>Before: <code>#today.addMonths(-1).getLastTimeInMonth()<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>HTTP Authorization Settings are required for automatic communication (OAuth2 API connection).\n<ul class=\"wp-block-list\">\n<li>Register &#8220;API Client&#8221; in advance as the connection destination. (Requires System Admin privileges)\n<ul class=\"wp-block-list\">\n<li>Scope\n<ul class=\"wp-block-list\">\n<li>Read-only API Access<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Redirect URL\n<ul class=\"wp-block-list\">\n<li><code>https:\/\/s.questetra.net\/oauth2callback<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Make a <strong>note<\/strong> of your registration details.\n<ul class=\"wp-block-list\">\n<li>Client ID<\/li>\n\n\n\n<li>Client Secret (Consumer Secret)<\/li>\n\n\n\n<li>Authorization Endpoint URL<\/li>\n\n\n\n<li>Token Endpoint URL<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Set &#8220;HTTP Authorization Setting&#8221; in the App as client. (Select this setting name in Addon config)\n<ul class=\"wp-block-list\">\n<li>Authorization Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><em>(See your note above)<\/em><\/li>\n\n\n\n<li>Example: <code>https:\/\/example.questetra.net\/oauth2\/authorize<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Token Endpoint URL:\n<ul class=\"wp-block-list\">\n<li><em>(See your note above)<\/em><\/li>\n\n\n\n<li>Example: <code>https:\/\/example.questetra.net\/oauth2\/token<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Scope:\n<ul class=\"wp-block-list\">\n<li><code>read<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Client ID\n<ul class=\"wp-block-list\">\n<li><em>(See your note above)<\/em><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Client Secret:\n<ul class=\"wp-block-list\">\n<li><em>(See your note above)<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Table type data is not supported for extraction.\n<ul class=\"wp-block-list\">\n<li>If an unsupported type, &#8220;<code>N\/A<\/code>&#8221; is output.<\/li>\n\n\n\n<li>The file names are extracted for the File type. (Multiple: Space-separated)<\/li>\n\n\n\n<li>The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"see-also\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"YvntmMyvRu\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/\">Questetra BPMS: Process, Batch Extract as TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Questetra BPMS: Process, Batch Extract as TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/embed\/#?secret=weuJ3cX2t0#?secret=YvntmMyvRu\" data-secret=\"YvntmMyvRu\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"sIPOURXUy2\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/\">TSV String, Convert<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;TSV String, Convert&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-convert-2021\/embed\/#?secret=vhHYkslHBo#?secret=sIPOURXUy2\" data-secret=\"sIPOURXUy2\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.<\/p>\n","protected":false},"author":2,"featured_media":113089,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[3167,419,389],"class_list":["post-113093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-authsetting","tag-questetra-workflow-api","tag-tsv-csv"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":2,"uagb_excerpt":"Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-tq5","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":113093,"position":0},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82141,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":113093,"position":1},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"0,2,3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82252,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-filter-by-text\/","url_meta":{"origin":113093,"position":2},"title":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","author":"IMAMURA, Genichi","date":"2019-11-25","format":false,"excerpt":"\u4efb\u610f\u306e\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u3067TSV\u6587\u5b57\u5217\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002\u6307\u5b9a\u30ab\u30e9\u30e0\u306b\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u304c\u542b\u307e\u308c\u308b\u884c\u306e\u307f\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u30c6\u30ad\u30b9\u30c8\u306b\u3088\u308b OR \u691c\u7d22\u3092\u3057\u305f\u3044\u5834\u5408\u306f \"USA,U.S.,United States\" \u306e\u3088\u3046\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":113093,"position":3},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82236,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-filter-by-text\/","url_meta":{"origin":113093,"position":4},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","author":"IMAMURA, Genichi","date":"2019-11-22","format":false,"excerpt":"\u4efb\u610f\u306e\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u3067\u8907\u6570\u884c\u306e\u6587\u5b57\u5217\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3057\u307e\u3059\u3002\u691c\u7d22\u30c6\u30ad\u30b9\u30c8\u304c\u542b\u307e\u308c\u308b\u884c\u306e\u307f\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u30c6\u30ad\u30b9\u30c8\u306b\u3088\u308b OR \u691c\u7d22\u3092\u3057\u305f\u3044\u5834\u5408\u306f \"USA,U.S.,United States\" \u306e\u3088\u3046\u306b\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u8907\u6570\u884c\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30d5\u30a3\u30eb\u30bf","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Multiline-String-Filter-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83968,"url":"https:\/\/support.questetra.com\/ja\/addons\/two-tsv-strings-extract-cell-mismatched-lines\/","url_meta":{"origin":113093,"position":5},"title":"2\u3064\u306eTSV\u6587\u5b57\u5217, \u30bb\u30eb\u4e0d\u4e00\u81f4\u884c\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2020-01-29","format":false,"excerpt":"TSV\u6587\u5b57\u5217A\u306e\u7279\u5b9a\u5217\u3068B\u306e\u7279\u5b9a\u5217\u3092\u6bd4\u8f03\u3057\u3001A\u306b\u5bfe\u3057\u3066\u30bb\u30eb\u5408\u81f4\u3057\u306a\u3044B\u306e\u884c\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002A\u3068B\u304c\u5b8c\u5168\u306b\u4e00\u81f4\u3059\u308b\u5834\u5408\u306f\u3001\u7a7a\u6587\u5b57\u5217\u304c\u8fd4\u3055\u308c\u307e\u3059\u3002\u5168\u9762\u7684\u306b\u7570\u306a\u308b\u5834\u5408\u306f\u3001B\u306e\u5168\u884c\u304c\u8fd4\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"2\u3064\u306eTSV\u6587\u5b57\u5217, \u30bb\u30eb\u4e0d\u4e00\u81f4\u884c\u306e\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/Two-Tsv-Strings-Extract-Cell-Mismatched-Lines-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=113093"}],"version-history":[{"count":9,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113093\/revisions"}],"predecessor-version":[{"id":181800,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/113093\/revisions\/181800"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/113089"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=113093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=113093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=113093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}