{"id":12153,"date":"2019-08-30T12:00:09","date_gmt":"2019-08-30T03:00:09","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12153"},"modified":"2019-08-30T13:55:56","modified_gmt":"2019-08-30T04:55:56","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%e6%b7%bb%e4%bb%98%e3%83%95%e3%82%a1%e3%82%a4","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12153","title":{"rendered":"[Google Apps Script]Google \u30d5\u30a9\u30fc\u30e0\u3068kintone\u3092\u9023\u643a\u3055\u305b\u308b\u65b9\u6cd5(\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u7de8)"},"content":{"rendered":"

\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u306f\u3001GAS\u3092\u4f7f\u3063\u3066Google \u30d5\u30a9\u30fc\u30e0\u3067\u5165\u529b\u3055\u308c\u305f\u56de\u7b54\u3092\u305d\u306e\u307e\u307ekintone\u30a2\u30d7\u30ea\u306e\u30ec\u30b3\u30fc\u30c9\u3068\u3057\u3066\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u305d\u306e\u7d9a\u304d\u3067\u3001Google \u30d5\u30a9\u30fc\u30e0\u304b\u3089\u30a2\u30c3\u30d7\u3055\u308c\u305f\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb(\u8cea\u554f\u306e\u7a2e\u985e\uff1a\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148)\u306b\u3082\u5bfe\u5fdc\u3055\u305b\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

kintone\u30a2\u30d7\u30ea\u306e\u8a2d\u5b9a\u3068API\u30c8\u30fc\u30af\u30f3\u306e\u53d6\u5f97<\/h4>\n

\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u4f5c\u6210\u3057\u305fkintone\u30a2\u30d7\u30ea\u306b\u3001\u300c\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb<\/span>\u300d\u30d1\u30fc\u30c4(\u30d5\u30a3\u30fc\u30eb\u30c9\u30b3\u30fc\u30c9\uff1a\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb)\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

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

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

API\u30c8\u30fc\u30af\u30f3\u3082\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3068\u540c\u3058\u624b\u9806\u3067\u53d6\u5f97\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n

Google \u30d5\u30a9\u30fc\u30e0\u306e\u8a2d\u5b9a<\/h4>\n

\u3053\u3061\u3089\u3082\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3068\u540c\u3058\u30d5\u30a9\u30fc\u30e0\u3092\u4f7f\u3044\u3001\u300c\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb<\/span>\u300d(\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5148)\u9805\u76ee\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n

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

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

\u4eca\u56de\u306f\u3068\u308a\u3042\u3048\u305a\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u6700\u5927\u6570\u3092\u300c1<\/span>\u300d\u3068\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n

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

\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u542b\u3081\u3066kintone\u30a2\u30d7\u30ea\u306b\u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8<\/h4>\n

\u6b21\u306f\u809d\u5fc3\u306a\u30b3\u30fc\u30c9\u3067\u3059\u3002
\nAPI\u30c8\u30fc\u30af\u30f3\u306e\u4fdd\u5b58\u5834\u6240\u3084\u30c8\u30ea\u30ac\u30fc\u306b\u3064\u3044\u3066\u306f\u3001\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\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 fileKey;\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  \/\/fileKey\u53d6\u5f97\r\n  e.response.getItemResponses().forEach(function(res) {\r\n    if(res.getItem().getType() == "FILE_UPLOAD") {\r\n      fileKey = uploadFile(res.getResponse(), api_token);\r\n    }\r\n  });\r\n  \r\n  if(typeof fileKey !== 'undefined') {\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        "\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb": {\r\n          "value": [\r\n            {\r\n              "fileKey": null\r\n            }\r\n          ]\r\n        }\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      if(res.getItem().getType() == "FILE_UPLOAD") {\r\n        var v = DriveApp.getFileById(res.getResponse()).getName();\r\n        dat.record[s].value[0].fileKey = fileKey;\r\n      } else {\r\n        var v = res.getResponse();\r\n        dat.record[s].value = v;\r\n      }\r\n      mail_body += s + ":" + v + "\\n";\r\n    });\r\n    \r\n    \/\/kintone API\u547c\u3073\u51fa\u3057(\u30ec\u30b3\u30fc\u30c9\u767b\u9332)\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 = "\u3010\u901a\u77e5\u3011\u65b0\u7740\u56de\u7b54";\r\n      } else {\r\n        mail_subject = "\u3010\u901a\u77e5\u3011\u56de\u7b54\u5931\u6557";\r\n      }\r\n    } catch(e) {\r\n      mail_subject = "\u3010\u901a\u77e5\u3011\u30a8\u30e9\u30fc\u767a\u751f";\r\n    }\r\n  } else {\r\n    mail_subject = "\u3010\u901a\u77e5\u3011\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u5931\u6557";\r\n  }\r\n  GmailApp.sendEmail(mail_to, mail_subject, mail_body); \/\/\u901a\u77e5\u30e1\u30fc\u30eb\u9001\u4fe1\r\n}\r\n\r\nfunction uploadFile(fileID, api_token) {\r\n  var api_url = "https:\/\/(\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3).cybozu.com\/k\/v1\/file.json";\r\n  var boundary = "GoogleFormsTokintone";\r\n  var f = DriveApp.getFileById(fileID);\r\n  var data = "";\r\n  data += "--" + boundary + "\\r\\n";\r\n  \/\/data += "Content-Disposition: form-data; name=\\"file\\"; filename=\\"" + encodeURIComponent(f.getName()) + "\\"\\r\\n";\r\n  data += "Content-Disposition: form-data; name=\\"file\\"; filename=\\"" + f.getName() + "\\"\\r\\n";\r\n  data += "Content-Type:" + f.getMimeType() + "\\r\\n\\r\\n";\r\n  var payload = Utilities.newBlob(data).getBytes()\r\n    .concat(f.getBlob().getBytes())\r\n    .concat(Utilities.newBlob("\\r\\n--" + boundary + "--").getBytes());\r\n  var options = {\r\n    "method": "post",\r\n    "contentType": "multipart\/form-data; boundary=" + boundary,\r\n    "headers": {\r\n      "X-Cybozu-API-Token": api_token\r\n    },\r\n    "payload": payload\r\n  };\r\n  try {\r\n    var res = UrlFetchApp.fetch(api_url, options);\r\n    if(res.getResponseCode() === 200) {\r\n      var json = JSON.parse(res.getContentText());\r\n      return json.fileKey;\r\n    }\r\n  } catch(e) {\r\n  }\r\n}<\/pre>\n
kintone REST API\u306e\u4ed5\u69d8\u306b\u3088\u308a\u3001\u30d5\u30a1\u30a4\u30eb\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9API<\/a>\u306e\u5b9f\u884c\u7d50\u679c\u3068\u3057\u3066\u8fd4\u3063\u3066\u304f\u308b\u30d5\u30a1\u30a4\u30eb\u30ad\u30fc\u3092\u3001\u30ec\u30b3\u30fc\u30c9\u306e\u767b\u9332API<\/a>\u3084\u30ec\u30b3\u30fc\u30c9\u306e\u66f4\u65b0API<\/a>\u306b\u6e21\u3059\u5fc5\u8981\u304c\u3042\u308b\u305f\u3081\u3001\u4e0a\u8a18\u30b3\u30fc\u30c9\u3067\u3082\u3001\u307e\u305a\u6700\u521d\u306b\u300cuploadFile\u300d\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u3061\u306a\u307f\u306b\u3001\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6642\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u30d8\u30c3\u30c0\u306e\u4f5c\u6210\u306f\u4e0b\u8a18\u30b5\u30a4\u30c8\u306e\u30b3\u30fc\u30c9\u3092\u53c2\u8003\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n
\"\"<\/div>
Gist<\/div><\/div>
\"\"<\/figure>
Multipart-POST Request Using Google Apps Script<\/div>
https:\/\/gist.github.com\/tanaikech\/d595d30a592979bbf0c692d1193d260c<\/div>
Multipart-POST Request Using Google Apps Script. GitHub Gist: instantly share code, notes, and snippets.<\/div><\/div>
<\/div><\/div><\/a><\/div><\/div>\n
\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n
Google Apps Script\u306e\u8a2d\u5b9a\u304c\u7d42\u308f\u3063\u305f\u3068\u3053\u308d\u3067\u52d5\u4f5c\u78ba\u8a8d\u3092\u3057\u3066\u307f\u308b\u3068\u3001\u554f\u984c\u304c\u7121\u3051\u308c\u3070\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u4ed8\u304d\u3067kintone\u30a2\u30d7\u30ea\u306b\u30ec\u30b3\u30fc\u30c9\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u672b\u5c3e\u306b\u30a2\u30c3\u30d7\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u540d\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u308b\u306e\u306f\u4ed5\u69d8\u306e\u3088\u3046\u3067\u3059\u3002<\/p>\n
\n
\n