{"id":111337,"date":"2024-12-12T16:00:00","date_gmt":"2024-12-12T07:00:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=111337"},"modified":"2024-12-12T16:03:59","modified_gmt":"2024-12-12T07:03:59","slug":"service-task-google-bigquery-data-insert","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-bigquery-data-insert\/","title":{"rendered":"Google BigQuery: Insert New 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-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"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<h4 class=\"wp-block-heading has-border-color has-product-main-border-color has-white-color has-product-main-background-color has-text-color has-background has-link-color\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--20)\"><strong>Google BigQuery: Insert New Data<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-border-color has-product-main-border-color has-white-color has-product-main-background-color has-text-color has-background has-link-color has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-bigquery-data-insert\/\">Google BigQuery: \u30c7\u30fc\u30bf\u8ffd\u52a0<\/a><\/p>\n\n\n\n<p class=\"has-border-color has-product-main-border-color has-text-color has-white-background-color has-background has-link-color mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--30);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--20)\">This item inserts a new data row to a table on BigQuery.<\/p>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\"><img decoding=\"async\" src=\"data:image;base64,\n        iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAERUlEQVRYR8WXfWyTVRSHn9uvdW1X\n        4lgIwShTTDRo1KEGExMC3R\/zI6goCNvUIEbd0BHRRWAbkeCmwCBOcY4QnBEF2YygosmMrMyoCUgC\n        xiBqAqImED\/Ama1f69c19+3add3bt0UxvX++Ofec55x7fufeV1DgJfKNP3\/dWUfA6r4PmCclFQhZ\n        DuKSxH45iBQ\/C8Ex4KAjMrR3\/7ppgXx85wSYu8k31RRlFZI6wJ6PUyCEYFvcwsaB51y\/Ge0xBPC0\n        DtchxGbAmWfgTDM\/UjZ6W0q2ZdufFcDT5n8dZP2\/DJyxTXR5m53L9XzpAnhah3cjRPXFCT7qRcp3\n        vS0lNZk+JwBc3MwnhJtQiXEAo2feZZT5FLeg6noLl5aakBJ+PRen79sog36ZX8GkrE\/viRSA1u0R\n        TmZruKmTBOsX2ZkxxaQb6MSZOGvfC\/F3ICeIP27lqqQ6UgCeF30vI3laz\/t1l5nZUmvHMho7GoPf\n        h+KYhaDMLVLfw1FY\/maQ03\/Gjash6PA2uVYqIw1ADRm\/1X1eT+eTHILeBgcWM8TisONgmN7DkVQA\n        IWDpHBu1t1k1Z8Gw5P5XAoyMmejBhJyRoclqWGkAlW2+ByW8rWfZXmNnVrlZO++n3gryw1n97G6+\n        wsyGarsGceB4lJc+GjGsgoCH+ptd7yQB3pCwLHOHKnnfKicqy71HInR+FtZMTAKeqLQxFJTs+mos\n        1ZZ7i5g300IkBrdv9OcC6O5vdj2qAXhafUcRVGTuuOVKMxuWJKbvne3+VFmLbYKPGx2oXqhKC1RW\n        IuhpcGj2D3cFOTNo0AuSY94W16wEQNvwX2MXyxjGPTdZWVFl0wIrACW\/2TPMdPSF2bdyIoDa+elq\n        p9aUTT0hDp+KGVRBDnqbS0pHAXy62rnjBguNdxWlMlVKuHG6mSVbA+xpSAAs6AjQ9Yid\/u+i7Pwi\n        woEmp9YHz+4K8c0vRgDgbXap01UV0AeYXmai+\/FiLYv67qB27pkANZ0Belc4OHQyxv6jEdoeSBzZ\n        \/C0BAiPGMyENQP8IlKMPn3HgsgtO\/xGn\/ZMROpcWU\/3aWAUUwO4nHSzbHmRzrR01Kc8NSxZvzfUc\n        SD+CLE2oABbNtlJXadOy6j8eZcdAmOEQWg\/4Q5KFrwZwFwvW3F2Ealq1XvhghIETUUMVkN6ElW0+\n        XRkmPaisr5mWGIPnfZKeQxE+\/z6qydFzrYXFt1o1iOQ68lOM1XtC+cvQaBAldb+p2k5FeSLDfNbX\n        p2Ks6ckOMW4QGY3i9GBKgo95bFw+2YQ5eS\/E0fpDDalSl2DtgqLEfAe+\/DHG8+\/rQowfxZoSDC4j\n        vYxV+VWPqxGdvubOtKAmooJQMlRynLAyLyNlkOs6zqfsSRsFMedqM+v36d4H+texVoXEI9TwQXIh\n        ILq22R4kSeOCPslSEIV8lP4\/lbjAZ3laJQr3Y5Lq6EL+mqV3ccF+Tv+z7HI4+AfnY90wO\/4PaAAA\n        AABJRU5ErkJggg==\n    \" alt=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-4-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Basic Configs<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Step Name<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">Note<\/dd>\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_auth<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: OAuth2 Setting<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_projectId<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: Project ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_datasetId<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C3: Dataset ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_tableId<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: Table ID<span style=\"color:#990000;\"> *<\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_templateSuffix<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C5: Template Suffix (required if the table is a base template)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6F: Field 1<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C6V: Value 1<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7F: Field 2<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C7V: Value 2<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C8F: Field 3<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C8V: Value 3<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C9F: Field 4<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C9V: Value 4<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C10F: Field 5<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C10V: Value 5<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C11F: Field 6<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C11V: Value 6<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_field7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C12F: Field 7<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">conf_value7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C12V: Value 7<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Google account that uses this modeling element must have permissions to update BigQuery tables, such as the bigquery.dataEditor role. For details of BigQuery permissions\/roles see the <a href=\"https:\/\/cloud.google.com\/iam\/docs\/understanding-roles#bigquery-roles\" target=\"_blank\" rel=\"noreferrer noopener\">Google Cloud IAM Documentation<\/a>.<\/li>\n\n\n\n<li>Supported data types are: <strong>STRING, BYTES, INTEGER, FLOAT, NUMERIC, BIGNUMERIC, BOOLEAN, TIMESTAMP, DATE, TIME, DATETIME<\/strong>.<\/li>\n\n\n\n<li>Each value must be set in the format that matches its field&#8217;s data type defined by the table schema. For example, to set a value in a\u00a0<strong>DATETIME<\/strong>\u00a0field, the input must be something like\u00a0<em>2015-03-17 10:20:00<\/em>. For more details see the <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/\" target=\"_blank\" rel=\"noreferrer noopener\">BigQuery Documentation<\/a>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"707\" height=\"630\" data-attachment-id=\"111394\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-bigquery-data-insert\/attachment\/google-bigquery-data-insert_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?fit=1430%2C1274&amp;ssl=1\" data-orig-size=\"1430,1274\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"google-bigquery-data-insert_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?fit=707%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?resize=707%2C630&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-111394\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?resize=707%2C630&amp;ssl=1 707w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?resize=354%2C315&amp;ssl=1 354w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?resize=768%2C684&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/google-bigquery-data-insert_en.png?w=1430&amp;ssl=1 1430w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/google-api-user-data-policy\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google API User Data Policy<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">Adding Data to BigQuery Automatically<\/a><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<ul class=\"wp-block-list\">\n<li>An XML file that contains the code below is available to download\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/raw.githubusercontent.com\/Questetra\/Addon-XML\/release-2024-07-30\/google-bigquery-data-insert.xml\" target=\"_blank\" rel=\"noreferrer noopener\">google-bigquery-data-insert.xml<\/a> (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>If you are using Professional, you can modify the contents of this file and use it as your own add-on auto step<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\n\/\/ OAuth2 config sample at [OAuth 2.0 Setting]\n\/\/ - Authorization Endpoint URL: https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&amp;approval_prompt=force\n\/\/ - Token Endpoint URL: https:\/\/oauth2.googleapis.com\/token\n\/\/ - Scope: https:\/\/www.googleapis.com\/auth\/bigquery\n\/\/ - Consumer Key: (Get by Google Developer Console)\n\/\/ - Consumer Secret: (Get by Google Developer Console)\n\nconst FIELD_NUM = 7; \/\/ \u6271\u3048\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u6570\n\nfunction main(){\n  \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u30fb\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Config &amp; Data Retrieving ==\n  const oauth2 = configs.getObject(&quot;conf_auth&quot;);\n  const projectId = configs.get(&quot;conf_projectId&quot;);\n  const datasetId = configs.get(&quot;conf_datasetId&quot;);\n  const tableId = configs.get(&quot;conf_tableId&quot;);\n  const templateSuffix = configs.get(&quot;conf_templateSuffix&quot;);\n\n  isValidProjectId( projectId );\n  isValidDatasetId( datasetId );\n  isValidTableId( `${tableId}${templateSuffix}` );\n\n  const dataObj = retrieveDataObj();\n\n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  insertData( oauth2, projectId, datasetId, tableId, templateSuffix, dataObj );\n}\n\n\/**\n  * \u30d7\u30ed\u30b8\u30a7\u30af\u30c8 ID \u304c\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\n  * @param {String} projectId  \u30d7\u30ed\u30b8\u30a7\u30af\u30c8 ID\n  *\/\nfunction isValidProjectId( projectId ) {\n  const reg = new RegExp( &apos;^[a-zA-Z][0-9a-zA-Z-]{4,28}[0-9a-zA-Z]$&apos; );\n  if ( !reg.test(projectId) ) {\n    throw new Error(&quot;Invalid Project ID.&quot;);\n  }\n}\n\n\/**\n  * \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8 ID \u304c\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\n  * @param {String} datasetId  \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8 ID\n  *\/\nfunction isValidDatasetId( datasetId ) {\n  const reg = new RegExp( &apos;^\\\\w{1,1024}$&apos; );\n  if ( !reg.test(datasetId) ) {\n    throw new Error(&quot;Invalid Dataset ID.&quot;);\n  }\n}\n\n\/**\n  * \u30c6\u30fc\u30d6\u30eb ID \uff08\u30b5\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u542b\u3080\uff09\u304c\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\n  * @param {String} tableId  \u30c6\u30fc\u30d6\u30eb ID\n  *\/\nfunction isValidTableId( tableId ) {\n  if( encodeURIComponent(tableId).replace(\/%..\/g,&quot;x&quot;).length &gt; 1024 ) {\n    throw new Error(&quot;Invalid Table ID and\/or Template Suffix. Too long.&quot;);\n  }\n  const reg = new RegExp( &apos;^[\\\\p{L}\\\\p{M}\\\\p{N}\\\\p{Pc}\\\\p{Pd}\\\\p{Zs}]+$&apos; , &apos;u&apos;);\n  if ( !reg.test(tableId) ) {\n    throw new Error(&quot;Invalid Table ID and\/or Template Suffix. Includes an invalid character.&quot;);\n  }\n}\n\n\/**\n  * config \u304b\u3089\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u5024\u306e\u7d44\u3092\u8aad\u307f\u51fa\u3057\u3001JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\n  * @return {Object} dataObj  \u30c7\u30fc\u30bf\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n  *\/\nfunction retrieveDataObj() {\n  const dataObj = {};\n  for (let i = 0; i &lt; FIELD_NUM; i++) {\n    const field = configs.get(`conf_field${i+1}`);\n    let value = configs.get(`conf_value${i+1}`);\n    if ( field === &quot;&quot; || field === null ) { \/\/ \u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u7a7a\n      continue;\n    }\n    if (field.length &gt; 300) { \/\/ \u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u304c\u9577\u3059\u304e\u308b\n      throw new Error(`Invalid Field Name: ${field}. Too long.`);\n    }\n    if ( dataObj[field] !== undefined ) { \/\/ \u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u306e\u6307\u5b9a\u304c\u91cd\u8907\n      throw new Error(`The same field ${field} is set multiple times.`);\n    }\n    if ( value === &quot;&quot; || value === null ) { \/\/ \u5024\u304c\u7a7a\n      value = null;\n    }\n    dataObj[field] = value;\n  }\n  return dataObj;\n}\n\n\/**\n  * \u30c7\u30fc\u30bf\u8ffd\u52a0\u306e POST \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1\u3059\u308b\n  * @param {AuthSettingWrapper} oauth2  OAuth2 \u8a8d\u8a3c\u8a2d\u5b9a\n  * @param {String} projectId  \u30d7\u30ed\u30b8\u30a7\u30af\u30c8 ID\n  * @param {String} datasetId  \u30c7\u30fc\u30bf\u30bb\u30c3\u30c8 ID\n  * @param {String} tableId  \u30c6\u30fc\u30d6\u30eb ID\n  * @param {String} templateSuffix  \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u30b5\u30d5\u30a3\u30c3\u30af\u30b9\n  * @param {Object} dataObj  \u30c7\u30fc\u30bf\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n  *\/\nfunction insertData( oauth2, projectId, datasetId, tableId, templateSuffix, dataObj ) {\n  const uri = `https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/${projectId}\/datasets\/${datasetId}\/tables\/${tableId}\/insertAll`;\n\n  const body = {};\n  body[&quot;kind&quot;] = &quot;bigquery#tableDataInsertAllRequest&quot;;\n  body[&quot;rows&quot;] = [{ &quot;json&quot;: dataObj }];\n  if ( templateSuffix !== &quot;&quot; &amp;&amp; templateSuffix !== null ) {\n    body[&quot;templateSuffix&quot;] = templateSuffix;\n  }\n\n  const response = httpClient.begin()\n    .authSetting( oauth2 )\n    .body( JSON.stringify(body), &quot;application\/json; charset=UTF-8&quot; )\n    .post(encodeURI(uri));\n\n  const status = response.getStatusCode();\n  const responseStr = response.getResponseAsString();\n  if ( status &gt;= 300 ) { \/\/ when error thrown\n    engine.log(responseStr);\n    throw new Error(`Failed to insert data. status: ${status}`);\n  }\n  const errors = JSON.parse(responseStr)[&quot;insertErrors&quot;];\n  if ( errors !== undefined ) {\n    engine.log(JSON.stringify(errors));\n    throw new Error(&quot;Failed to insert data.&quot;);\n  }\n}\n\n  \n    <\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Inserts a new data row to a table in BigQuery.<\/p>\n","protected":false},"author":17,"featured_media":111420,"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":"{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":[551],"tags":[],"faq_section":[],"class_list":["post-111337","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bpmn-icons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Shiho Tatsumi","author_link":"https:\/\/support.questetra.com\/en\/author\/tatsumi48c607ec82\/"},"uagb_comment_info":2,"uagb_excerpt":"Inserts a new data row to a table in BigQuery.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sXL","jetpack-related-posts":[{"id":115633,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/","url_meta":{"origin":111337,"position":0},"title":"Adding Data to BigQuery Automatically","author":"Hirotaka NISHI","date":"2021-10-22","format":false,"excerpt":"Describes the auto-step for adding data to Google BigQuery tables.","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\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76467,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-pdf-generation\/","url_meta":{"origin":111337,"position":1},"title":"Generate PDF File","author":"Hirotaka NISHI","date":"2021-09-28","format":false,"excerpt":"Inserts business data into a Base PDF form and automatically generate a new PDF file. Although Adobe Acrobat etc. are needed for the preparation of a Base PDF, it is also possible to download a Base PDF with selecting fields from the setting screen, unless you do not care about\u2026","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\/09\/bpmn-icon-service-task-generate-pdf-2024.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\/bpmn-icon-service-task-generate-pdf-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-generate-pdf-2024.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-generate-pdf-2024.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-generate-pdf-2024.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":119881,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheets-employee-master\/","url_meta":{"origin":111337,"position":2},"title":"Managing Employee Information in Google Spreadsheets with Workflow Apps","author":"Peter Glover","date":"2022-05-11","format":false,"excerpt":"Introducing an application to manipulate employee information managed in Google Spreadsheets from Questetra.","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\/2022\/03\/google-sheet-employee-master-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\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/google-sheet-employee-master-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":113992,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1320\/","url_meta":{"origin":111337,"position":3},"title":"Ver.13.2 2021-10-10  Added Auto-step for Data Linkage to Google BigQuery","author":"Hirotaka NISHI","date":"2021-09-27","format":false,"excerpt":"You will be able to link data to Google BigQuery. In addition, the integration with Google Sheets will be strengthened, and the form Javascript API will be available for some data types.","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\/2021\/09\/version-1320-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\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-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":111337,"position":4},"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":67059,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlecalendar-insertevent\/","url_meta":{"origin":111337,"position":5},"title":"Google Calendar: Insert Event","author":"HatanakaAkihiro","date":"2024-04-12","format":false,"excerpt":"This item inserts an event to Google Calendar.","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\/06\/bpmn-icon-service-task-google-calendar.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\/06\/bpmn-icon-service-task-google-calendar.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-service-task-google-calendar.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-service-task-google-calendar.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-service-task-google-calendar.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\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111337","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\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=111337"}],"version-history":[{"count":18,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111337\/revisions"}],"predecessor-version":[{"id":168896,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111337\/revisions\/168896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/111420"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=111337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=111337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=111337"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=111337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}