{"id":193634,"date":"2026-04-14T11:07:33","date_gmt":"2026-04-14T02:07:33","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/csv-update-choice-master\/"},"modified":"2026-08-21T11:54:59","modified_gmt":"2026-08-21T02:54:59","slug":"csv-update-choice-master","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/","title":{"rendered":"Building a Choice Master with [Update CSV Data]"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en-1024x58.png?resize=1024%2C58&amp;ssl=1\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">[Update CSV Data] lets you extract the data you need from CSV. Also, the choices in a [Select-type] Data Item consist of two fields: &#8220;Choice ID&#8221; and &#8220;Display label.&#8221; By combining [Update CSV Data] with [Update Choices], you can extract the necessary data from a CSV and create a Choice master file from that data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here, we introduce how to build an app that automatically creates a Choice master file \u2014 using email addresses as Choice IDs and names as Display labels \u2014 based on CSV data from an employee directory.<\/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><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/\">Automating Data Processing with [Update CSV Data]<\/a><\/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>Building a Choice Master with [Update CSV Data]<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. What Is a Choice Master?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Choices for a [Select-type] Data Item are defined as combinations of &#8220;Choice ID&#8221; and &#8220;Display label.&#8221; A Choice master is an XML-format file that defines multiple such combinations. When registered as an Add-on, it can be referenced as a common set of choices from multiple apps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For details on the format of a Choice master and various methods of creating one, see the following articles. This article focuses specifically on how to build a Choice master from CSV using [Update CSV Data].<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Reference articles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/create-choice-master-xml\/\">Creating a Choice Master XML with a Text Editor or the Modeler<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/\">Utilize Customer Data on Google Sheets as Choices<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. Choice Master Auto-Create \/ Update App<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This app receives CSV data from an employee directory (input) and automatically creates and registers a Choice master file of names and email addresses (output). When the source CSV data is entered, names (Display labels) and email addresses (Choice IDs) are extracted and registered as a Choice master file in Add-ons. If the directory is updated and the flow is re-executed, the Choice master is updated to the latest content.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">App Definition<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Workflow Diagram<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Following the Human Task where the source CSV data is entered, place an [Update CSV Data] step and an [Update Choices] step. Each step handles the following processing. (Detailed settings are described later.)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"157\" data-attachment-id=\"193638\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/attachment\/csv-update-choice-master-app-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?fit=1744%2C268&amp;ssl=1\" data-orig-size=\"1744,268\" 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;,&quot;alt&quot;:&quot;&quot;}\" data-image-title=\"csv-update-choice-master-app-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?fit=1024%2C157&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en-1024x157.png?resize=1024%2C157&#038;ssl=1\" alt=\"\" class=\"wp-image-193638\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?resize=1024%2C157&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?resize=600%2C92&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?resize=768%2C118&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?resize=1536%2C236&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?resize=1200%2C184&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-app-en.png?w=1744&amp;ssl=1 1744w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>[Update CSV Data]: Extract Display labels and Choice IDs<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Extracts names (Display labels) and email addresses (Choice IDs) from the source employee directory CSV data, and saves each to a String-type (multiple lines) Data Item. The step name is &#8220;Data Extraction.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>[Update Choices]: Create a Choice master from Display labels and Choice IDs<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Creates a Choice master file from the [Select-type] Data Item that references the two Data Items output by [Update CSV Data] as choices, and registers it as an Add-on. If a file with the same name already exists, it is updated. The step name is &#8220;Create \/ Update Choice Master.&#8221;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Data Items<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Prepare the following Data Items.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Data Item Name<\/th><th>Data Type<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>CSV Data<\/td><td>String (multiple lines)<\/td><td>Stores the source CSV data.<\/td><\/tr><tr><td>Choice ID<\/td><td>String (multiple lines)<\/td><td>Stores the Choice IDs extracted from the CSV data.<\/td><\/tr><tr><td>Display label<\/td><td>String (multiple lines)<\/td><td>Stores the Display labels extracted from the CSV data.<\/td><\/tr><tr><td>Choices for Create \/ Update Choice Master<\/td><td>Select<\/td><td>The Choice master is created\/updated based on the choices of this Data Item.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For the [Select-type] Data Item &#8220;Choices for Create \/ Update Choice Master,&#8221; set [Type of data source] to [String-type data item], specifying &#8220;Choice ID&#8221; for [Choice ID] and &#8220;Display label&#8221; for [Display label].<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. [Update CSV Data] Step Settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Extract the two columns corresponding to the Display labels and Choice IDs from the source CSV data, and save each to a separate String-type (multiple lines) Data Item.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[Query]\n\n\n\n<ul class=\"wp-block-list\">\n<li>Write a query to extract the columns for the Display labels and Choice IDs.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">[Save Settings]\n\n\n\n<ul class=\"wp-block-list\">\n<li>In [C4: How to save query results], select &#8220;Save the values of each column to a data item, separated by line breaks.&#8221;<\/li>\n\n\n\n<li>In [C4a: Data item that will save query results], specify the destination Data Item for each column of the query results individually.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Configuration Example<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Query Example<\/strong><\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &quot;Name&quot;,&quot;Email&quot;\nFROM &quot;Directory&quot;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">This extracts the values of the &#8220;Name&#8221; column and &#8220;Email&#8221; column from the data whose [C1b: Table name when accessed by query] is set to &#8220;Directory.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>C4a (Destination Data Items)<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Query Result Column<\/th><th>Destination Data Item<\/th><\/tr><\/thead><tbody><tr><td>1st column (Name)<\/td><td>String (multiple lines) &#8220;Display label&#8221;<\/td><\/tr><tr><td>2nd column (Email)<\/td><td>String (multiple lines) &#8220;Choice ID&#8221;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Input\/Output Results<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"935\" height=\"630\" data-attachment-id=\"193642\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/attachment\/csv-update-utilize-options-master-en-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?fit=972%2C655&amp;ssl=1\" data-orig-size=\"972,655\" 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;,&quot;alt&quot;:&quot;&quot;}\" data-image-title=\"csv-update-utilize-options-master-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?fit=935%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en-935x630.png?resize=935%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-193642\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?resize=935%2C630&amp;ssl=1 935w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?resize=467%2C315&amp;ssl=1 467w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?resize=768%2C518&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-utilize-options-master-en.png?w=972&amp;ssl=1 972w\" sizes=\"auto, (max-width: 935px) 100vw, 935px\" \/><figcaption class=\"wp-element-caption\"><em>Extracting 2 items and outputting to String (multiple lines)<\/em><\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Reference: Help page <a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\">&#8220;Update CSV Data&#8221;<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. [Update Choices] Step Settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">From the [Select-type] Data Item that references the two String-type (multiple lines) Data Items output by [Update CSV Data] as choices, create or update a Choice master file and register it as an Add-on. For the target [Select-type] Data Item, configure it in advance to reference String-type (multiple lines) Data Items as choices.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[Type of Add-on to be updated]\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choice Master (App-Shared Add-on): Specify this when registering as an [App-Shared Add-on].<\/li>\n\n\n\n<li>Choice Master (Add-on): Specify this when registering as an App-specific Add-on.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">[User who updates choices]\n\n\n\n<ul class=\"wp-block-list\">\n<li>Clicking the [Me] button specifies the operating user.<\/li>\n\n\n\n<li>The specified user must have the appropriate administrative privileges depending on the Add-on type (Choice Master (App-Shared Add-on) = System Administrator privileges \/ Choice Master (Add-on) = App Administrator privileges).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">[Select data item whose choices will be saved]\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the [Select-type] Data Item &#8220;Choices for Create \/ Update Choice Master&#8221; from the pull-down.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">[Name when saving as Add-on]\n\n\n\n<ul class=\"wp-block-list\">\n<li>Specify the file name of the Choice master file (e.g., choice-master-name-email.xml). Include the extension (.xml).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"630\" data-attachment-id=\"193640\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/attachment\/csv-update-choice-master-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?fit=1303%2C1568&amp;ssl=1\" data-orig-size=\"1303,1568\" 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;,&quot;alt&quot;:&quot;&quot;}\" data-image-title=\"csv-update-choice-master-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?fit=524%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en-524x630.png?resize=524%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color has-border-border-color wp-image-193640\" style=\"border-width:5px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?resize=524%2C630&amp;ssl=1 524w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?resize=262%2C315&amp;ssl=1 262w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?resize=768%2C924&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?resize=1276%2C1536&amp;ssl=1 1276w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?resize=1200%2C1444&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/04\/csv-update-choice-master-config-en.png?w=1303&amp;ssl=1 1303w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><figcaption class=\"wp-element-caption\"><em>[Update Choices] step settings screen<\/em><\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Reference: Help page <a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-choices-update\/\">&#8220;Update Choices&#8221;<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5. Verification<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once the settings are complete, run a debug execution from the first [Start Event]. When you enter the source CSV data in the Human Task, all subsequent processing is completed automatically. The results can be verified at the following locations, depending on the [Type of Add-on to be updated] setting in [Update Choices].<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For Choice Master (App-Shared Add-on): [System Settings] &gt; [App-Shared Add-on] &gt; [Master file of Select type data item]<\/li>\n\n\n\n<li>For Choice Master (Add-on): App Details &gt; [App] &gt; [Manage Add-ons] &gt; [Master file of Select type data item]<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">In either case, if a file with the name specified in [Name when saving as Add-on] has been added to the list, the configuration is successful. On the list screen, you can verify the contents and download the file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">6. Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By combining the &#8220;Save the values of each column to a data item, separated by line breaks&#8221; feature of [Update CSV Data] with [Update Choices], you can build a flow that automatically creates and registers a Questetra BPM Suite Choice master from externally obtained CSV data (such as customer lists or employee directories). Simply re-executing the flow whenever the directory changes keeps the Choice master up to date, significantly reducing the effort required to update and manage choices.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating or updating the Choice master by combining [Update CSV Data] and [Update Choices]<\/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_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":[296],"tags":[],"faq_section":[],"class_list":["post-193634","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":0,"uagb_excerpt":"Creating or updating the Choice master by combining [Update CSV Data] and [Update Choices]","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-On8","jetpack-related-posts":[{"id":180434,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/","url_meta":{"origin":193634,"position":0},"title":"Automate Data Processing with [Update CSV Data]","author":"komatsuquestetra","date":"2026-03-05","format":false,"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.","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\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":181393,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-various\/","url_meta":{"origin":193634,"position":1},"title":"Supporting Various Data Input\/Output with [Update CSV Data]","author":"komatsuquestetra","date":"2026-04-02","format":false,"excerpt":"By using the [Update CSV Data] Step appropriately, you can also process data that is not in CSV format.","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\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":179002,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-utilize\/","url_meta":{"origin":193634,"position":2},"title":"Headerless Data Is OK! Fully Understand the Input\/Output Options of [Update CSV Data]","author":"komatsuquestetra","date":"2025-11-19","format":false,"excerpt":"Here are some ideas for applying the [Update CSV Data] feature using its options.","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\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69682,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-tabletoexcelcsv\/","url_meta":{"origin":193634,"position":3},"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":[]},{"id":181437,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/","url_meta":{"origin":193634,"position":4},"title":"Automating Data Aggregation with [Update CSV Data]","author":"komatsuquestetra","date":"2026-03-31","format":false,"excerpt":"We will use the aggregation function in [Update CSV Data], and also show you how to save the aggregated results directly to a Numeric-type data item.","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\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79731,"url":"https:\/\/support.questetra.com\/en\/data-items\/select-type\/","url_meta":{"origin":193634,"position":5},"title":"Select-Type","author":"Peter Glover","date":"2019-09-30","format":false,"excerpt":"Displays a list of options that can be selected by the person in charge of processing, and stores the selection results.","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\/Select.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\/Select.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Select.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\/193634","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=193634"}],"version-history":[{"count":5,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/193634\/revisions"}],"predecessor-version":[{"id":193689,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/193634\/revisions\/193689"}],"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=193634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=193634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=193634"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=193634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}