{"id":181781,"date":"2026-03-18T14:51:34","date_gmt":"2026-03-18T05:51:34","guid":{"rendered":"https:\/\/support.questetra.com\/?p=181781"},"modified":"2026-05-29T16:04:17","modified_gmt":"2026-05-29T07:04:17","slug":"questetra-bpms-process-batch-extract-by-filter-as-tsv-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2026\/","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-cases-extract-by-report-id-2026\/\">https:\/\/support.questetra.com\/addons\/questetra-bpms-cases-extract-by-report-id-2026\/<\/a>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading has-background\" style=\"background-color:#ffccff;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><strong>Questetra BPMS #Process: Batch Extract by Filter as TSV<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#ffccff;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2026\/\">Questetra BPMS #\u6848\u4ef6: \u4fdd\u5b58\u6e08\u30d5\u30a3\u30eb\u30bf\u3067TSV\u4e00\u62ec\u62bd\u51fa<\/a><\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#fff0ff;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--60);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--40)\">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\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><img decoding=\"async\" src=\"data:image\/png;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=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-6-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">AuthzConfU<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">U: Select HTTP_Authz Setting<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfA1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">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><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfA2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">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><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfA3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">A3: Set Max Num of Extraction (eg. &#8220;100&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfB1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B1: Select STRING that stores Extracted TSV (update)<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfB2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B2: Select NUMERIC that stores Num of Extracted Process (update)<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfB3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B3: Select NUMERIC that stores Num of Filtered Process (update)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ Script for &#39;engine type: 3&#39; (&quot;GraalJS standard mode&quot;)\n\/\/ cf &#39;engine type: 2&#39; renamed from &quot;GraalJS&quot; to &quot;GraalJS Nashorn compatible mode&quot; (at 20230526)\n\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 objAuthzSetting     = configs.getObject      ( &quot;AuthzConfU&quot; );   \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  engine.log( &quot; AutomatedTask Config: Authz Setting: &quot; + objAuthzSetting.getName() );\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( objAuthzSetting ); \/\/ 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 [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 &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<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Download<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1XoSgiTrGSDgvZbuaq7OVP9zYxAe-JV5L\/view?usp=drivesdk\" target=\"_blank\">Questetra-Bpms-Process-Batch-Extract-by-Filter-as-Tsv-2026.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2026-03-04 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"has-small-font-size\" style=\"text-align: right;\"><div style=\"display: inline-block; background: #FBE7DD; text-align: center;\">\n<span class=\"material-icons\">warning<\/span> Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<br>\n(Installing <em><strong>Addon Auto-Steps<\/strong><\/em> are available only on the <em><strong><span style=\"color: #1970B9\">Professional<\/span><\/strong><\/em> edition.)\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Notes<\/span><\/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\u2019s 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 the 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 \u201cTSV String, Convert\u201d downstream in the process\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/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\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border is-style-rounded is-style-rounded--1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" 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-1024x576.png?resize=1024%2C576&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-113081\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" 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?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=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=768%2C432&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-capture-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border\"><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=\"\" class=\"has-border-color has-ast-global-color-8-border-color wp-image-113085\" style=\"border-width:3px\" 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\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Appendix<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the number of processes returned by the filter extraction exceeds 1,000, the data after the 1,001st case will not be stored\n<ul class=\"wp-block-list\">\n<li>Even if the filter results is 1,000 or fewer, 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&nbsp;<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:&nbsp;<code>#today.addMonths(-1).getFirstTimeInMonth()<\/code><\/li>\n\n\n\n<li>Before:&nbsp;<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 \u201cAPI Client\u201d 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\u00a0<strong>note<\/strong>\u00a0of 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 \u201cHTTP Authorization Setting\u201d 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:&nbsp;<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:&nbsp;<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, \u201c<code>N\/A<\/code>\u201d is output<\/li>\n\n\n\n<li>The file names are extracted for File type data. (Multiple: Space-separated)<\/li>\n\n\n\n<li>The display strings of the selected options are extracted for Select type data. (Multiple: Space-separated)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">See Also<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/\">Questetra BPMS: Process, Batch Extract as TSV<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/\">TSV String, Convert<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\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":3,"featured_media":113089,"comment_status":"closed","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":"","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":"","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-181781","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":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"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-LhX","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82149,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":181781,"position":0},"title":"Questetra BPMS: Process, Batch Extract as TSV","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as \"string:0,date:2,select:3\". Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Batch Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82133,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":181781,"position":1},"title":"Questetra BPMS: Process, Extract as TSV","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"Extracts process data as single-line TSV string. Items are specified in CSV format such as \"0,2,3\". Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log).","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-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\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82245,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/","url_meta":{"origin":181781,"position":2},"title":"TSV String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-25","format":false,"excerpt":"Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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\/2019\/11\/TSV-String-Filter-by-Text-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":181781,"position":3},"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":113093,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/","url_meta":{"origin":181781,"position":4},"title":"Questetra BPMS #Process: Batch Extract by Filter as TSV","author":"IMAMURA, Genichi","date":"2021-09-15","format":false,"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Batch Extract by Filter as TSV","src":"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&resize=350%2C200","width":350,"height":200,"srcset":"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&resize=350%2C200 1x, 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&resize=525%2C300 1.5x, 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&resize=700%2C400 2x, 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&resize=1050%2C600 3x"},"classes":[]},{"id":70950,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-filteringbynumber\/","url_meta":{"origin":181781,"position":5},"title":"TSV Filtering by Number","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Filter the rows on tab-delimited text (TSV) stored in String type Data Item by a range of numbers and save it","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-filter-by-number-header.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\/181781","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=181781"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/181781\/revisions"}],"predecessor-version":[{"id":185404,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/181781\/revisions\/185404"}],"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=181781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=181781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=181781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}