{"id":2408,"date":"2018-03-22T17:33:04","date_gmt":"2018-03-22T08:33:04","guid":{"rendered":"https:\/\/www.ecomott.co.jp\/tech_blog\/?p=2408"},"modified":"2018-09-13T09:36:36","modified_gmt":"2018-09-13T00:36:36","slug":"fastio%e3%81%a7%e7%8b%ac%e8%87%aaiot%e3%82%a2%e3%83%97%e3%83%aa%e3%82%92%e7%88%86%e9%80%9f%e9%96%8b%e7%99%ba%e3%81%99%e3%82%8b-%e7%ac%ac2%e5%9b%9e-fastio-api%e5%ae%9f%e8%a3%85%e7%b7%a8","status":"publish","type":"post","link":"https:\/\/test.ecomottblog.com\/?p=2408","title":{"rendered":"FASTIO\u3067\u72ec\u81eaIoT\u30a2\u30d7\u30ea\u3092\u7206\u901f\u958b\u767a\u3059\u308b \u2013 \u7b2c2\u56de FASTIO API\u5b9f\u88c5\u7de8"},"content":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3002<br \/>\n\u88fd\u54c1\u958b\u767a\u90e8\u306e\u4e09\u6d66\u3067\u3059\u3002<\/p>\n<p>FASTIO\u3092\u4f7f\u3063\u3066IoT\u30a2\u30d7\u30ea\u3092\u7206\u901f\u958b\u767a\u3059\u308b\u7b2c2\u56de<br \/>\n\u4eca\u56de\u306f\u5b9f\u969b\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304d\u3001\u5b9f\u969b\u306b\u52d5\u304f\u3068\u3053\u308d\u307e\u3067\u3084\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ecomottblog.com\/?p=2281\">\u524d\u56de > FASTIO\u3067\u72ec\u81eaIoT\u30a2\u30d7\u30ea\u3092\u7206\u901f\u958b\u767a\u3059\u308b \u2013 \u7b2c1\u56de \u69cb\u6210\u7de8<\/a><br \/>\n<!--more--><\/p>\n<h2>\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9\u3092\u958b\u767a\u3059\u308b\u3002<\/h2>\n<p><a href=\"https:\/\/www.ecomottblog.com\/?p=2281\">\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u89e6\u308c\u305f\u3068\u304a\u308a\u3001<br \/>\n\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u306fFASTIO\u306b\u4efb\u305b\u3066\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9(\u753b\u9762\u8868\u793a\u306b\u95a2\u308f\u308b\u90e8\u5206)\u306e\u307f\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n<p>\u5b9f\u88c5\u90e8\u5206\u306f\u5927\u96d1\u628a\u306b3\u3064<\/p>\n<ul>\n<li>\u8a08\u6e2c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97<br \/>\n> FASTIO API<\/li>\n<li>\u753b\u9762\u306e\u8868\u793a\u30c7\u30b6\u30a4\u30f3<\/li>\n<li>\u753b\u9762\u306b\u53cd\u6620\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0<\/li>\n<\/ul>\n<p>\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9\u306f\u30e6\u30fc\u30b6\u304c\u898b\u308b\u6240\u306a\u306e\u3067\u3001\u308f\u304b\u308a\u3084\u3059\u304f\u3057\u305f\u3044\u3068\u3053\u308d\u3002<br \/>\n\u66f4\u306b\u3053\u3093\u306a\u8981\u671b\u3082\u51fa\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li>\u30b5\u30fc\u30d0\u30ec\u30b9\u3067<\/li>\n<li>BI\u30c4\u30fc\u30eb\u306e\u3088\u3046\u306b\u89e3\u6790\u3067\u304d<\/li>\n<li>\u666e\u901a\u306e\u4eba\u3082\u7c21\u5358\u306b\u7de8\u96c6\u3067\u304d\u3066<\/li>\n<li>PC\/\u30b9\u30de\u30db\u5bfe\u5fdc<\/li>\n<\/ul>\n<p>\u306f\u3058\u3081\u306fHTML5\u3068PHP\u3067Web\u30a2\u30d7\u30ea\u306b\u3057\u3088\u3046\u3068\u8003\u3048\u307e\u3057\u305f\u304c<br \/>\n&#8220;\u666e\u901a\u306e\u4eba&#8221;\u304c\u7de8\u96c6\u51fa\u6765\u306a\u3044\u305f\u3081<br \/>\n<a href=\"https:\/\/www.google.com\/intl\/ja_jp\/sheets\/about\/\">Google SpreadSheet<\/a>\u3068<a href=\"https:\/\/developers.google.com\/apps-script\/\">Google Apps Script<\/a>\u3092\u4f7f\u3046\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>Google SpreadSheet\u306a\u3089\u30b5\u30fc\u30d0\u3092\u7528\u610f\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u305b\u3093\u3057\u3001<br \/>\nExcel\u30e9\u30a4\u30af\u306b\u975e\u6280\u8853\u8005\u3067\u3082\u7de8\u96c6\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u5b9f\u88c5\u958b\u59cb\uff01<\/h2>\n<p>\u305d\u308c\u3067\u306f\u5b9f\u88c5\u3092\u59cb\u3081\u307e\u3057\u3087\u3046\uff01<\/p>\n<p>FASTIO API\u306f\u901a\u5e38\u306eWeb API\u306a\u306e\u3067<br \/>\n\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u306b\u3064\u306a\u304c\u308b\u74b0\u5883\u306a\u3089\u5927\u4f53\u52d5\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ecomottblog.com\/?p=103\">\u3053\u3061\u3089\u3092\u53c2\u8003<\/a>\u306b\u30b5\u30af\u30c3\u3068\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<pre><code>\/**\n * FASTIO API\u64cd\u4f5c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n *\/\nFastioApi = {\n  \/**\n   * \u30d7\u30ed\u30d1\u30c6\u30a3\n   *\/\n  __token: \"accress_token\", \/\/ FASTIO API\u30c8\u30fc\u30af\u30f3\uff08loadToken\u95a2\u6570\u3067\u66f4\u65b0\uff09\n\n  \/**\n   * \u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u751f\u6210\n   *\/\n  loadToken: function(user_id,user_pw, fastio_client_id){\n\n    \/\/ WebAPI\u30ea\u30af\u30a8\u30b9\u30c8\u30c7\u30fc\u30bf\n    var url = 'https:\/\/hogepiyo.fastio.jp\/oauth2\/token'; \/\/ FASTIO API \u30c8\u30fc\u30af\u30f3\u767a\u884cURL\u3067\u3059\u3002\u203b\u30b5\u30f3\u30d7\u30eb\u306f\u30c0\u30df\u30fc\u3067\u3059\n    var body = {\n      'username'   : user_id,         \/\/ FASTIO\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e6\u30fc\u30b6\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\n      'password'   : user_pw,         \/\/ FASTIO\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\n      'grant_type' : 'password',\n      'scope'      : 'api',\n      'client_id'  : fastio_client_id \/\/ FASTIO\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u3092\u8a2d\u5b9a\u3057\u307e\u3059\n    };\n    var options = {\n      \"method\"     : \"POST\",\n      \"contentType\": \"application\/json\",\n      \"payload\"    : JSON.stringify(body)\n    };\n\n    \/\/ WebAPI\u30ea\u30af\u30a8\u30b9\u30c8\u5b9f\u884c\n    var response = UrlFetchApp.fetch(url, options);\n\n    \/\/ \u8fd4\u308a\u5024\u53d6\u5f97\n    var resJson = JSON.parse(response.getContentText());\n    FastioApi.__token = resJson[\"access_token\"]; \/\/ \u30c8\u30fc\u30af\u30f3\u3092\u66f4\u65b0\n  },\n\n  \/**\n   * \u8a08\u6e2c\u30c7\u30fc\u30bf\u53d6\u5f97\n   *\/\n  getData: function(term_id,no, sdt, edt){\n\n    \/\/ \u65e5\u6642\u3092Format (yyyyMMddhhmmss\u5f62\u5f0f)\n    sdt_str = sdt.getFullYear() + \"\" +\n      ('0' + (sdt.getMonth() + 1)).slice(-2) +\n      ('0' + sdt.getDate()       ).slice(-2) +\n      ('0' + sdt.getHours()      ).slice(-2) +\n      ('0' + sdt.getMinutes()    ).slice(-2) +\n      ('0' + sdt.getSeconds()    ).slice(-2);\n    edt_str = edt.getFullYear() + \"\" +\n      ('0' + (edt.getMonth() + 1)).slice(-2) +\n      ('0' + edt.getDate()       ).slice(-2) +\n      ('0' + edt.getHours()      ).slice(-2) +\n      ('0' + edt.getMinutes()    ).slice(-2) +\n      ('0' + edt.getSeconds()    ).slice(-2);\n\n    \/\/ WebAPI\u30ea\u30af\u30a8\u30b9\u30c8\u30c7\u30fc\u30bf\n    var url = \"https:\/\/hogepiyo.fastio.jp\/logger\/data\/regular\"; \/\/ FASTIO API \u8a08\u6e2c\u30c7\u30fc\u30bf\u53d6\u5f97URL\u3067\u3059\u3002\u203b\u30b5\u30f3\u30d7\u30eb\u306f\u30c0\u30df\u30fc\u3067\u3059\n    var body = {\n      'access_token' : FastioApi.__token,\n      'term_id'      : term_id,\n      'no'           : nos,\n      'from'         : sdt_str,\n      'to'           : edt_str\n    };\n    var options = {\n      \"method\"       : \"POST\",\n      \"contentType\"  : \"application\/json\",\n      \"payload\"      : JSON.stringify(body)\n    };\n\n    \/\/ WebAPI\u30ea\u30af\u30a8\u30b9\u30c8\u5b9f\u884c\n    var response = UrlFetchApp.fetch(url, options);\n\n    \/\/ \u8fd4\u308a\u5024\u53d6\u5f97\n    var resJson = JSON.parse(response.getContentText());\n\n    \/\/ \u6700\u65b01\u4ef6\u306e\u307f\u3092\u8fd4\u3059\n    return [\n      resJson.attributes[0][\"name\"], \/\/ \u8a08\u6e2c\u30c7\u30fc\u30bf\u540d\n      resJson.attributes[0][\"unit\"], \/\/ \u8a08\u6e2c\u30c7\u30fc\u30bf\u306e\u5358\u4f4d\n      regData.data[no][i2][0],       \/\/ \u8a08\u6e2c\u65e5\u6642(\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7)\n      regData.data[no][i2][1]        \/\/ \u8a08\u6e2c\u30c7\u30fc\u30bf\n    ];\n  }\n};\n\n\/**\n * \u30e1\u30a4\u30f3\u306e\u5b9f\u884c\u95a2\u6570\n * Google Apps\u306e\u5b9a\u671f\u5b9f\u884c\u3067\u5b9f\u884c\u3059\u308b\n *\/\nfunction myFunction() {\n\n  \/\/ FASTIO API\u306e\u30a2\u30af\u30bb\u30b9\u60c5\u5831\n  var fastio_id = \"FASTIO\u306e\u30ed\u30b0\u30a4\u30f3ID\";\n  var fastio_pw = \"FASTIO\u306e\u30ed\u30b0\u30a4\u30f3PW\";\n  var fastio_client_id = \"FASTIO API\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\";\n\n  \/\/ \u53d6\u5f97\u3057\u305f\u3044\u7aef\u672bID\u30fb\u8a08\u6e2c\u5024no\n  var term_id = \"\u307b\u306b\u3083\u3089\u3089\u3089\";\n  var data_no = \"\u307b\u306b\u3083\u3089\u3089\u3089\";\n\n  \/\/ \u8a08\u6e2c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u65e5\u4ed8\n  var nDt = new Date();\n  var anHourAgoDt = new Date(nDt - (1000 * 60 * 15)); \/\/ 15\u5206\u524d\u306e\u30c7\u30fc\u30bf\u307e\u3067\u53d6\u5f97\u3057\u307e\u3059\u3002\n\n  \/\/ FASTIO API \u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u767a\u884c\n  var res = FastioApi.loadToken(fastio_id,fastio_pw,fastio_client_id);\n\n  \/\/ FASTIO API \u8a08\u6e2c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\n  var datas =  FastioApi.getData(term_id,data_no, anHourAgoDt, nDt);\n\n  \/\/ \u53d6\u5f97\u30c7\u30fc\u30bf\u3092\u30ed\u30ae\u30f3\u30b0\n  Logger.log( datas );\n}\n<\/code><\/pre>\n<p>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8&#8221;FastioApi&#8221;\u304cFASTIO API\u306e\u64cd\u4f5c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3002<br \/>\n\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\u3059\u308b\u95a2\u6570\u3068<br \/>\n\u8a08\u6e2c\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u95a2\u6570\u306b\u5206\u3051\u3066\u5b9f\u88c5\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u95a2\u6570&#8221;myFunction&#8221;\u3092\u5b9f\u884c\u3059\u308b\u3068<br \/>\nFASTIO API\u304b\u3089\u547c\u3073\u51fa\u3057\u305f\u8a08\u6e2c\u30c7\u30fc\u30bf\u304c<br \/>\nGoogle Apps Script\u306e\u30ed\u30b0\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u6b21\u56de\u306b\u7d9a\u304f<\/p>\n<h3>\u7528\u8a9e\u89e3\u8aac<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.fastio.jp\/fastio-api\/\">FASTIO API<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u306f\u3002 \u88fd\u54c1\u958b\u767a\u90e8\u306e\u4e09\u6d66\u3067\u3059\u3002 FASTIO\u3092\u4f7f\u3063\u3066IoT\u30a2\u30d7\u30ea\u3092\u7206\u901f\u958b\u767a\u3059\u308b\u7b2c2\u56de \u4eca\u56de\u306f\u5b9f\u969b\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304d\u3001\u5b9f\u969b\u306b\u52d5\u304f\u3068\u3053\u308d\u307e\u3067\u3084\u3063\u3066\u307f\u307e\u3059\u3002 \u524d\u56de > FASTIO\u3067\u72ec\u81eaIoT\u30a2\u30d7\u30ea\u3092\u7206\u901f\u958b\u767a\u3059\u308b \u2013 \u7b2c [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":2412,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[33,31],"_links":{"self":[{"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2408"}],"collection":[{"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2408"}],"version-history":[{"count":7,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2408\/revisions"}],"predecessor-version":[{"id":2421,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2408\/revisions\/2421"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/media\/2412"}],"wp:attachment":[{"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}