{"id":180434,"date":"2026-03-05T16:01:23","date_gmt":"2026-03-05T07:01:23","guid":{"rendered":"https:\/\/support.questetra.com\/?p=180434"},"modified":"2026-08-21T11:53:12","modified_gmt":"2026-08-21T02:53:12","slug":"csv-update-csv","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/","title":{"rendered":"Automate Data Processing with [Update CSV Data]"},"content":{"rendered":"\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113160\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/how-to-use-timer-start-event\/attachment\/advanced-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-title=\"advanced-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113160\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Data transfer between business systems often relies on the CSV (Comma-Separated Values) format.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Questetra&#8217;s Auto-Processing Task, [<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\" data-type=\"link\" data-id=\"https:\/\/support.questetra.com\/bpmn-icons\/service-task-csv-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">Update CSV Data<\/a>] allows you to automate the processing and transformation of CSV data directly within your workflow. This includes tasks like extracting specific rows or columns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[Update CSV Data] related articles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Automating Data Processing with [Update CSV Data]<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-various\/\">Supporting Various Data Input\/Output with [Update CSV Data]<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/\">Automating Data Aggregation with [Update CSV Data]<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/\" data-type=\"link\" data-id=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/\">Building a Choice Master with [Update CSV Data]<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. About the [Update CSV Data] Step<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1-1. Step Overview<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">[<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\">Update CSV Data<\/a>] is a built-in, automated processing task available on the Advanced and Professional workflow platforms.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Its key feature is that it treats CSV data saved as a multi-line string as a relational database table. This allows users to manipulate the data using SQL queries.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"315\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=560%2C315&#038;ssl=1\" alt=\"\" class=\"wp-image-168914\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">1-2. Benefits of Automating CSV Processing<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Using Update CSV Data offers several advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reduces the need for manual CSV editing<\/li>\n\n\n\n<li>Ensures consistent data processing by applying the same rules every time<\/li>\n\n\n\n<li>Integrates CSV processing seamlessly into your workflow<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This feature is particularly useful for tasks involving repetitive, standardized CSV processing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Basic Configuration<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">2-1. Input Data<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C1: Specifying Data Items to Load<\/strong>\n<ul class=\"wp-block-list\">\n<li>Define the String-type (multi-line) data item where your CSV data is stored<\/li>\n\n\n\n<li>You can also specify the table name that will be used in your SQL query (e.g. &#8220;List&#8221;)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>C2: Specifying Additional Data<\/strong>\n<ul class=\"wp-block-list\">\n<li>Use this option when working with a second set of CSV data<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2-2. Query<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Specifying Table and Column Names:<br><\/strong> Table and column names must be enclosed in double quotes (e.g. `SELECT * FROM &#8220;List&#8221;`)<\/li>\n\n\n\n<li><strong>Be Aware of Restricted Words:<br><\/strong>Certain terms are prohibited for security reasons<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2-3. Save Settings<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>To retain both the original data and the processing results, specify a different data item for saving the output<\/strong><\/li>\n\n\n\n<li><strong>Selecting the same data item as C1 will overwrite the original data<\/strong><strong><br><\/strong>This is convenient if you no longer need the original CSV data<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped has-border-color has-ast-global-color-3-border-color wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\" style=\"border-width:3px\">\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"630\" data-attachment-id=\"180357\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-input-data-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?fit=883%2C834&amp;ssl=1\" data-orig-size=\"883,834\" data-comments-opened=\"0\" data-image-title=\"csv-update-input-data-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?fit=667%2C630&amp;ssl=1\" data-id=\"180357\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en-667x630.jpg?resize=667%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180357\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=667%2C630&amp;ssl=1 667w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=334%2C315&amp;ssl=1 334w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=768%2C725&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?w=883&amp;ssl=1 883w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"630\" data-attachment-id=\"180372\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-query-en2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?fit=894%2C745&amp;ssl=1\" data-orig-size=\"894,745\" data-comments-opened=\"0\" data-image-title=\"csv-update-query-en2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?fit=756%2C630&amp;ssl=1\" data-id=\"180372\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2-756x630.jpg?resize=756%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180372\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=756%2C630&amp;ssl=1 756w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=378%2C315&amp;ssl=1 378w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=768%2C640&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?w=894&amp;ssl=1 894w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"668\" height=\"630\" data-attachment-id=\"180374\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-save-settings-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?fit=883%2C833&amp;ssl=1\" data-orig-size=\"883,833\" data-comments-opened=\"0\" data-image-title=\"csv-update-save-settings-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?fit=668%2C630&amp;ssl=1\" data-id=\"180374\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en-668x630.jpg?resize=668%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180374\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=668%2C630&amp;ssl=1 668w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=334%2C315&amp;ssl=1 334w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=768%2C725&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?w=883&amp;ssl=1 883w\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. Processing CSV with Queries<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The examples in this section illustrate typical processing flows.<br>\nThese examples use the following sample CSV data:<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>id,name,status\n1,Yamada,Active\n2,Sato,Inactive\n3,Suzuki,Active<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3-1. Filtering Rows<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Generates a CSV file containing only rows that match a condition.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT *\nFROM &quot;List&quot;\u00a0\nWHERE &quot;status&quot; = &#39;Active&#39;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"123\" data-attachment-id=\"180438\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?fit=597%2C123&amp;ssl=1\" data-orig-size=\"597,123\" data-comments-opened=\"0\" data-image-title=\"csv-update-csv-3-1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?fit=597%2C123&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?resize=597%2C123&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180438\" style=\"border-width:3px\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3-2. Selecting Columns<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Generates a CSV containing only specified columns.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &quot;id&quot;,&quot;name&quot;\u00a0\nFROM &quot;List&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"124\" data-attachment-id=\"180440\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-2-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?fit=597%2C124&amp;ssl=1\" data-orig-size=\"597,124\" data-comments-opened=\"0\" data-image-title=\"csv-update-csv-3-2-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?fit=597%2C124&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?resize=597%2C124&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180440\" style=\"border-width:3px\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3-3. Reordering Columns<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Control the column order in the output CSV.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &quot;name&quot;,&quot;id&quot;,&quot;status&quot;\u00a0\nFROM &quot;List&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"124\" data-attachment-id=\"180442\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-3-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?fit=620%2C124&amp;ssl=1\" data-orig-size=\"620,124\" data-comments-opened=\"0\" data-image-title=\"csv-update-csv-3-3-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?fit=620%2C124&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?resize=620%2C124&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180442\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?w=620&amp;ssl=1 620w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?resize=600%2C120&amp;ssl=1 600w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">4. Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Questetra&#8217;s [Update CSV Data] automates CSV data processing by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Loading CSV data<\/li>\n\n\n\n<li>Treating the data as a database table<\/li>\n\n\n\n<li>Processing the data using SQL queries<\/li>\n\n\n\n<li>Outputting the results as CSV<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">By automating these steps, you can significantly reduce manual CSV editing, seamlessly integrate CSV processing into your workflows, and achieve more efficient and error-free operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By placing [Update CSV Data] in the workflow diagram, the CSV data stored in the specified string-type data field will be processed automatically.<\/p>\n","protected":false},"author":6,"featured_media":180220,"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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[296],"tags":[],"faq_section":[],"class_list":["post-180434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"komatsuquestetra","author_link":"https:\/\/support.questetra.com\/en\/author\/komatsuquestetra\/"},"uagb_comment_info":2,"uagb_excerpt":"By placing [Update CSV Data] in the workflow diagram, the CSV data stored in the specified string-type data field will be processed automatically.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-KWe","jetpack-related-posts":[{"id":84618,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-kick-httpstartevent-by-tsv\/","url_meta":{"origin":180434,"position":0},"title":"Questetra BPMS: Process, Kick HttpStartEvent by TSV","author":"IMAMURA, Genichi","date":"2021-02-17","format":false,"excerpt":"Kicks HttpStartEvent with the specific line data of TSV. When assuming batch start using multiline TSV data, place it in a loop structure. LineIDs start at zero.","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, Kick HttpStartEvent by TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-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\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":83183,"url":"https:\/\/support.questetra.com\/en\/versions\/version-11130\/","url_meta":{"origin":180434,"position":1},"title":"v11.13 2020-01-20 Enhanced Automatic Setting Function for Business Data","author":"Hirotaka NISHI","date":"2020-01-06","format":false,"excerpt":"We will continue to support the modeling function the HTML5 version. In addition, for Google Drive, the specification method in the folder path is abolished.","rel":"","context":"In &quot;Version Info&quot;","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/version-11130-fi-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\/12\/version-11130-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/version-11130-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/version-11130-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/version-11130-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":180434,"position":2},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":74974,"url":"https:\/\/support.questetra.com\/en\/templates\/decision-making-request-flow-20160314\/","url_meta":{"origin":180434,"position":3},"title":"Decision-making Request Flow","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"excerpt":"Realizes \"proxy approval\" by the deputy manager. That is, requests of less than 1 million yen proceed to [3a. Approval], and the deputy manager will also be able to give approval. Applications for between 1 to 5 million yen will be also accepted after 24 hours. Meanwhile, for applications over\u2026","rel":"","context":"In &quot;\u30ef\u30fc\u30af\u30d5\u30ed\u30fc \u30a2\u30d7\u30ea&quot;","block_context":{"text":"\u30ef\u30fc\u30af\u30d5\u30ed\u30fc \u30a2\u30d7\u30ea","link":"https:\/\/support.questetra.com\/ja\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-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\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-decision-making-request-flow-20160314-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77067,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/download-process-data\/","url_meta":{"origin":180434,"position":4},"title":"Downloading Case and Task Lists Using Workflow API (reportId)","author":"Hirotaka NISHI","date":"2022-01-18","format":false,"excerpt":"Download Case and Task data from Questetra BPM Suite. Introducing examples of scripts using curl command.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.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\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69682,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-tabletoexcelcsv\/","url_meta":{"origin":180434,"position":5},"title":"Converter (Table type data to Excel-CSV File)","author":"Shiho Tatsumi","date":"2024-07-05","format":false,"excerpt":"This item stores the values in a Table type data item into a File type data item as an Excel compatible CSV. The file is added and does not affect existing files.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.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\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=180434"}],"version-history":[{"count":12,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434\/revisions"}],"predecessor-version":[{"id":193688,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434\/revisions\/193688"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/180220"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=180434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=180434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=180434"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=180434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}