{"id":118072,"date":"2021-12-24T18:16:56","date_gmt":"2021-12-24T09:16:56","guid":{"rendered":"https:\/\/support.questetra.com\/?p=118072"},"modified":"2022-06-09T10:39:29","modified_gmt":"2022-06-09T01:39:29","slug":"airtable-record-add","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/airtable-record-add\/","title":{"rendered":"AirTable: \u884c\u8ffd\u52a0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">AirTable: \u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0 (AirTable: Add New Record)<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> AirTable Base \u306b\u30ec\u30b3\u30fc\u30c9\u30921\u4ef6\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> A: API key \u3092\u8a2d\u5b9a\u3057\u305f\u901a\u4fe1\u8a31\u53ef\u8a2d\u5b9a\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Base ID\uff08\u30b7\u30fc\u30c8\u6bce\u306b\u4ed8\u4e0e\u3055\u308c\u305fId\uff09\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> C: \u30ec\u30b3\u30fc\u30c9 ID \u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D1F: \u8ffd\u52a0\u30c7\u30fc\u30bf1\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> D1V: \u8ffd\u52a0\u30c7\u30fc\u30bf1\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D2F: \u8ffd\u52a0\u30c7\u30fc\u30bf2\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> D2V: \u8ffd\u52a0\u30c7\u30fc\u30bf2\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D3F: \u8ffd\u52a0\u30c7\u30fc\u30bf3\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> D3V: \u8ffd\u52a0\u30c7\u30fc\u30bf3\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D4F: \u8ffd\u52a0\u30c7\u30fc\u30bf4\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> D4V: \u8ffd\u52a0\u30c7\u30fc\u30bf4\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D5F: \u8ffd\u52a0\u30c7\u30fc\u30bf5\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> D5V: \u8ffd\u52a0\u30c7\u30fc\u30bf5\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\nconst FIELD_NUM = 5; \/\/ \u6271\u3048\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u6570\n\nmain();\nfunction main(){\n  \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u30fb\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Config & Data Retrieving ==\n  const authSettingName = configs.get(&quot;conf_auth&quot;);\n  const baseId = configs.get(&quot;conf_baseId&quot;);\n  const recordIdDef = configs.getObject(&quot;conf_recordId&quot;);\n  const recordObj = retrieveRecordContent();\n\n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  const apiUri = determineApiUri( baseId );\n  const recordId = addRecord( apiUri, authSettingName, recordObj );\n\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n  setData( recordIdDef, recordId );\n}\n\n\n\/**\n  * config\u304b\u3089\u30ec\u30b3\u30fc\u30c9\u60c5\u5831\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u3068\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u5024\uff09\u3092\u8aad\u307f\u51fa\u3057\u3001JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\n  * @return {Object} recordObj  \u30ec\u30b3\u30fc\u30c9\u60c5\u5831\u306e JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n  *\/\nfunction retrieveRecordContent() {\n  const recordObj = {};\n  recordObj.records = [];\n  recordObj.records[0] = {};\n  recordObj.records[0].fields = {};\n  for (let i = 0; i &lt; FIELD_NUM; i++) {\n    const fieldNameConfigName = `conf_fieldName${i+1}`;\n    const fieldValueConfigName = `conf_fieldValue${i+1}`;\n\n    const fieldName = configs.get( fieldNameConfigName );\n    if ( fieldName === &quot;&quot; || fieldName === null ) { \/\/ \u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u304c\u7a7a\n      continue;\n    }\n    if ( recordObj[fieldName] !== undefined ) { \/\/ \u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u306e\u6307\u5b9a\u304c\u91cd\u8907\n      throw &quot;The same Field Name is set multiple times.&quot;;\n    }\n    \n    let fieldValue = configs.get( fieldValueConfigName );\n    if ( fieldValue === &quot;&quot; || fieldValue === null ) { \/\/ \u5024\u304c\u7a7a\n      fieldValue = null;\n    }\n    recordObj.records[0].fields[fieldName] = fieldValue;\n  }\n  return recordObj;\n}\n\n\n\/**\n  * REST API \u306e\u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0\u306e URI \u3092\u6c7a\u5b9a\u3059\u308b\n  * \u30c9\u30e1\u30a4\u30f3\u304c\u7a7a\u3001\u307e\u305f\u306f kintone \u306e\u30c9\u30e1\u30a4\u30f3\u3068\u3057\u3066\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * \u30b2\u30b9\u30c8\u30b9\u30da\u30fc\u30b9 ID \u304c\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * @param {String} baseId  \u30b2\u30b9\u30c8\u30b9\u30da\u30fc\u30b9 ID\n  * @return {String} apiUri  API \u306e URI\n  *\/\nfunction determineApiUri( baseId ) {\n  let apiUri = &quot;&quot;;\n  apiUri = `https:\/\/api.airtable.com\/v0\/${baseId}\/Table1?maxRecords=3&view=Grid%20view`;\n\n  return apiUri;\n}\n\n\n\/**\n  * REST API \u306b\u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0\u306e POST \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u4fe1\u3059\u308b\n  * \u30a2\u30d7\u30ea ID \u304c\u7a7a\u3001\u307e\u305f\u306f\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n  * @param {String} apiUri  API \u306e URI\n  * @param {String} authSettingName  API key \u3092\u542b\u3080\u8a8d\u8a3c\u8a2d\u5b9a\n  * @param {Object} recordObj  \u30ec\u30b3\u30fc\u30c9\u60c5\u5831\u306e JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n  * @return {String} recordId  \u30ec\u30b3\u30fc\u30c9 ID\n  *\/\nfunction addRecord( apiUri, apiToken, recordObj ) {\n  const body = recordObj;\n  engine.log(`API URI: ${apiUri}`);\n  engine.log(`Request Body: ${JSON.stringify(body)}`);\n  const response = httpClient.begin()\n    .authSetting(apiToken)\n    .body(JSON.stringify(body), &quot;application\/json; charset=UTF-8&quot;)\n    .post( apiUri );\n  \/\/when error thrown\n  const responseJson = response.getResponseAsString();\n  const status = response.getStatusCode();\n  const accessLog = `---POST request--- ${status}\\n${responseJson}\\n`;\n  engine.log(accessLog);\n  if (status &gt;= 300) {\n    throw `Failed to add record. status: ${status}`;\n  }\n  const json = JSON.parse(responseJson);\n  return json.id;\n}\n\n\n\/**\n  * \u30c7\u30fc\u30bf\u9805\u76ee\u306b\u51fa\u529b\u3059\u308b\n  * @param {ProcessDataDefinitionView} dataDef  \u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n  * @param {String} dataString  \u51fa\u529b\u3059\u308b\u6587\u5b57\u5217\n  *\/\nfunction setData( dataDef, dataString ){\n  if(dataDef !==  null){\n    engine.setData( dataDef, dataString );\n  }\n}\n\n  \n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADOUlEQVRYR8WXTUhUURiGn6P9WIZp\nJs6MEUE\/GxdRIFEQOS2CoFoEEUWGWAuNFkVBEG3aFRTVIi0qMbKighYZ9EM0BdUmyjYtSqNMnRkb\nR0Wd1HTmxJmZO907c+\/MdSrmbM\/3837v+b73nCPI8RJ287va5Fw5j+1S4EayClgClMT9B4FvCNqF\nxCNGue\/dKn7aiZ0RQJlHOvLgmIB6oMBOUGBcwqUInA64hT+dT1oATo+sl3AGKLSZONksJOCozy0u\nWflbAnC8kI1IGrJMbHQTNPmrxQGzWKYAnM\/lLSnY9U+Sx4MIyW3fRrE7OWYKgH9aeWq2FCYMAOJn\n3mSncudsWDMfRsPwLGjHI2YjoEHfEwkAqtvzoTNTw21eCLUVUFUEc\/JBAsFf8DQIl3vgcygjmFAY\nlmnTkQBQ7pHnBBwyc1fV7l8E28qgoiBahemajMDHELR64abPGoiE831ucTjOCCiRicxDEWmY83XF\nUFcB60ugaEbGyhIGipXecXgQgKs94JtI8R3PG6VUiVW0GKdH7pFwI9nsSiUoyvMzypU5uJEpONsF\nl7tT9wXU+NyiNRra8UJeQ1KnNzu4GAYn4evY9FjQV3\/HD1vKoCMEbYEkEIJmf7XYFwPgke8hqu+J\n9bIKlhf+abAWL2wogR3lsHRuKitjYXg7DC29sGAm7HFBZSHMzINbPjjyKYWFdr9brNYADOgulqil\nArBCJ8BhCV9+wr0++DACtS5YWxwbw4cBaPsBNS7YVAqls4yNagFg0O8WCzQAijnDSgag3xyegif9\ncLwDdjpgr8ucFc3HAgB+txBZAVDj9moITnTCqeWxKUm37ADIeAQqwUQEXg\/Bxe\/wZiiW8u7KrAEY\njsC0CbUeUA3mGYDGbng3bKz1LwDomtBkDFUPuArgaT9c+G4tsVkD0I+hmRCp6pWQmKiYgYJ0ADRN\naOqG5l4jcwYhspLi9K1l3QN6TXjUbxrFKMXKJN1llA6IxoDSia4xeBy01P9EmJTLSO3YvY6TwZxc\nBo5ZcN37ZzIyMGd+HSun6TxI7ByPmY3lg0QzzumTTAOR00fpf2Fius\/yBBO5\/JhoIHL6NdN3cc4+\np9mOm12\/37\/KeDBjdSnFAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/17XiCLlSq6okkQtqEDFDuTFmlkxkxi3Je\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">airtable-record-add.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-12-15 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/ja\/addons\/airtable-record-add\/\">https:\/\/support.questetra.com\/ja\/addons\/airtable-record-add\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059<br>\u81ea\u7531\u6539\u5909\u53ef\u80fd\u306a JavaScript (ECMAScript) \u30b3\u30fc\u30c9\u3067\u3059\u3002\u3044\u304b\u306a\u308b\u4fdd\u8a3c\u3082\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/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\"><li>AirTable \u5074\u306e\u8a2d\u5b9a\u3001API key\u30fbBase ID \u7b49\u306e\u53d6\u5f97\u306f<a href=\"https:\/\/www.cdatablog.jp\/entry\/airtableapi\" target=\"_blank\" rel=\"noopener\">\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u307e\u305f\u3001Questetra \u5074\u306e\u300cHTTP \u8a8d\u8a3c\u8a2d\u5b9a\u300d\u306f\u300c\u30c8\u30fc\u30af\u30f3\u76f4\u63a5\u6307\u5b9a\u300d\u3092\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/li><\/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 is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"118084\" data-permalink=\"https:\/\/support.questetra.com\/ja\/addons\/airtable-record-add\/attachment\/airtable-record-add-config-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?fit=967%2C2222&amp;ssl=1\" data-orig-size=\"967,2222\" 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=\"airtable-record-add-config-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?fit=274%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=691%2C1589&#038;ssl=1\" alt=\"\" class=\"wp-image-118084\" width=\"691\" height=\"1589\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=274%2C630&amp;ssl=1 274w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=137%2C315&amp;ssl=1 137w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=768%2C1765&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=668%2C1536&amp;ssl=1 668w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?resize=891%2C2048&amp;ssl=1 891w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-config-ja.png?w=967&amp;ssl=1 967w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>AirTable Base \u306b\u30ec\u30b3\u30fc\u30c9\u30921\u4ef6\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":9,"featured_media":118080,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":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":[169],"tags":[],"class_list":["post-118072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.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\/12\/airtable-record-add-ja.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/airtable-record-add-ja.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/ja\/author\/kusaka0211\/"},"uagb_comment_info":0,"uagb_excerpt":"AirTable Base \u306b\u30ec\u30b3\u30fc\u30c9\u30921\u4ef6\u8ffd\u52a0\u3057\u307e\u3059\u3002","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-uIo","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":122596,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/choices-kintone-app\/","url_meta":{"origin":118072,"position":0},"title":"kintone \u30a2\u30d7\u30ea\u306e\u793e\u54e1\u30c7\u30fc\u30bf\u3092\u9078\u629e\u80a2\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b","author":"Hirotaka NISHI","date":"2022-06-28","format":false,"excerpt":"kintone \u30a2\u30d7\u30ea\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u793e\u54e1\u540d\u7c3f\u3092 API \u7d4c\u7531\u3067\u53d6\u5f97\u3057\u3001\u9078\u629e\u80a2\u30de\u30b9\u30bf\u3068\u3057\u3066\u4fdd\u5b58\u30fb\u5229\u7528\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/ja\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/featured-choices-kintone-app-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/featured-choices-kintone-app-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/featured-choices-kintone-app-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/featured-choices-kintone-app-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/featured-choices-kintone-app-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":104025,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/kintone-workflow-tutorial\/","url_meta":{"origin":118072,"position":1},"title":"\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u304b\u3089 kintone \u3092\u6d3b\u7528\u3059\u308b","author":"Hirotaka NISHI","date":"2021-04-07","format":false,"excerpt":"kintone \u306f\u3001\u30b5\u30a4\u30dc\u30a6\u30ba\u793e\u304c\u63d0\u4f9b\u3057\u3066\u3044\u308b\u30af\u30e9\u30a6\u30c9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d3\u30b9\u3067\u3059\u3002\u81ea\u793e\u3084\u90e8\u7f72\u3054\u3068\u306e\u30cb\u30fc\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/%E3%83%80%E3%82%A6%E3%83%B3%E3%83%AD%E3%83%BC%E3%83%89.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\/03\/%E3%83%80%E3%82%A6%E3%83%B3%E3%83%AD%E3%83%BC%E3%83%89.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/%E3%83%80%E3%82%A6%E3%83%B3%E3%83%AD%E3%83%BC%E3%83%89.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/%E3%83%80%E3%82%A6%E3%83%B3%E3%83%AD%E3%83%BC%E3%83%89.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/%E3%83%80%E3%82%A6%E3%83%B3%E3%83%AD%E3%83%BC%E3%83%89.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":119770,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/google-sheets-employee-master\/","url_meta":{"origin":118072,"position":2},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u793e\u54e1\u60c5\u5831\u3092\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u3067\u7ba1\u7406\u3059\u308b","author":"Hirotaka NISHI","date":"2022-03-16","format":false,"excerpt":"Questetra \u304b\u3089 Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u7ba1\u7406\u3055\u308c\u3066\u3044\u308b\u300c\u793e\u54e1\u60c5\u5831\u300d\u3092\u64cd\u4f5c\u3059\u308b\u30a2\u30d7\u30ea\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/03\/featured-google-sheet-employee-master-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":115353,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/bigquery-add-data\/","url_meta":{"origin":118072,"position":3},"title":"BigQuery \u306b\u81ea\u52d5\u3067\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b","author":"Hirotaka NISHI","date":"2021-10-22","format":false,"excerpt":"Google BigQuery \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18\u3059\u308b\u81ea\u52d5\u5de5\u7a0b\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.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.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.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.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.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":106240,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/start-process-by-kintone-datetime\/","url_meta":{"origin":118072,"position":4},"title":"kintone \u30ab\u30ec\u30f3\u30c0\u30fc\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u306b\u5f93\u3044\u3001\u30d7\u30ed\u30bb\u30b9\u3092\u958b\u59cb\u3059\u308b","author":"Hirotaka NISHI","date":"2021-06-22","format":false,"excerpt":"kintone \u30ec\u30b3\u30fc\u30c9\u306e\u65e5\u6642\u30c7\u30fc\u30bf\u3092\u30c8\u30ea\u30ac\u30fc\u306b Questetra \u306e\u30d7\u30ed\u30bb\u30b9\u3092\u8d77\u52d5\u3057\u3001\u81ea\u52d5\u51e6\u7406\u3092\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/kintone-questetra-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\/2021\/06\/kintone-questetra-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/kintone-questetra-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/kintone-questetra-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/kintone-questetra-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":110055,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-add-suffix-to-column-2021\/","url_meta":{"origin":118072,"position":5},"title":"TSV \u6587\u5b57\u5217; \u7279\u5b9a\u5217\u306b\u63a5\u5c3e\u8f9e","author":"Peter Glover","date":"2021-07-20","format":false,"excerpt":"\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306e\u5168\u30c7\u30fc\u30bf\u306b\u63a5\u5c3e\u8f9eStr\u3092\u7d50\u5408\u3057\u3001\u65b0\u3057\u3044TSV\u6587\u5b57\u5217\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u7d50\u5408\u6587\u5b57\u5217\u306f\u5404\u884c\u672b\u306b\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"TSV \u6587\u5b57\u5217; \u7279\u5b9a\u5217\u306b\u63a5\u5c3e\u8f9e","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Suffix-to-Column-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Suffix-to-Column-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Suffix-to-Column-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Suffix-to-Column-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/08\/Tsv-String-Add-Suffix-to-Column-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/118072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/comments?post=118072"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/118072\/revisions"}],"predecessor-version":[{"id":118093,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/118072\/revisions\/118093"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media\/118080"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media?parent=118072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/categories?post=118072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/tags?post=118072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}