{"id":72429,"date":"2017-09-19T16:40:45","date_gmt":"2017-09-19T07:40:45","guid":{"rendered":"https:\/\/support.questetra.com\/master-data-management\/"},"modified":"2026-04-14T16:44:05","modified_gmt":"2026-04-14T07:44:05","slug":"master-data-management","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/","title":{"rendered":"Several Ways to Manage Master Data with Questetra"},"content":{"rendered":"<p>Hi there!<\/p>\n<p>The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration.<\/p>\n<p>Management of master data associated with Questetra is one of the common agendas.<\/p>\n<p>There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra will sometimes do automatically, and other cases where Questetra manages master data separately.<\/p>\n<p>There are several ways to maintain the master data. I am going to summarize the kinds of methods there are and the advantages and disadvantages of each one, so I hope that it can be used as material for your future consideration.<\/p>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h3>Patterns of Master Data Management<\/h3>\n<\/div><\/div>\n<p>The pattern varies depending on whether you keep the original master data externally (Salesforce\/kintone\/Google Spreadsheet, etc.) and whether you keep a copy of it internally in <span style=\"font-weight: 400;\">the event that the original is kept externally<\/span>.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Pattern 1: Original master data is retained outside Questetra, and is referenced each time<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72431\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1-en.png?fit=925%2C357&amp;ssl=1\" data-orig-size=\"925,357\" data-comments-opened=\"0\" data-image-title=\"master_data_1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1-en.png?fit=925%2C357&amp;ssl=1\" class=\"aligncenter size-full wp-image-72431\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1-en.png?resize=925%2C357&#038;ssl=1\" alt=\"\" width=\"925\" height=\"357\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1-en.png?w=925&amp;ssl=1 925w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1-en.png?resize=600%2C232&amp;ssl=1 600w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Pattern 2: Original master data is retained outside Questetra, periodically referring to, and synchronizing with, the copy within Questetra<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72432\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_2-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2-en.png?fit=934%2C359&amp;ssl=1\" data-orig-size=\"934,359\" data-comments-opened=\"0\" data-image-title=\"master_data_2-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2-en.png?fit=934%2C359&amp;ssl=1\" class=\"aligncenter size-full wp-image-72432\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2-en.png?resize=934%2C359&#038;ssl=1\" alt=\"\" width=\"934\" height=\"359\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2-en.png?w=934&amp;ssl=1 934w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2-en.png?resize=600%2C231&amp;ssl=1 600w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Pattern 3: Original master data is retained inside Questetra<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72433\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_3-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3-en.png?fit=726%2C370&amp;ssl=1\" data-orig-size=\"726,370\" data-comments-opened=\"0\" data-image-title=\"master_data_3-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3-en.png?fit=726%2C370&amp;ssl=1\" class=\"aligncenter size-full wp-image-72433\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3-en.png?resize=726%2C370&#038;ssl=1\" alt=\"\" width=\"726\" height=\"370\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3-en.png?w=726&amp;ssl=1 726w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3-en.png?resize=600%2C306&amp;ssl=1 600w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/p>\n<table class=\"table\">\n<caption>&nbsp;<\/caption>\n<thead>\n<tr>\n<th>Pattern<\/th>\n<th width=\"40%\">Advantages<\/th>\n<th width=\"40%\">Disadvantages<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>\u30fbChanges in choices are reflected in real time<br \/>\n\u30fbEasy to hold multiple Data Items related to master<br \/>\n\u30fbEasy to list master data (depending on where you keep it)<\/td>\n<td>\u30fbIt must be set up to return choices in xml format. (Needs to be created outside Questetra. Slightly larger volume)<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>\u30fbEasy to hold multiple Data Items related to master<br \/>\n\u30fbEasy to list master data (depending on where you keep it)<\/td>\n<td>\u30fbChanges in choices are not reflected in real time<br \/>\n\u30fbMust be set up to periodically synchronize. (Volume is small, since scripts in Questetra applications can cope as long as the external system has APIs.)<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Changes in choices are reflected in real time<br \/>\n\u30fbCan be realized with Questetra alone<\/td>\n<td>\u30fbIt is necessary to consider when to hold multiple data items related to master<br \/>\n\u30fbDifficult to list master data<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"su-note\"  style=\"border-color:#c3c3c3;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#dddddd;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n* Please see the following citation for the format of the Options XML<br \/>\n<a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002262551-M319\" target=\"_blank\" rel=\"noopener noreferrer\">Related manual M319: Register an Options-XML file to which the Process Model Definitions Refer to<\/a><\/p>\n<p>* <span style=\"font-weight: 400;\">Since the master data held by Questetra has only two items, the Choice ID and the display data, when you want to manage multiple data items related to the master you should put the data including the separator in the display data part and divide it on the reference side.<\/span> (For example, if it is the company name and the URL that you want to manage, set the display data part as &#8220;Foobar Corporation; <a href=\"https:\/\/foobar.com&#038;#8221\" rel=\"nofollow\">https:\/\/foobar.com&#038;#8221<\/a>;, and on the reference side, configure the process to divide with semicolons and set it in a Data Item.)<br \/>\n<!-- Please refer to the following for that devising. \u3000\u30d6\u30ed\u30b0\u300c\u9867\u5ba2\u30de\u30b9\u30bf\u3092\u9078\u629e\u80a2 XML \u3067\u5b9f\u73fe\u3057\u3066\u307f\u308b\uff08\u305d\u306e\uff11\uff09\u300d\u25cf\u307e\u3060 \u3000\u30d6\u30ed\u30b0\u300c\u9867\u5ba2\u30de\u30b9\u30bf\u3092\u9078\u629e\u80a2 XML \u3067\u5b9f\u73fe\u3057\u3066\u307f\u308b\uff08\u305d\u306e\uff12\uff09\u300d\u25cf\u307e\u3060 --><\/p>\n<p>*There are cases where you will want to change the options contents according to the Process\/issue, but that is a slightly different agenda from this article. Please refer to the following site for that.<br \/>\n<a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260151-M208\" target=\"_blank\" rel=\"noopener noreferrer\">Related manual M208: Options at Downstream Step, Set by Upstream Step<\/a><\/p>\n<p>There will be situations in which parent-child workflows are interlocking with multiple selected Data Items, but <span style=\"font-weight: 400;\">that is also a slightly different theme from that covered in this article<\/span>. Please refer to the following site for that.<br \/>\n<a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002262751-M410\" target=\"_blank\" rel=\"noopener noreferrer\">Related manual M410: Narrow Down &#8220;Product Name&#8221; List Display by Filtering with &#8220;Product Classification&#8221;<\/a><br \/>\n<\/div><\/div>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h3>Details of Each Pattern<\/h3>\n<\/div><\/div>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h4>Pattern 1: Original master data is retained outside Questetra, and reference is made each time<\/h4>\n<\/div><\/div>\n<p>The external data reference takes the form of an http access that returns the options xml.<br \/>\nFor example, one method is to retain external data in a Google Spreadsheet, and prepare a Web application with Google Apps Script (GAS) to generate and return options xml.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72434\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_1_sample-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1_sample-en.png?fit=957%2C400&amp;ssl=1\" data-orig-size=\"957,400\" data-comments-opened=\"0\" data-image-title=\"master_data_1_sample-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1_sample-en.png?fit=957%2C400&amp;ssl=1\" class=\"aligncenter size-full wp-image-72434\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1_sample-en.png?resize=957%2C400&#038;ssl=1\" alt=\"\" width=\"957\" height=\"400\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1_sample-en.png?w=957&amp;ssl=1 957w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_1_sample-en.png?resize=600%2C251&amp;ssl=1 600w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/p>\n<p>I prepared a sample Google Spreadsheet using this method and released it as the following.<br \/>\n<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/13n-eGuo42jatJtvpT4zK63YxYru1ZjMqsiWNlIupPKI\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">Sample Google Spreadsheet: Management of master data of countries in the world<\/a><br \/>\nIn addition, to access this sample Google Spreadsheet <span style=\"font-weight: 400;\">with HTTP from a Select-type Data Item<\/span>, please specify the following URL as shown below.<\/p>\n<div class=\"su-note\"  style=\"border-color:#c3c3c3;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#dddddd;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><a href=\"https:\/\/script.google.com\/macros\/s\/AKfycbwyCl0DTV_d348j7mKXZKYFAPqUUjq4QcL0V5G77Naw12rcEte2\/exec\" rel=\"nofollow\">https:\/\/script.google.com\/macros\/s\/AKfycbwyCl0DTV_d348j7mKXZKYFAPqUUjq4QcL0V5G77Naw12rcEte2\/exec<\/a><\/div><\/div>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"89577\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/choices-settings\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/Choices-Settings.png?fit=766%2C489&amp;ssl=1\" data-orig-size=\"766,489\" data-comments-opened=\"0\" data-image-title=\"Choices Settings\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/Choices-Settings.png?fit=766%2C489&amp;ssl=1\" class=\"aligncenter wp-image-89577 size-full\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/Choices-Settings.png?resize=766%2C489&#038;ssl=1\" alt=\"\" width=\"766\" height=\"489\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/Choices-Settings.png?w=766&amp;ssl=1 766w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/Choices-Settings.png?resize=493%2C315&amp;ssl=1 493w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/p>\n<p>The GAS sample code for creating such a Google Spreadsheet is as follows.<\/p>\n<pre><code>var SHEET_ID = \"xxxxx\"; \/\/input Google Sheet id\nvar SHEET_NAME = \"Sheet1\"; \/\/input Sheet name\n\nfunction doGet(e) {\n  return  receive_(e);\n}\n\nfunction doPost(e) {\n  return  receive_(e);\n}\n\nfunction receive_(e) {\n\n  var search_key = e.parameter['query'];\n  if (search_key == undefined) {\n    search_key = \"\";\n  }\n\n  var out = ContentService.createTextOutput(buildXml(search_key));\n  Logger.log(out.getContent());\n\n  return out;\n}\n\nfunction buildXml(search_key) {\n  var sheet = SpreadsheetApp.openById(SHEET_ID).getSheetByName(SHEET_NAME)\n\n  var startRow = 2;\n  var numRows = sheet.getLastRow() - 1;\n    \n  var dataRange = sheet.getRange(startRow, 1, numRows, 2);\n  var data = dataRange.getValues();\n  var out_string = '';\n\n  out_string += '\\n';\n  for ( var i = 0; i &lt; data.length; ++i) { var row = data[i]; var select_value = row[0]; var select_display = row[1]; if ((search_key == \"\") || (select_display.indexOf(search_key) &gt;= 0)) {\n      out_string += '\\n';\n    }\n  }\n  out_string += '';\n  Logger.log(out_string);\n\n  return out_string;\n}<\/code><\/pre>\n<p>For details on how to prepare a web application on GAS, searching &#8220;Google Apps Script web application&#8221; will hit many articles, so please refer to those.<br \/>\n<!-- \u4ee5\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u3000\u30d6\u30ed\u30b0\u300c\u96fb\u8a71\u3092\u304b\u3051\u3066\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u3092\u958b\u59cb\u3059\u308b\u65b9\u6cd5\u300d\u25cf\u307e\u3060\u3001\u79fb\u884c\u3059\u308b\u3088\u308a\u306f\u5225\u306e\u8a18\u4e8b\u3055\u304c\u3059\uff1f --><\/p>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h4>Pattern 2: Original master data is retained outside Questetra, periodically <span style=\"font-weight: 400;\">referencing it synchronously with the copy within Questetra<\/span><\/h4>\n<\/div><\/div>\n<p>The API of an external service from Questetra will be called and the acquired data (usually JSON format) will be processed and imported with a Script Task. We have also prepared an Add-on for such processing.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72436\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_2_sample-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2_sample-en.png?fit=959%2C391&amp;ssl=1\" data-orig-size=\"959,391\" data-comments-opened=\"0\" data-image-title=\"master_data_2_sample-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2_sample-en.png?fit=959%2C391&amp;ssl=1\" class=\"aligncenter size-full wp-image-72436\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2_sample-en.png?resize=959%2C391&#038;ssl=1\" alt=\"\" width=\"959\" height=\"391\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2_sample-en.png?w=959&amp;ssl=1 959w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_2_sample-en.png?resize=600%2C245&amp;ssl=1 600w\" sizes=\"auto, (max-width: 959px) 100vw, 959px\" \/><\/p>\n<p>If you want to keep external data in Salesforce, please refer to the following article for the implementation method.<br \/>\n<a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/\" target=\"_blank\" rel=\"noopener noreferrer\">Blog: How to Use Customer Data in Salesforce as Options<\/a><br \/>\nTo use Google Spreadsheet, please refer to the following sample.<br \/>\n<a href=\"http:\/\/en.workflow-sample.net\/2016\/09\/synchronizing-client-master.html\" target=\"_blank\" rel=\"noopener noreferrer\">Workflow Sample Episode 502: &#8220;Master Reference&#8221; is for Eliminating the Fluctuation!<\/a><br \/>\nFor kintone, please refer to the following sample.<br \/>\n<a href=\"http:\/\/en.workflow-sample.net\/2016\/10\/synchronizing-client-master-2.html\" target=\"_blank\" rel=\"noopener noreferrer\">Workflow Sample Episode 503: &#8220;Master Reference&#8221; is for Eliminating the Fluctuation! (kintone version)<\/a><br \/>\n<!-- \u307e\u305f\u3001\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u3068\u306e\u9023\u643a\u3092\u8003\u3048\u308b\u5834\u5408\u306b\u306f\u4ee5\u4e0b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u3000\u793e\u5185\u30de\u30b9\u30bf\u3092\u300c\u9078\u629e\u80a2 XML\u300d\u306b\u53cd\u6620\u3055\u305b\u308b\u65b9\u6cd5\uff08\u524d\u7de8\uff09\u25cf\u307e\u3060 \u3000\u793e\u5185\u30de\u30b9\u30bf\u3092\u300c\u9078\u629e\u80a2 XML\u300d\u306b\u53cd\u6620\u3055\u305b\u308b\u65b9\u6cd5\uff08\u5f8c\u7de8\uff09\u25cf\u307e\u3060 --><\/p>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h4>Pattern 3: Original master data is retained inside Questetra<\/h4>\n<\/div><\/div>\n<p>Even though it is possible to create your own options xml file and upload it, it is time-consuming to create a file and there&#8217;s no maintenance record. It will be much easier when you make that process into an App.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"72438\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/attachment\/master_data_3_sample-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3_sample-en.png?fit=745%2C362&amp;ssl=1\" data-orig-size=\"745,362\" data-comments-opened=\"0\" data-image-title=\"master_data_3_sample-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3_sample-en.png?fit=745%2C362&amp;ssl=1\" class=\"aligncenter size-full wp-image-72438\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3_sample-en.png?resize=745%2C362&#038;ssl=1\" alt=\"\" width=\"745\" height=\"362\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3_sample-en.png?w=745&amp;ssl=1 745w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master_data_3_sample-en.png?resize=600%2C292&amp;ssl=1 600w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><\/p>\n<p><!-- \u4ee5\u4e0b\u306b\u30de\u30b9\u30bf\u66f4\u65b0\u6642\u306e\u30c8\u30e9\u30d6\u30eb\u56de\u907f\u307e\u3067\u8003\u616e\u3057\u305f\u30a2\u30d7\u30ea\u306e\u5b9f\u73fe\u65b9\u6cd5\u306e\u8a18\u4e8b\u304c\u3042\u308a\u307e\u3059\u3002\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u3000\u30d6\u30ed\u30b0\u300c\u5931\u6557\u3057\u306a\u3044\uff01\u9078\u629e\u80a2 XML \u66f4\u65b0\u4f5c\u696d\u3068\u306f\uff1f\u300d\u25cf\u307e\u3060 \u3000\u30d6\u30ed\u30b0\u300c\u5931\u6557\u3057\u306a\u3044\uff01\u9078\u629e\u80a2 XML \u66f4\u65b0\u4f5c\u696d\u3068\u306f\uff1f\uff08\u30b5\u30fc\u30d3\u30b9\u30bf\u30b9\u30af Addon\u7de8\uff09\u300d\u25cf\u307e\u3060 --><\/p>\n<p>* Options XML: there are two ways in which to store XML: as system common, and to retain only for a specific App. In the former case, Service Task (Choices update) can be used, but in the latter case it can&#8217;t, so it can&#8217;t be applied as an App. Please take note.<\/p>\n<div class=\"su-heading su-heading-style-flat-green su-heading-align-left\" id=\"\" style=\"font-size:16px;margin-bottom:10px\"><div class=\"su-heading-inner\">\n<h3>Summary<\/h3>\n<\/div><\/div>\n<p>There are various methods, some are suitable and others not so much, so please use each one properly according to the scenario.<br \/>\nPlease feel free to ask any questions via <a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/requests\/new\" target=\"_blank\" rel=\"noopener noreferrer\">Contact us<\/a>, if you have any.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi there! The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration. Management of master data associated with Questetra is one of the common agendas. There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra will sometimes do automatically, and [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":102704,"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-72429","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\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/en\/author\/kusaka0211\/"},"uagb_comment_info":6,"uagb_excerpt":"Hi there! The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration. Management of master data associated with Questetra is one of the common agendas. There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra will sometimes do automatically, and&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-iQd","jetpack-related-posts":[{"id":70597,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/","url_meta":{"origin":72429,"position":0},"title":"How to Use Customer Data in Salesforce as Options","author":"HatanakaAkihiro","date":"2018-08-16","format":false,"excerpt":"How to check details of selected customer data on Salesforce.","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\/2018\/08\/salesforce-choices-1200x675-1.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\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":92637,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/","url_meta":{"origin":72429,"position":1},"title":"Using Amazon RDS as an External Master (AWS Console)","author":"Shiho Tatsumi","date":"2020-08-13","format":false,"excerpt":"Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with AWS Console.","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\/2020\/07\/Choices-AWS-Lambda-RDS.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\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":74512,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/questetra-oauth2-settings\/","url_meta":{"origin":72429,"position":2},"title":"Settings when Calling REST API of Another Service from Questetra (Questetra to be OAuth2 client)","author":"Tsuyoshi Kusaka","date":"2019-01-23","format":false,"excerpt":"Describing in detail about how to set up to use OAuth when linking to other services from Questetra BPM Suite.","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\/2020\/08\/oauth-settings-1200x675-1.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\/08\/oauth-settings-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/oauth-settings-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/oauth-settings-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/oauth-settings-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78460,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/","url_meta":{"origin":72429,"position":3},"title":"Utilize Customer Data on Google Sheets as Choices","author":"Hirotaka NISHI","date":"2020-04-23","format":false,"excerpt":"Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.","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\/2019\/07\/google-sheet-choice-master-featured-image.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\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":93945,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-kintone\/","url_meta":{"origin":72429,"position":4},"title":"Using Kintone App as an External Master","author":"Shiho Tatsumi","date":"2020-08-26","format":false,"excerpt":"We are going to use data that has been managed by kintone as the external options master for Search Select Box in Questetra BPM Suite. For the resource of AWS that relays kintone and Questetra BPM, Terraform is available.","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\/2020\/08\/Kintone-as-Master-1.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\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.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":72429,"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\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/72429","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=72429"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/72429\/revisions"}],"predecessor-version":[{"id":102707,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/72429\/revisions\/102707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102704"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=72429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=72429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=72429"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=72429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}