{"id":169,"date":"2017-02-28T00:05:25","date_gmt":"2017-02-27T15:05:25","guid":{"rendered":"https:\/\/cg-method.com\/entry\/2017\/02\/28\/000525"},"modified":"2017-02-28T00:05:25","modified_gmt":"2017-02-27T15:05:25","slug":"chatwork-reservation-post","status":"publish","type":"post","link":"https:\/\/cg-method.com\/work-tools\/chatwork-reservation-post\/","title":{"rendered":"Chatwork\u2502GAS\u3092\u4f7f\u3063\u305f\u6295\u7a3f\u65b9\u6cd5 4\u9078"},"content":{"rendered":"\n

Chatwork\u306b\u4e88\u7d04\u6295\u7a3f\u6a5f\u80fd\u306f\u307e\u3060\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\u3067\u3059\u306e\u3067\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u3068GAS\uff08Google Apps Script\uff09\u3092\u4f7f\u3063\u3066\u306e\u4e88\u7d04\u6295\u7a3f\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

Chatwork<\/span>\u3067\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u306b\u4e88\u7d04\u6295\u7a3f\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n

Google Apps Script\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u306e\u5229\u7528\u7533\u8acb<\/h3>\n\n\n\n

\u5916\u90e8\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\uff08Google Apps Script\uff09\u3092\u4f7f\u7528\u3059\u308b\u70ba\u3001\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u306e\u5165\u624b\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n

http:\/\/developer.Chatwork.com\/ja\/index.html<\/div>\n\n\n

Google Apps Script\u306e\u8a2d\u5b9a\u3068\u30c6\u30b9\u30c8\u6295\u7a3f<\/h3>\n\n\n\n

Google\u30c9\u30e9\u30a4\u30d6\uff1e\u305d\u306e\u4ed6\uff1e\u30a2\u30d7\u30ea\u3092\u8ffd\u52a0\u304b\u3089Google Apps Script\u3092\u691c\u7d22\u3057\u3066\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

Google Apps Script\u3092\u958b\u3044\u305f\u3089\u3001\u307e\u305a\u30ea\u30bd\u30fc\u30b9\uff1e\u30e9\u30a4\u30d6\u30e9\u30ea\u304b\u3089ChatworkClient\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30ad\u30fc\u3092\u691c\u7d22\u3057\u3066\u8ffd\u52a0\u3002\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u6700\u65b0\u306b\u3057\u3066\u4fdd\u5b58\u3057\u307e\u3059\u3002 <\/p>\n\n\n\n

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

M6TcEyniCs1xb3sdXFF_FhI-MNonZQ_sT <\/span> <\/code><\/p>\n\n\n

\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tGitHub<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tGitHub – chatwork\/chatwork-client-gas: Chatwork Client for Google Apps Script<\/a>\n\t\t\t\t\t\tChatwork Client for Google Apps Script. Contribute to chatwork\/chatwork-client-gas development by creating an account on GitHub.<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n

\u30b3\u30fc\u30c9\u306e\u5165\u529b <\/p>\n\n\n\n

\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u30b3\u30fc\u30c9.gs\u306b\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/span> <\/p>\n\n\n\n

function sendMessageTest() {\n  var client = ChatworkClient.factory({\n    token: '\u3053\u3053\u306bAPI\u3092\u5165\u529b'\n  });\n  client.sendMessage({\n    room_id: \u3053\u3053\u306b\u30eb\u30fc\u30e0ID\u3092\u5165\u529b,\n    body: '\u9001\u308a\u305f\u3044\u5185\u5bb9\u3092\u5165\u529b'\n  });\n}<\/code><\/pre><\/div>\n\n\n\n
\u30eb\u30fc\u30e0ID\u306f\u9001\u308a\u305f\u3044\u30eb\u30fc\u30e0\u306e\u30a2\u30c9\u30ec\u30b9\u306b\u66f8\u3044\u3066\u3042\u308b\u756a\u53f7\u3092\u5165\u529b\u3057\u307e\u3059\u3002 <\/p>\n\n\n\n
\"\" <\/p>\n\n\n\n
\n
\u5b9f\u884c<\/p>\n
\u518d\u751f\u30dc\u30bf\u30f3\u307e\u305f\u306f\u5b9f\u884c\u30e1\u30cb\u30e5\u30fc\u304b\u3089sendMessageTest\u3092\u62bc\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n
\u3059\u3053\u3057\u30e9\u30b0\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u306b\u6295\u7a3f\u3055\u308c\u3066\u3044\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n<\/p>\n\n\n\n
\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u3067\u4e88\u7d04\u6295\u7a3f\u3059\u308b<\/h3>\n\n\n\n
 \u30b9\u30c8\u30c3\u30d7\u30a6\u30aa\u30c3\u30c1\u30dc\u30bf\u30f3\u307e\u305f\u306f\u30ea\u30bd\u30fc\u30b9\uff1e\u73fe\u5728\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c8\u30ea\u30ac\u30fc\u304b\u3089\u65b0\u3057\u3044\u30c8\u30ea\u30ac\u30fc\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/span><\/p>\n\n\n\n
 \u6642\u9593\u4e3b\u5c0e\u578b\u3001\u7279\u5b9a\u306e\u65e5\u6642\u3092\u9078\u3073\u65e5\u4ed8\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/span> 
\"\"<\/figure> \u4f8b<\/span> <\/p>\n\n\n\n
2017-02-27 23:26 <\/span> <\/p>\n\n\n\n
\u4fdd\u5b58\u3059\u308c\u3070\u3001\u591a\u5c11\u30e9\u30b0\u304c\u3067\u307e\u3059\u304c\u3001\u305d\u306e\u6642\u9593\u306b\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u3078\u6295\u7a3f\u3055\u308c\u307e\u3059\u3002 
\"\"<\/figure> \u30b5\u30f3\u30d7\u30eb<\/span> <\/p>\n\n\n\n
function sendMessageTest() {\n  var client = ChatworkClient.factory({\n    token: '\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u30c8\u30fc\u30af\u30f3'\n  });\n  client.sendMessage({\n    room_id: \u9001\u308a\u305f\u3044\u30eb\u30fc\u30e0ID,\n    body: '[To:77777777]n\u30c6\u30b9\u30c8\u3067\u3059\u3002nn\u30c7\u30fc\u30bf\u306e\u30d1\u30b9\u3067\u3059\u3002n[info]C:\\Users\\\u30e6\u30fc\u30b6\u30fc\u540d\\Desktop\\[\/info]'\n  });\n}<\/code><\/pre><\/div>\n\n\n
\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tQiita<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tGoogle Apps Script\u304b\u3089ChatWork API\u3092\u4f7f\u3063\u3066\u6295\u7a3f\u3059\u308b – Qiita<\/a>\n\t\t\t\t\t\tGoogle Apps Script\u7528\u306eChatWork Client\u3092\u4e2d\u306e\u4eba\u304c\u4f5c\u3089\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u7528\u610f\u3055\u308c\u305fAPI\u3092\u53e9\u304f\u3060\u3051\u3067\u7c21\u5358\u306b\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002 \u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI \u3092 Google Apps Script \u3067…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n
Chatwork<\/span>\u3067\u6307\u5b9a\u6642\u9593\u306b\u6642\u523b\u3092\u304a\u77e5\u3089\u305b\u6295\u7a3f\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n
Chatwork+gas(Google Apps Script)\u3067\u300c\u6bce\u65e5\u6307\u5b9a\u6642\u523b\u306b\u6295\u7a3f + \u6295\u7a3f\u5185\u5bb9\u306f\u6307\u5b9a\u6642\u523b\u3092\u8a18\u8ff0\u300d\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
\"\"
<\/p>\n\n\n\n
\u7406\u7531\u3068\u3057\u3066\u306f\u3001\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u304c\u6d41\u308c\u304c\u3061\u306a\u306e\u3067\u3001\u65e5\u306b\u3061\u3054\u3068\u306b\u533a\u5207\u308a\u3092\u5165\u308c\u305f\u304b\u3063\u305f\u3060\u3051\u3067\u3059\u3002<\/p>\n\n\n\n
\u6307\u5b9a\u6642\u9593\u306b\u6642\u523b\u3092\u6295\u7a3f\u3059\u308b\u30b3\u30fc\u30c9<\/h3>\n\n\n\n
function sendMessageMyroom() {\n  var client = ChatworkClient.factory({token: '\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u30c8\u30fc\u30af\u30f3'});\n  var todayDate = new Date();\n  var todayDay = Utilities.formatDate( todayDate, 'Asia\/Tokyo', 'yyyy\u5e74M\u6708d\u65e5 h\u6642m\u5206');\n  client.sendMessage({room_id: '\u9001\u308a\u305f\u3044\u30eb\u30fc\u30e0ID', body: '[hr]'+todayDay+'\u306b\u306a\u308a\u307e\u3057\u305f\uff01'});\n}\n\n\/\/ \u305d\u306e\u65e5\u306e10\u664214\u5206\u306b\u30c8\u30ea\u30ac\u30fc\u3092\u8a2d\u5b9a\nfunction setTrigger() {\n  var triggerDay = new Date();\n  triggerDay.setHours(10);\n  triggerDay.setMinutes(14);\n  ScriptApp.newTrigger("main").timeBased().at(triggerDay).create();\n}\n\n\/\/ \u305d\u306e\u65e5\u306e\u30c8\u30ea\u30ac\u30fc\u3092\u524a\u9664\u3059\u308b\u95a2\u6570\nfunction deleteTrigger() {\n  var triggers = ScriptApp.getProjectTriggers();\n  for(var i=0; i < triggers.length; i++) {\n    if (triggers[i].getHandlerFunction() == "main") {\n      ScriptApp.deleteTrigger(triggers[i]);\n    }\n  }\n}\n\n\/\/ \u5b9f\u884c\u3057\u305f\u3044\u30b9\u30af\u30ea\u30d7\u30c8\u672c\u4f53\nfunction main() {\n  deleteTrigger();\n  sendMessageMyroom();\n}\n<\/code><\/pre><\/div>\n\n\n\n
\u3000\u307e\u3068\u3081\u308b\u3068\u300c\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u30c8\u30fc\u30af\u30f3\u300d\u3068\u300c\u9001\u308a\u305f\u3044\u30eb\u30fc\u30e0ID\u300d\u306e2\u7b87\u6240\u3092\u5165\u529b<\/p>\n\n\n\n
Utilities.formatDate( todayDate, 'Asia\/Tokyo', 'yyyy\u5e74M\u6708d\u65e5 h\u6642m\u5206');<\/code>\u3067\u6295\u7a3f\u6642\u523b\u3092\u53d6\u5f97<\/p><\/p>\n\n\n\n
\u3042\u3068\u306fsetTrigger()\u3092\u65e5\u6642\u6307\u5b9a\u306e\u30c8\u30ea\u30ac\u30fc\u306b\u767b\u9332\u3059\u308c\u3070OK<\/span><\/p>\n\n\n\n
Chatwork\u3067GAS\u3067\u753b\u50cf\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6295\u7a3f\u3092\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n
GAS\u3067\u753b\u50cf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059\u3002\u30b3\u30fc\u30c9\u306f\u4e0b\u8a18\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
function test(message) {\n   var token = "API\u30c8\u30fc\u30af\u30f3"\n   var roomID = "\u30eb\u30fc\u30e0ID";\n   var filename = "sample.png";\n   var file = DriveApp.getFilesByName(filename).next();\/\/\u30c9\u30e9\u30a4\u30d6\u5185\u306e\u540c\u4e00\u540d\u306e\u30d5\u30a1\u30a4\u30eb  \n   var params = {\n     headers : {"X-ChatworkToken" : token},\n     method : "post",\n     payload: {'file':Utilities.newBlob(file.getBlob().getBytes(), 'image\/png', "sample.png") },\n     muteHttpExceptions : true,\n   };  \n   var url = "https:\/\/api.Chatwork.com\/v2\/rooms\/" + roomID + "\/files";  \n   UrlFetchApp.fetch(url, params);\n }<\/code><\/pre><\/div>\n\n\n\n
\u7d50\u679c\u3067\u3059\u3002<\/p>\n\n\n\n
\"\"<\/p>\n\n\n\n
\u203b\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u304b\u3089GAS\u306b\u5909\u63db\u3059\u308b\u306e\u5730\u5473\u306b\u6642\u9593\u304b\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n
\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tChatwork API\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tChatwork API\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a>\n\t\t\t\t\t\t\u30af\u30e9\u30a6\u30c9\u578b\u30d3\u30b8\u30cd\u30b9\u30c1\u30e3\u30c3\u30c8\u30c4\u30fc\u30eb\u300cChatwork\u300d\u306b\u304a\u3051\u308b\u958b\u767a\u8005\u5411\u3051API\u306e\u4ed5\u69d8\u8a73\u7d30\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n
Chatwork<\/span>\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u4e88\u7d04\u6295\u7a3f+\u753b\u50cf\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n
\u5358\u767a\u3067\u3053\u306e\u6642\u671f\u306b\u6295\u7a3f\u3057\u305f\u3044\uff01\u3068\u6c7a\u307e\u3063\u3066\u3044\u308b\u3053\u3068\u306e\u4e88\u7d04\u6295\u7a3f\u306b\u4f7f\u3048\u305d\u3046\u3067\u3059\u3002<\/p>\n\n\n\n
\u4e0b\u8a18\u306e\u8a18\u4e8b\u306e\u30b3\u30fc\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n
\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\u30b3\u30f3\u30b5\u30eb\u30de\u30de\u3068\u30ce\u30de\u30c9\u30d1\u30d1<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tGAS\u3067\u3064\u304f\u308bChatwork\u4e88\u7d04\u6295\u7a3f\uff08\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u6295\u7a3f\uff09\u6a5f\u80fd<\/a>\n\t\t\t\t\t\tGAS\u3092\u4f7f\u3044\u3001Chatwork\uff08\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\uff09\u3067\u307b\u307c\u6642\u523b\u3069\u304a\u308a\u306b\u4e88\u7d04\u3057\u305f\u6295\u7a3f\u3092\u9001\u4fe1\u3067\u304d\u308b\u6a5f\u80fd\u3092\u3064\u304f\u308a\u307e\u3057\u305f\u3002 \u203b2019\/02\/10\u66f4\u65b0\u9001\u4fe1\u3057\u305f\u30e6\u30fc\u30b6\u306b\u3082\u901a\u77e5\u304c\u5c4a\u304f\u3088\u3046\u4fee\u6b63\u3057\u307e\u3057\u305f…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u6e96\u5099<\/h3>\n\n\n\n
\u65e5\u6642\u306e\u8a18\u8ff0\u306f<\/p>\n\n\n\n
2019\/07\/08 23:30:00<\/code><\/p>\n\n\n\n
\u307f\u305f\u3044\u306a\u611f\u3058\u3067\u3059\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u7121\u4e8b\u5b9f\u884c\u3055\u308c\u308b\u3068\u6295\u7a3f\u65e5\u6642\u306b\u6642\u523b\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
\u5931\u6557\u3059\u308b\u3068\u8a18\u8ff0\u304c\u6d88\u3048\u3066\u3057\u307e\u3046\u306e\u3067\u6ce8\u610f\u3002<\/p>\n\n\n\n
GAS\u306e\u8a18\u8ff0<\/h3>\n\n\n\n
\u57fa\u672c\u7684\u306b\u306f\u524d\u65e5\u306e\u753b\u50cf\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306e\u8a18\u8ff0\u3092\u8db3\u3057\u305f\u3060\u3051\u3067\u3059\u3002<\/p>\n\n\n\n
\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30c7\u30fc\u30bf\u304cGoogle\u30c9\u30e9\u30a4\u30d6\u306b\u4e8b\u524d\u306b\u5165\u308c\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n
\t\t\t
\n\t\t\t\t
\n\t\t\t\t\tQiita<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tContent-Type\u306e\u4e00\u89a7 – Qiita<\/a>\n\t\t\t\t\t\tContent-Type List \u81ea\u5206\u304c\u4f7f\u3044\u305d\u3046\u306a\u3068\u3053\u3060\u3051\u30d4\u30c3\u30af\u30a2\u30c3\u30d7 Content-Type Kind text\/plain \u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb text\/csv CSV\u30d5\u30a1\u30a4\u30eb text\/html HTML\u30d5\u30a1\u30a4\u30eb text\/css CSS…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n
\/*---- \u521d\u671f\u8a2d\u5b9a\u3053\u3053\u304b\u3089 ----*\/\n\n\/\/ \u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u30c8\u30fc\u30af\u30f3\u3092\u8a2d\u5b9a\nvar ChatworkToken = 'API\u30c8\u30fc\u30af\u30f3';\n\/\/ \u8a2d\u5b9a\u7528\u30b7\u30fc\u30c8\u306e\u30b7\u30fc\u30c8\u540d\nvar SHEETNAME = '\u30b7\u30fc\u30c81';\n\n\/*---- \u521d\u671f\u8a2d\u5b9a\u3053\u3053\u307e\u3067 ----*\/\n\n\/\/ \u7ba1\u7406\u7528\u30e1\u30cb\u30e5\u30fc\u3092\u8ffd\u52a0\nfunction onOpen() {\n  SpreadsheetApp.getUi()\n      .createMenu('\u7ba1\u7406\u7528')\n      .addItem('\u3044\u307e\u3059\u3050\u5b9f\u884c', 'myFunction')\n      .addToUi();\n}\n\n\/\/ \u4e88\u7d04\u6295\u7a3f\u306e\u30e1\u30a4\u30f3\u306e\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\nfunction myFunction(){\n  \/\/ \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u8aad\u8fbc->json\u53d6\u5f97\n  var sheet = getSheet();\n  var json = convertSheet2Json(sheet);\n  \/\/ \u30b7\u30fc\u30c8\u66f8\u304d\u51fa\u3057\u914d\u5217\u3092\u5b9a\u7fa9\n  var values = [];\n  \/\/ \u73fe\u5728\u306e\u65e5\u6642\u53d6\u5f97\n  var now = new Date();\n  var yesterday = new Date(now.getFullYear(), now.getMonth(), now.getDate() - 1);\n  \/\/ \u30b7\u30fc\u30c8\u3092\u30af\u30ea\u30a2\n  sheet.clearContents();\n  \n  \/\/ \uff11\u884c\u76ee\u306f\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u633f\u5165\n  values[0] = [ '\u65e5\u6642', '\u30eb\u30fc\u30e0ID', '\u30e1\u30c3\u30bb\u30fc\u30b8','\u30d5\u30a1\u30a4\u30eb\u30c7\u30fc\u30bf', '\u6295\u7a3f\u65e5\u6642'];\n  \/\/ json\u306e\u5185\u5bb9\u30922\u884c\u76ee\u4ee5\u964d\u306b\u8ffd\u52a0\n  for each(var obj in json){  \n    \/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u9001\u4fe1\n    if( obj.msg && obj.room_id && obj.sent_date == "" && obj.estimated_date > yesterday && obj.estimated_date < now ){\n      sendMessage( obj.room_id, obj.msg );\n      if(obj.file_date  !== ""){\n        uploadImage( obj.room_id, obj.file_date );\n      }  \n      obj.sent_date = now;\n    }\n    var line = [ obj.estimated_date, obj.room_id, obj.msg, obj.file_date, obj.sent_date];\n    values.push( line );\n  }\n  \/\/ \u30b7\u30fc\u30c8\u306b\u8cbc\u4ed8\u3051\n  sheet.getRange(1,1,values.length,values[0].length).setValues( values );\n}\n\nfunction getSheet(){\n  var book = SpreadsheetApp.getActiveSpreadsheet();\n  return book.getSheetByName(SHEETNAME);\n}\n\n\/\/ \u30b7\u30fc\u30c8\u3092\u8aad\u307f\u8fbc\u3093\u3067json\u5f62\u5f0f\u3067\u8fd4\u3059\nfunction convertSheet2Json(sheet) {\n  \/\/ \u30b7\u30fc\u30c8\u3092\u8aad\u307f\u8fbc\u3093\u3067\u4e8c\u6b21\u5143\u914d\u5217\u3092\u8fd4\u3059\n  var values = readSheet(sheet);\n  if( values == false ) return false;\n  \/\/ create json\n  var jsonArray = [];\n  for(var i=0; i<values.length; i++) {\n    var json = new Object();\n    json['estimated_date'] = values[i][0];\n    json['room_id'] = values[i][1];\n    json['msg'] = values[i][2];\n    json['file_date'] = values[i][3];\n    json['sent_date'] = values[i][4];\n    jsonArray.push(json);\n  }\n  return jsonArray;\n}\n\n\/\/ \u30b7\u30fc\u30c8\u3092\u8aad\u307f\u8fbc\u3093\u3067\u4e8c\u6b21\u5143\u914d\u5217\u3092\u8fd4\u3059\nfunction readSheet(sheet){\n  var lastRow = sheet.getLastRow();\n  if( lastRow <= 1 ) return false;\n  var rowIndex = 2;\n  var colStartIndex = 1;\n  var colNum = 5;\n  var range = sheet.getRange(rowIndex, colStartIndex, lastRow, colNum);\n  var values = range.getValues();\n  return values;\n}\n\n\/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u9001\u4fe1\nfunction sendMessage(room_id, strBody){\n  var params = {\n    headers : {"X-ChatworkToken" : ChatworkToken},\n      method : "post",\n      payload : {\n        body : strBody,\n        self_unread : "1"\n      }\n  };\n  var url = "https:\/\/api.Chatwork.com\/v2\/rooms\/" + room_id + "\/messages";\n  UrlFetchApp.fetch(url, params);\n}\n\n\/\/\u753b\u50cf\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\nfunction uploadImage(room_id, file_date) {\n   var boundary = 'boundary';\n   var type = file_date.split('.');\n   if (type[type.length - 1].toLowerCase() == 'jpeg') {var file_type ='image\/jpeg'}\n   if (type[type.length - 1].toLowerCase() == 'png') {var file_type ='image\/png'}\n   if (type[type.length - 1].toLowerCase() == 'gif') {var file_type ='image\/gif'}\n   if (type[type.length - 1].toLowerCase() == 'mp4') {var file_type ='audio\/mp4'}\n      \n   var file = DriveApp.getFilesByName(file_date).next();    \n   var params = {\n     headers : {"X-ChatworkToken" : ChatworkToken},\n     method : "post",\n     payload: {'file':Utilities.newBlob(file.getBlob().getBytes(), file_type, file_date) },\n     muteHttpExceptions : true,\n   };\n  \n   var url = "https:\/\/api.Chatwork.com\/v2\/rooms\/" + room_id + "\/files";  \n   UrlFetchApp.fetch(url, params);\n }<\/code><\/pre><\/div>\n\n\n\n
\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8a18\u5165\u3057\u305f\u3089\u30c8\u30ea\u30ac\u30fc\u306b10\u5206\u9593\u9694\u3067\u767b\u9332\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\uff01<\/p>\n\n\n\n
\u307e\u3068\u3081<\/h2>\n\n\n\n
\u672c\u8a18\u4e8b\u3067\u306f\u69d8\u3005\u306aGAS\u3092\u4f7f\u3063\u305fChatwork\u3078\u306e\u6295\u7a3f\u65b9\u6cd5\u3092\u66f8\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
\u4ed5\u4e8b\u3067\u4f7f\u3046\u3068\u304d\u306b\u3001\u304a\u77e5\u3089\u305b\u3068\u3057\u3066\u4f7f\u3046\u306e\u3082\u4fbf\u5229\u306a\u306e\u3067\u3001\u662f\u975e\u8a66\u3057\u3066\u307f\u3066\u4e0b\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Chatwork\u306b\u4e88\u7d04\u6295\u7a3f\u6a5f\u80fd\u306f\u307e\u3060\u3042\u308a\u307e\u305b\u3093\u3002 \u3067\u3059\u306e\u3067\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30afAPI\u3068GAS\uff08Google Apps Script\uff09\u3092\u4f7f\u3063\u3066\u306e\u4e88\u7d04\u6295\u7a3f\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002 Chatwork\u3067\u30c1\u30e3\u30c3\u30c8\u30ef\u30fc\u30af\u306b\u4e88\u7d04\u6295\u7a3f\u3059\u308b\u65b9\u6cd5 Go […]<\/p>\n","protected":false},"author":1,"featured_media":9883,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[24,20],"tags":[],"class_list":["post-169","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chatwork","category-work"],"_links":{"self":[{"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":0,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/media\/9883"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/work-tools\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}