{"id":12129,"date":"2019-08-23T15:00:55","date_gmt":"2019-08-23T06:00:55","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12129"},"modified":"2019-08-30T13:57:42","modified_gmt":"2019-08-30T04:57:42","slug":"google-apps-scriptgoogle-%e3%83%95%e3%82%a9%e3%83%bc%e3%83%a0%e3%81%a8kintone%e3%82%92%e9%80%a3%e6%90%ba%e3%81%95%e3%81%9b%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12129","title":{"rendered":"[Google Apps Script]Google \u30d5\u30a9\u30fc\u30e0\u3068kintone\u3092\u9023\u643a\u3055\u305b\u308b\u65b9\u6cd5"},"content":{"rendered":"

Web\u30d5\u30a9\u30fc\u30e0\u3067\u5165\u529b\u3055\u308c\u305f\u56de\u7b54\u3092\u3001\u76f4\u63a5kintone\u306e\u30a2\u30d7\u30ea\u306b\u4fdd\u5b58\u3057\u305f\u3044\u3068\u304d\u3001\u300c\u30d5\u30a9\u30fc\u30e0\u30d6\u30ea\u30c3\u30b8<\/a>\u300d\u306e\u3088\u3046\u306a\u9023\u643a\u30b5\u30fc\u30d3\u30b9\u3092\u4f7f\u3046\u3068\u4fbf\u5229\u3067\u3059\u3002<\/p>\n

\u305f\u3060\u3057\u3001\u30d5\u30a9\u30fc\u30e0\u30d6\u30ea\u30c3\u30b8<\/a>\u306f\u6709\u6599\u3067\u3001\u6700\u3082\u4f4e\u4fa1\u683c\u306a\u300c\u30e9\u30a4\u30c8<\/a>\u300d\u30d7\u30e9\u30f3\u3067\u3082\u6708\u984d6,000\u5186\u639b\u304b\u308a\u307e\u3059(2019\u5e748\u6708\u6642\u70b9)\u3002<\/p>\n

\u305d\u3053\u3067\u4eca\u56de\u306f\u3001\u7121\u6599\u3067\u4f7f\u3048\u308bGoogle \u30d5\u30a9\u30fc\u30e0<\/a>\u3068kintone\u3092\u3001Google Apps Script\u3092\u4f7f\u3063\u3066\u9023\u643a\u3055\u305b\u3066\u307f\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

kintone\u30a2\u30d7\u30ea\u306e\u8a2d\u5b9a<\/h4>\n

\u307e\u305a\u306f\u3001\u56de\u7b54\u306e\u4fdd\u5b58\u5148\u3068\u306a\u308bkintone\u5074\u3067\u3001\u30a2\u30d7\u30ea\u306e\u6e96\u5099\u3068API\u30c8\u30fc\u30af\u30f3\u306e\u53d6\u5f97\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n

    \n
  1. \u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u753b\u9762\u3067\u5fc5\u8981\u306a\u30d1\u30fc\u30c4\u3092\u914d\u7f6e\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u300c\u6c0f\u540d<\/span>\u300d(\u6587\u5b57\u5217\uff08\uff11\u884c\uff09)\u3001\u300c\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/span>\u300d(\u6587\u5b57\u5217\uff08\uff11\u884c\uff09)\u3001\u300c\u6027\u5225<\/span>\u300d(\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3)\u3001\u300c\u81ea\u5df1\u30a2\u30d4\u30fc\u30eb<\/span>\u300d(\u6587\u5b57\u5217\uff08\uff11\u884c\uff09)\u3068\u3044\u3046\u30014\u3064\u306e\u30d1\u30fc\u30c4\u3092\u914d\u7f6e\u3057\u307e\u3057\u305f\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  2. \u305d\u308c\u305e\u308c\u306e\u30d1\u30fc\u30c4\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u306f\u3001\u5206\u304b\u308a\u3084\u3059\u3044\u3088\u3046\u306b\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3068\u4e00\u81f4\u3055\u305b\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  3. \u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u304c\u7d42\u308f\u3063\u305f\u3089\u300c\u30d5\u30a9\u30fc\u30e0\u3092\u4fdd\u5b58<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u7de8\u96c6\u5185\u5bb9\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  4. \u9023\u643a\u306b\u5fc5\u8981\u306aAPI\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u3001\u300c\u8a2d\u5b9a<\/span>\u300d\u30bf\u30d6\u304b\u3089\u300cAPI\u30c8\u30fc\u30af\u30f3<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  5. \u300c\u751f\u6210\u3059\u308b<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066API\u30c8\u30fc\u30af\u30f3\u3092\u4f5c\u6210\u3057\u3001\u30a2\u30af\u30bb\u30b9\u6a29\u306e\u300c\u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0<\/span>\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u305f\u5f8c\u3001\u300c\u4fdd\u5b58<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u4f5c\u6210\u3057\u305fAPI\u30c8\u30fc\u30af\u30f3\u306f\u5f8c\u3067\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u3001\u30e1\u30e2\u5e33\u306a\u3069\u306b\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n

    \"\"<\/a><\/p>\n

  6. \u300c\u30a2\u30d7\u30ea\u3092\u66f4\u65b0<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u30a2\u30d7\u30ea\u306e\u5909\u66f4\u5185\u5bb9\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n

    \"\"<\/a>\n<\/ol>\n

    \u4ee5\u4e0a\u3067kintone\u5074\u306e\u6e96\u5099\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n

    Google \u30d5\u30a9\u30fc\u30e0\u3068\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u8a2d\u5b9a<\/h4>\n

    \u6b21\u306f\u3001\u516c\u958b\u3059\u308bWeb\u30d5\u30a9\u30fc\u30e0(Google \u30d5\u30a9\u30fc\u30e0)\u306e\u6e96\u5099\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n

      \n
    1. Google \u30d5\u30a9\u30fc\u30e0<\/a>\u304b\u3089\u65b0\u898f\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/li>\n
    2. kintone\u30a2\u30d7\u30ea\u306b\u5408\u308f\u305b\u3066\u8cea\u554f\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u4eca\u56de\u306f\u3001\u300c\u6c0f\u540d<\/span>\u300d(\u8a18\u8ff0\u5f0f)\u3001\u300c\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/span>\u300d(\u8a18\u8ff0\u5f0f)\u3001\u300c\u6027\u5225<\/span>\u300d(\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3)\u3001\u300c\u81ea\u5df1\u30a2\u30d4\u30fc\u30eb<\/span>\u300d(\u8a18\u8ff0\u5f0f)\u3068\u3044\u3046\u30014\u3064\u306e\u8cea\u554f\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f\u3002\u5404\u8cea\u554f\u306e\u30bf\u30a4\u30c8\u30eb\u306f\u3001kintone\u30a2\u30d7\u30ea\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\u3068\u4e00\u81f4\u3055\u305b\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n

      \"\"<\/a><\/p>\n

    3. \u300c\u305d\u306e\u4ed6<\/span>\u300d\u30dc\u30bf\u30f3\u304b\u3089\u300c\u30b9\u30af\u30ea\u30d7\u30c8 \u30a8\u30c7\u30a3\u30bf<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n

      \"\"<\/a><\/p>\n

    4. \u30d5\u30a1\u30a4\u30eb \u2192 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3 \u2192 \u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3 \u304b\u3089\u3001\u300cCybozu-API-Token<\/span>\u300d\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u3057\u3066\u3001\u4e0a\u8a18\u624b\u9806\u3067\u30b3\u30d4\u30fc\u3057\u3066\u304a\u3044\u305f\u3001kintone\u30a2\u30d7\u30ea\u306eAPI\u30c8\u30fc\u30af\u30f3\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n

      \"\"<\/a><\/p>\n

    5. \u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u3001API\u306eURL\u3084\u30a2\u30d7\u30eaID(kintone\u30a2\u30d7\u30ea\u306eURL\u3010https:\/\/***.cybozu.com\/k\/\u3007\u3007\/\u3011\u5de6\u8a18\u306e\u300c\u3007\u3007\u300d\u90e8\u5206\u304c\u30a2\u30d7\u30eaID\u3067\u3059)\u3001\u901a\u77e5\u30e1\u30fc\u30eb\u306e\u5b9b\u5148\u90e8\u5206\u3092\u74b0\u5883\u306b\u5408\u308f\u305b\u3066\u66f8\u304d\u63db\u3048\u307e\u3059\u3002<\/li>\n
      function onFormSubmit(e) {\r\n  var api_url = "https:\/\/(\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3).cybozu.com\/k\/v1\/record.json";\r\n  var api_token = PropertiesService.getScriptProperties().getProperty("Cybozu-API-Token");\r\n  var app_id = (kintone\u306e\u30a2\u30d7\u30eaID);\r\n  var mail_to = (\u901a\u77e5\u30e1\u30fc\u30eb\u5b9b\u5148\u30a2\u30c9\u30ec\u30b9);\r\n  var mail_body, mail_subject;\r\n  \r\n  \/\/\u901a\u77e5\u30e1\u30fc\u30eb\u5185\u5bb9\u8a2d\u5b9a\r\n  mail_body = "\u65e5\u6642\uff1a" + Utilities.formatDate(new Date(), "JST", "yyyy\/MM\/dd HH:mm:ss") + "\\n\\n";\r\n  mail_body += "<<< \u30d5\u30a9\u30fc\u30e0\u56de\u7b54\u5185\u5bb9 >>>\\n";\r\n  \r\n  \/\/JSON\u8a2d\u5b9a\r\n  var dat = {\r\n    "app": null,\r\n    "record": {\r\n      "\u6c0f\u540d": {"value": null},\r\n      "\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9": {"value": null},\r\n      "\u6027\u5225": {"value": null},\r\n      "\u81ea\u5df1\u30a2\u30d4\u30fc\u30eb": {"value": null}\r\n    }\r\n  };\r\n  dat.app = app_id;\r\n  e.response.getItemResponses().forEach(function(res) {\r\n    var s = res.getItem().getTitle();\r\n    var v = res.getResponse();\r\n    mail_body += s + ":" + v + "\\n";\r\n    dat.record[s].value = v;\r\n  });\r\n  \r\n  \/\/kintone API\u547c\u3073\u51fa\u3057\r\n  var options = {\r\n    "method": "post",\r\n    "contentType": "application\/json",\r\n    "headers": {\r\n      "X-Cybozu-API-Token": api_token\r\n    },\r\n    "payload": JSON.stringify(dat)\r\n  };\r\n  try {\r\n    var res = UrlFetchApp.fetch(api_url, options);\r\n    if(res.getResponseCode() === 200) {\r\n      mail_subject = "\u65b0\u7740\u56de\u7b54\u901a\u77e5";\r\n    } else {\r\n      mail_subject = "\u56de\u7b54\u5931\u6557\u901a\u77e5";\r\n    }\r\n  } catch(e) {\r\n    mail_subject = "\u30a8\u30e9\u30fc\u901a\u77e5";\r\n  }\r\n  GmailApp.sendEmail(mail_to, mail_subject, mail_body); \/\/\u901a\u77e5\u30e1\u30fc\u30eb\u9001\u4fe1\r\n}<\/pre>\n
    6. \u4e0a\u8a18\u30b3\u30fc\u30c9\u306e\u901a\u308a\u3001\u767b\u9332\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u60c5\u5831\u3092JSON\u5f62\u5f0f\u3067POST\u3059\u308b\u308f\u3051\u3067\u3059\u304c\u3001API\u306e\u8a73\u7d30\u306a\u8aac\u660e\u306f\u4e0b\u8a18\u30b5\u30a4\u30c8\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/li>\n
      \"\"<\/div>
      cybozu developer network<\/div><\/div>
      \"\"<\/figure>
      \u30ec\u30b3\u30fc\u30c9\u306e\u767b\u9332\uff08POST\uff09<\/div>
      https:\/\/developer.cybozu.io\/hc\/ja\/articles\/202166160<\/div>
      index Index\u30ec\u30b3\u30fc\u30c9\u306e\u767b\u9332\uff081\u4ef6\uff09\u30ec\u30b3\u30fc\u30c9\u306e\u4e00\u62ec\u767b\u9332\u5236\u9650\u4e8b\u9805\u95a2\u9023Tips index \u30ec\u30b3\u30fc\u30c9\u306e\u767b\u9332\uff081\u4ef6\uff09\u30ec\u30b3\u30fc\u30c9\u306e\u8ffd\u52a0\u6a29\u9650\u306e\u3042\u308b\u30e6\u30fc\u30b6\u30fc\u304c\u30011\u4ef6\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u767b\u9332\u3067\u304d\u307e\u3059\u3002\u5fc5\u9808\u9805\u76ee\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306b\u306f\u3001\u305d\u306e\u5024\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u542b\u3081\u3066\u304f\u3060\u3055\u3044\u3002HTTP \u30e1\u30bd\u30c3\u30c9POSTURIhttps:\/\/(\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u540d).cybozu.com\/k\/v...<\/div><\/div>
      <\/div><\/div><\/a><\/div><\/div>\n
    7. \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4fdd\u5b58\u3057\u305f\u5f8c\u3001\u300c\u7de8\u96c6<\/span>\u300d\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300c\u73fe\u5728\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c8\u30ea\u30ac\u30fc<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
      \"\"<\/a><\/p>\n
    8. \u300c\u30c8\u30ea\u30ac\u30fc\u3092\u8ffd\u52a0<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n
      \"\"<\/a><\/p>\n
    9. \u4e0b\u8a18\u8a2d\u5b9a\u5f8c\u3001\u300c\u4fdd\u5b58<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\n