{"id":102472,"date":"2021-02-26T16:42:40","date_gmt":"2021-02-26T07:42:40","guid":{"rendered":"https:\/\/support.questetra.com\/?p=102472"},"modified":"2023-08-22T11:14:16","modified_gmt":"2023-08-22T02:14:16","slug":"openweather-weather-history-get-by-time","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/openweather-weather-history-get-by-time\/","title":{"rendered":"OpenWeather #Weather_History: Get by Time"},"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\">OpenWeather: Weather History, Get by Time<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust.<\/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=\"far fa-pen-square fa-lg\"><\/i><\/span> A: Set API Key<span style=\"color:#990000;\"> *<\/span><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> B1: Set Unit System (Celsius: &#8220;metric&#8221;, Fahrenheit: &#8220;imperial&#8221;)<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> B2: Set Lang Code to translate description field (eg &#8220;ja&#8221; &#8220;es&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C: Set Datetime (of Workflow), Latitude and Longitude in 3 lines<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> E1: Select NUMERIC type Data that stores Temperature (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> E2: Select NUMERIC type Data that store Temperature of Perception (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> E3: Select NUMERIC type Data that stores Dew Point (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> F2: Select NUMERIC type Data that stores Humidity (%) (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> F3: Select NUMERIC type Data that stores Clouds (%) (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> G1: Select STRING type Data that stores Weather Group (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> G2: Select STRING type Data that stores Weather Condition (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> G3: Select STRING type Data that stores Weather Icon URL (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> H0: Select NUMERIC type Data that stores Wind Gust (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> H1: Select NUMERIC type Data that stores Wind Speed (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> H2: Select NUMERIC type Data that stores Wind Direction angle (0:N 90:E) (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> I0: Select NUMERIC type Data that stores Snow Volume for last hour (mm) (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> I1: Select NUMERIC type Data that stores Rain Volume for the last hour (mm) (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> I2: Select NUMERIC type Data that stores Pressure at sea level (update)<\/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>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strApiKey      = configs.get( &quot;StrConfA&quot; ); \/\/ required\n  if( strApiKey    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A API Key} is empty \\n&quot; );\n  }\nconst strUnitSystem  = configs.get( &quot;StrConfB1&quot; );\nconst strLangCode    = configs.get( &quot;StrConfB2&quot; );\nconst strTarget3     = configs.get( &quot;StrConfC&quot; ); \/\/ required\n  if( strTarget3   === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {C Date Latitude Longitude} is empty \\n&quot; );\n  }\n  const arrTarget3   = strTarget3.split(&quot;\\n&quot;);\n  if( arrTarget3.length &lt; 3 ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {C Date Latitude Longitude} Set in 3 lines \\n&quot; );\n  }\n  const strSpecifiedDate = arrTarget3[0].slice(0, 13); \/\/ eg &quot;2021-12-31 23&quot;\n  let  dateSpecified = toJsDate( strSpecifiedDate + &quot;:00&quot; ); \/\/ Specified DateTime (Platform)\n  const strLat       = arrTarget3[1];\n  const strLon       = arrTarget3[2];\nconst numPocketTemp      = configs.getObject( &quot;SelectConfE1&quot; );\nconst numPocketFeelTemp  = configs.getObject( &quot;SelectConfE2&quot; );\nconst numPocketDewPoint  = configs.getObject( &quot;SelectConfE3&quot; );\nconst numPocketHumidity  = configs.getObject( &quot;SelectConfF2&quot; );\nconst numPocketClouds    = configs.getObject( &quot;SelectConfF3&quot; );\nconst strPocketGroup     = configs.getObject( &quot;SelectConfG1&quot; );\nconst strPocketCondition = configs.getObject( &quot;SelectConfG2&quot; );\nconst strPocketIconUrl   = configs.getObject( &quot;SelectConfG3&quot; );\nconst numPocketWindGust  = configs.getObject( &quot;SelectConfH0&quot; );\nconst numPocketWindSpeed = configs.getObject( &quot;SelectConfH1&quot; );\nconst numPocketWindDeg   = configs.getObject( &quot;SelectConfH2&quot; );\nconst numPocketSnow      = configs.getObject( &quot;SelectConfI0&quot; );\nconst numPocketRain      = configs.getObject( &quot;SelectConfI1&quot; );\nconst numPocketPressure  = configs.getObject( &quot;SelectConfI2&quot; );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ Get all essential weather data for a specific location\n\/\/\/ https:\/\/openweathermap.org\/api\/one-call-api#history\n\/\/ request1, prepare\nlet getUri1  = &quot;https:\/\/api.openweathermap.org\/data\/2.5\/onecall\/timemachine&quot;;\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1 = request1.queryParam( &quot;appid&quot;, strApiKey ); \n    request1 = request1.queryParam( &quot;lat&quot;, strLat ); \n    request1 = request1.queryParam( &quot;lon&quot;, strLon ); \n    request1 = request1.queryParam( &quot;dt&quot;, ( dateSpecified.getTime() \/1000 + &quot;&quot; ) );\n    if( strUnitSystem !== &quot;&quot; ){\n      request1 = request1.queryParam( &quot;units&quot;, strUnitSystem ); \n    }\n    if( strLangCode !== &quot;&quot; ){\n      request1 = request1.queryParam( &quot;lang&quot;, strLangCode ); \n    }\n\/\/ request1, try\nconst response1     = request1.get( getUri1 ); \/\/ HttpResponseWrapper\nengine.log( &quot; AutomatedTask ApiRequest1 Start: &quot; + getUri1 );\nconst response1Code = response1.getStatusCode() + &quot;&quot;;\nconst response1Body = response1.getResponseAsString() + &quot;&quot;;\nengine.log( &quot; AutomatedTask ApiResponse1 Status: &quot; + response1Code );\nif( response1Code !== &quot;200&quot;){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedResponseError: &quot; +\n                    response1Code + &quot;\\n&quot; + response1Body + &quot;\\n&quot; );\n}\n\/\/ response1, parse\n\/\/ engine.log( response1Body ); \/\/ debug\n\/* response sample\n{\n  lat: 37.25,\n  lon: 139.15,\n  timezone: &quot;Asia\/Tokyo&quot;,\n  timezone_offset: 32400,\n  current: { \u7565 },\n  hourly: [\n    {\n      dt: 1614038400,\n      temp: 2.78,\n      feels_like: 0.43,\n      pressure: 1016,\n      humidity: 80,\n      dew_point: -0.28,\n      clouds: 100,\n      wind_speed: 0.45,\n      wind_deg: 320,\n      wind_gust: 1.34,\n      weather: [\n        {\n          id: 601,\n          main: &quot;Snow&quot;,\n          description: &quot;\u96ea&quot;,\n          icon: &quot;13d&quot;\n        }\n      ],\n      snow: {\n        1h: 0.64\n      }\n    },\n*\/\nconst response1Obj = JSON.parse( response1Body );\nengine.log( &quot; AutomatedTask ApiResponse1 # of Array Hourly: &quot; + response1Obj.hourly.length );\nengine.log( &quot; AutomatedTask ApiResponse1 timezone: &quot; + response1Obj.timezone );\nengine.log( &quot; AutomatedTask ApiResponse1 offset: &quot; + (response1Obj.timezone_offset \/3600) );\nengine.log( &quot; AutomatedTask Workflow Platform offset: &quot; + (engine.getTimeZoneOffsetInMinutes() \/60) );\n\n\/\/\/ Find ID of the specified datetime\n\/\/ Time (recognized by Workflow Platform) == Time (Weather Location Timezone)\nlet numHourlyId = 0;\nengine.log( &quot;  Time to search: &quot; + dateSpecified.getTime() +\n                &quot; (&quot; + dateSpecified.toISOString() + &quot;)&quot;\n          );\nfor( let i = 0; i &lt; response1Obj.hourly.length; i++ ){ \/\/ must be sorted\n  let dateTmp = new Date( response1Obj.hourly[i].dt *1000 );\n  if( response1Obj.hourly[i].dt *1000 &gt; dateSpecified.getTime() ){\n    engine.log( &quot;    hourly[&quot; + i + &quot;].dt: &quot; + response1Obj.hourly[i].dt +\n                &quot; (&quot; + dateTmp.toISOString() + &quot;) is larger&quot;\n              );\n    break;\n  }else{\n    engine.log( &quot;    hourly[&quot; + i + &quot;].dt: &quot; + response1Obj.hourly[i].dt +\n                &quot; (&quot; + dateTmp.toISOString() + &quot;)&quot;\n              );\n    numHourlyId = i;\n  }\n}\n\n\/\/\/ Extract weather info with Date-ID\nlet numTemp        = response1Obj.hourly[numHourlyId].temp;\nlet numFeelTemp    = response1Obj.hourly[numHourlyId].feels_like;\nlet numDewPoint    = response1Obj.hourly[numHourlyId].dew_point;\nlet numHumidity    = response1Obj.hourly[numHourlyId].humidity;\nlet numClouds      = response1Obj.hourly[numHourlyId].clouds;\nlet strGroup       = response1Obj.hourly[numHourlyId].weather[0].main;\nlet strCondition   = response1Obj.hourly[numHourlyId].weather[0].description;\nlet strIconUrl     = &quot;https:\/\/openweathermap.org\/img\/wn\/&quot; +\n                     response1Obj.hourly[numHourlyId].weather[0].icon + &quot;.png&quot;;\n                     \/\/ eg &quot;https:\/\/openweathermap.org\/img\/wn\/10d.png&quot;\nlet numWindGust    = response1Obj.hourly[numHourlyId].wind_speed; \/\/ Case where gusts do not blow\nif( response1Obj.hourly[numHourlyId].hasOwnProperty(&#39;wind_gust&#39;) ){\n    numWindGust    = response1Obj.hourly[numHourlyId].wind_gust;\n}\nlet numWindSpeed   = response1Obj.hourly[numHourlyId].wind_speed;\nlet numWindDeg     = response1Obj.hourly[numHourlyId].wind_deg;\nlet numSnow        = 0;\nif( response1Obj.hourly[numHourlyId].hasOwnProperty(&#39;snow&#39;) ){\n    numSnow        = response1Obj.hourly[numHourlyId].snow[&#39;1h&#39;];\n}\nlet numRain        = 0;\nif( response1Obj.hourly[numHourlyId].hasOwnProperty(&#39;rain&#39;) ){\n    numRain        = response1Obj.hourly[numHourlyId].rain[&#39;1h&#39;];\n}\n\/\/ The period operator format is not available \n\/\/ if the first character of the property name begins with a number\n\/\/ or if the property name contains a hyphen.\nlet numPressure    = response1Obj.hourly[numHourlyId].pressure;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( numPocketTemp   !== null ){\n  engine.setData( numPocketTemp,      new java.math.BigDecimal( numTemp ) );\n}\nif( numPocketFeelTemp  !== null ){\n  engine.setData( numPocketFeelTemp,  new java.math.BigDecimal( numFeelTemp ) );\n}\nif( numPocketDewPoint  !== null ){\n  engine.setData( numPocketDewPoint,  new java.math.BigDecimal( numDewPoint ) );\n}\nif( numPocketHumidity  !== null ){\n  engine.setData( numPocketHumidity,  new java.math.BigDecimal( numHumidity ) );\n}\nif( numPocketClouds    !== null ){\n  engine.setData( numPocketClouds,    new java.math.BigDecimal( numClouds ) );\n}\nif( strPocketGroup     !== null ){\n  engine.setData( strPocketGroup,     strGroup );\n}\nif( strPocketCondition !== null ){\n  engine.setData( strPocketCondition, strCondition );\n}\nif( strPocketIconUrl !== null ){\n  engine.setData( strPocketIconUrl,   strIconUrl );\n}\nif( numPocketWindGust  !== null ){\n  engine.setData( numPocketWindGust,  new java.math.BigDecimal( numWindGust ) );\n}\nif( numPocketWindSpeed !== null ){\n  engine.setData( numPocketWindSpeed, new java.math.BigDecimal( numWindSpeed ) );\n}\nif( numPocketWindDeg   !== null ){\n  engine.setData( numPocketWindDeg,   new java.math.BigDecimal( numWindDeg ) );\n}\nif( numPocketSnow      !== null ){\n  engine.setData( numPocketSnow,      new java.math.BigDecimal( numSnow ) );\n}\nif( numPocketRain      !== null ){\n  engine.setData( numPocketRain,      new java.math.BigDecimal( numRain ) );\n}\nif( numPocketPressure  !== null ){\n  engine.setData( numPocketPressure,  new java.math.BigDecimal( numPressure ) );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n  \/\/ BPMS Date:     &quot;2020-04-01&quot;  (subtype &quot;Y\/M&quot; &quot;M\/D&quot; &quot;Y&quot;, not supported)\n  \/\/ BPMS Datetime: &quot;2020-04-01 23:59&quot;\n  let year       = 0;\n  let monthIndex = 0;\n  let day        = 0;\n  let hours      = 0;\n  let minutes    = 0;\n\n  \/\/  The ECMA\/JavaScript Date object has a large number of methods.\n  \/\/ &quot;Date.parse&quot; is danger (strongly discouraged)\n  \/\/ - new Date(&quot;2014-11-10&quot;) \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n  \/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\n  let arrDatetime = bpmsDateOrDatetimeStr.split(&quot; &quot;);\n  if( arrDatetime.length === 1 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n  }\n  if( arrDatetime.length === 2 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    let arrTimeParts = arrDatetime[1].split(&quot;:&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n    hours      = parseInt(arrTimeParts[0], 10);\n    minutes    = parseInt(arrTimeParts[1], 10);\n  }\n  return new Date( year, monthIndex, day, hours, minutes );\n}\n\n\n\n\/*\nNotes:\n- For snow removal (snowfall), forecasting of vegetable prices (temperature and cloud in production), etc.\n- Weather data in OpenWeatherMap is calculated mechanically based on public info or airport observations.\n    - There is a difference from the weather data provided by the weather company.\n- The acquired forecast data and historical data can be freely used under the Open Database License.\n    - https:\/\/openweathermap.org\/full-price#licenses\n\n- Datetime up to 5 days ago\n    - If a date and time outside the range is specified, an error will occur.\n    - Specify with a string starting with &quot;YYYY-MM-DD HH&quot;. (Date type + static HH is also acceptable)\n\nNotes-ja:\n- \u6c17\u8c61\u5c65\u6b74\u30c7\u30fc\u30bf\u306f\u3001\u9664\u6392\u96ea\u306e\u8a08\u753b\u696d\u52d9\uff08\u964d\u96ea\u91cf\uff09\u3084\u91ce\u83dc\u4fa1\u683c\u306e\u5909\u52d5\u4e88\u6e2c\uff08\u751f\u7523\u5730\u306e\u6c17\u6e29\u3068\u96f2\u91cf\uff09\u7b49\u3067\u6d3b\u7528\u3055\u308c\u307e\u3059\u3002\n- OpenWeatherMap \u306e\u6c17\u8c61\u30c7\u30fc\u30bf\u306f\u3001\u516c\u7684\u60c5\u5831\u3084\u7a7a\u6e2f\u89b3\u6e2c\u5024\u306a\u3069\u3092\u5143\u306b\u6a5f\u68b0\u7684\u306b\u7b97\u51fa\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n    - \u6c17\u8c61\u4f1a\u793e\u306b\u3088\u308b\u6c17\u8c61\u30c7\u30fc\u30bf\u3068\u306f\u3001\u9055\u3044\u304c\u3042\u308a\u307e\u3059\u3002\n- \u53d6\u5f97\u3057\u305f\u4e88\u5831\u30c7\u30fc\u30bf\u3084\u5c65\u6b74\u30c7\u30fc\u30bf\u306f\u3001Open Database License \u4e0b\u3067\u81ea\u7531\u306b\u5229\u7528\u3067\u304d\u307e\u3059\u3002\n    - https:\/\/openweathermap.org\/full-price#licenses\n- 5\u65e5\u524d\uff08\u4e16\u754c\u6a19\u6e96\u6642\u63db\u7b97\uff09\u307e\u3067\u306e\u65e5\u6642\u304c\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002\n    - \u7bc4\u56f2\u5916\u306e\u65e5\u6642\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n    - &quot;YYYY-MM-DD HH&quot; \u3067\u59cb\u307e\u308b\u6587\u5b57\u5217\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\uff08&quot;\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\uff0b\u56fa\u5b9a\u6642\u523b\u6587\u5b57\u5217&quot; \u3067\u3082\u69cb\u3044\u307e\u305b\u3093\uff09\n*\/\n\n\n\/*\nAPPENDIX\n- Create an API key on the &quot;API keys&quot; page of your personal account beforehand.\n    - https:\/\/home.openweathermap.org\/api_keys\n- In this Addon, the weather data is acquired via &quot;One Call API (Historical weather data)&quot;.\n    - Available in OpenWeather Free subscription.\n- Units of measurement in response\n    - (default): temperature in Kelvin and wind speed in meter\/sec\n    - &quot;metric&quot;: temperature in Celsius and wind speed in meter\/sec\n    - &quot;imperial&quot;: temperature in Fahrenheit and wind speed in miles\/hour\n- Translation samples of weather description field, corresponding language codes\n    - eg. &quot;broken clouds: muy nuboso&quot;, &quot;overcast clouds: nubes&quot;, &quot;light snow: nevada ligera&quot;\n    - https:\/\/openweathermap.org\/api\/one-call-api#multi\n    - https:\/\/openweathermap.org\/weather-conditions\n- Wind Direction degrees\n    - 0 to 11, 349 to 359: N\n    - 12 to 33: NNE\n    - 34 to 56: NE\n    - 57 to 78: ENE\n    - 79 to 101: E\n    - 102 to 123: ESE\n    - 124 to 146: SE\n    - 147 to 168: SSE\n    - 169 to 191: S\n    - 192 to 213: SSW\n    - 214 to 236: SW\n    - 237 to 258: WSW\n    - 259 to 281: W\n    - 282 to 303: WNW\n    - 304 to 326: NW\n    - 327 to 348: NNW\n- Latitude Longitude sample\n    - Metropolitan Government Building, Tokyo: 35.689472, 139.69175\n    - Kiyomizu-dera Temple, Kyoto: 34.994831, 135.785003\n    - Waikiki Beach, Hawaii: 21.275278, -157.825\n    - Oymyakon, Russia: 63.25, 143.15 (the coldest permanently inhabited settlement on Earth)\n    - Use Google Maps, Wikipedia, etc. to obtain the latitude and longitude of any point.\n        - https:\/\/www.google.co.jp\/maps\/\n\nAPPENDIX-ja\n- \u500b\u4eba\u30a2\u30ab\u30a6\u30f3\u30c8\u306e &quot;API keys&quot; \u30da\u30fc\u30b8\u306b\u3066\u3001\u3042\u3089\u304b\u3058\u3081 API Key \u3092\u751f\u6210\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n    - https:\/\/home.openweathermap.org\/api_keys\n- \u3053\u306eAddon\u306b\u304a\u3051\u308b\u6c17\u8c61\u30c7\u30fc\u30bf\u306f &quot;One Call API (Historical weather data)&quot; \u7d4c\u7531\u3067\u53d6\u5f97\u3055\u308c\u307e\u3059\u3002\n    - OpenWeather Free subscription\uff08\u7121\u6599\uff09\u3067\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002\n- \u30ec\u30b9\u30dd\u30f3\u30b9\u6570\u5024\u306e\u7269\u7406\u5358\u4f4d\u7cfb\n    - (\u30c7\u30d5\u30a9\u30eb\u30c8)\uff1a \u6c17\u6e29\u306f\u300c\u30b1\u30eb\u30d3\u30f3\uff08\u7d76\u5bfe\u6e29\u5ea6\uff09\u300d\u306b\u3066\u3001\u98a8\u901f\u306f\u300c\u30e1\u30fc\u30c8\u30eb\u6bce\u79d2\u300d\u306b\u3066\u8868\u793a\u3055\u308c\u307e\u3059\n    - &quot;metric&quot;\uff1a \u6c17\u6e29\u306f\u300c\u6442\u6c0f\u300d\u3001\u98a8\u901f\u306f\u300c\u30e1\u30fc\u30c8\u30eb\u6bce\u79d2\u300d\u306b\u3066\u8868\u793a\u3055\u308c\u307e\u3059\n    - &quot;imperial&quot;\uff1a \u6c17\u6e29\u306f\u300c\u83ef\u6c0f\u300d\u3001\u98a8\u901f\u306f\u300c\u30de\u30a4\u30eb\u6bce\u6642\u300d\u306b\u3066\u8868\u793a\u3055\u308c\u307e\u3059\n- \u5929\u6c17\u6982\u6cc1\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u7ffb\u8a33\u30b5\u30f3\u30d7\u30eb\u3001\u304a\u3088\u3073\u5bfe\u5fdc\u8a00\u8a9e\u30b3\u30fc\u30c9\n    - \u4f8b &quot;broken clouds: \u66c7\u308a\u304c\u3061&quot;\u3001&quot;overcast clouds: \u539a\u3044\u96f2&quot;\u3001&quot;light snow: \u5c0f\u96ea&quot;\n    - https:\/\/openweathermap.org\/api\/one-call-api#multi\n    - https:\/\/openweathermap.org\/weather-conditions\n- \u98a8\u5411\u3068\u89d2\u5ea6\n    - 0 to 11, 349 to 359: \u5317\u306e\u98a8\u3001\u5317\u98a8\n    - 12 to 33: \u5317\u5317\u6771\u306e\u98a8\n    - 34 to 56: \u5317\u6771\u306e\u98a8\n    - 57 to 78: \u6771\u5317\u6771\u306e\u98a8\n    - 79 to 101: \u6771\u306e\u98a8\n    - 102 to 123: \u6771\u5357\u6771\u306e\u98a8\n    - 124 to 146: \u5357\u6771\u306e\u98a8\n    - 147 to 168: \u5357\u5357\u6771\u306e\u98a8\n    - 169 to 191: \u5357\u306e\u98a8\n    - 192 to 213: \u5357\u5357\u897f\u306e\u98a8\n    - 214 to 236: \u5357\u897f\u306e\u98a8\n    - 237 to 258: \u897f\u5357\u897f\u306e\u98a8\n    - 259 to 281: \u897f\u306e\u98a8\n    - 282 to 303: \u897f\u5317\u897f\u306e\u98a8\n    - 304 to 326: \u5317\u897f\u306e\u98a8\n    - 327 to 348: \u5317\u5317\u897f\u306e\u98a8\n- \u7def\u5ea6\u7d4c\u5ea6\u30b5\u30f3\u30d7\u30eb\n    - \u6771\u4eac\u90fd\u5e81: 35.689472, 139.69175\n    - \u4eac\u90fd \u6e05\u6c34\u5bfa: 34.994831, 135.785003\n    - \u30cf\u30ef\u30a4 \u30ef\u30a4\u30ad\u30ad\u30d3\u30fc\u30c1: 21.275278, -157.825\n    - \u30ed\u30b7\u30a2 \u30aa\u30a4\u30df\u30e3\u30b3\u30f3: 63.25, 143.15 (\u4e16\u754c\u3067\u6700\u3082\u5bd2\u3044\u5b9a\u4f4f\u5730)\n    - \u4efb\u610f\u5730\u70b9\u306e\u7def\u5ea6\u7d4c\u5ea6\u306f Google \u30de\u30c3\u30d7\u3084 Wikipedia \u7b49\u3067\u53d6\u5f97\u3057\u3066\u304f\u3060\u3055\u3044\n        - https:\/\/www.google.co.jp\/maps\/\n*\/\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAD10lEQVRYR8WXT0wUZxjGf4NlK1ID\niFApJNpKE9mkVqASq2KilHjooYEETQnEtJrMYDwU\/4SjhkQFUy0HleVASWylxhhNeqgJQmwkJCSm\nC61Qi3ogERKluoshK4jCNN8sA7szs7MzTZud43zP+77PvH+e9xuJBD+S4\/htrEClEomdqBQisQ7I\nWLAPojKKxAAqt5G4jsxLJ77jE+hgDbM0AAqw3IlTYAbw4aGZr3hiZ2NPwIeCxLdAqsPARlgIlaMo\n+GLZxybQxkWg7l8GNpq1InPQypc1AR+dSHz5HwUPu1H5CYVqo08zAZdfXp5Xzv3gfcZCY074mjIR\nTSBc89Z4nmo+rKHh4wYKMgpYJi1DReXpy6e0DLXQPNhsb65SF9kTSwTC3f4oXsMdLz7OkY1HWJm8\n0hRoTp3j8sPL7Pt1nx2JEB7y9elYItDGd8A3dpa73tvFpZ2XyE3NjQmbfjNNo7+RpsEmO1ctyNQL\nQJiAEBl4Hm\/Oz287T523jiQpyTbNvU962fHzDjuM0IlMIVZhAj5qkPjBykKku+qDKlLeSiFnRQ5Z\ny7PitQijU6Ps6d7D3b\/vxsaq1KLwo56BduDrSLSo8bXya4gulxYSFTfyAkD0wnhonJuPb3Ks\/xhT\nr6esTL9HZr+eAT8ShZGoppImDm88THJSstO4JpyYjp7xHiq7Ks0kVAZQKNIzEIhYLJqjvi\/62Pru\nVsvg\/md+iq8Xm86ulF1h7\/q9Ue9FU5747QRnfj9jxAeRWaUTUI2nw1XDeDO8lgS6xrq0+S\/LLdPO\nQ29CnPSfRPbKrH1nrcmm\/a92Dtw5YPYlI8Uk0P1592IAo6VwWLi6kKLVRdrRyOQIN0ZvaCXzJHmi\n4PPqPK1\/tnKo75AtAVMJFK\/C6ZLTpHvSowxn52c5+8dZKtZVsCF9g6aCHSMdiFSX5pSS+XZmlE5M\nTE+g9CoaQcMTUQIfpiYUYKF69R\/Vk+ZJW7QV6RZyKxfIWqCZuRlujd1i4PkAg88G8ZX6yE7J1vDB\nV0FNkCzqL5ZTVBOaxlCPmJeaR8X7FVq6Rd3Fl94L3ONUyalFORYkBKnJ2cnFsgwFhuh81Gm3pKLG\nMKYQWXWhILV9zXYaP2kkPy1fy8DuX3a7G1eDEDmS4sgIm7M2c\/Wzq1oPVPdU0z\/R74aAQYqFqYNl\nFBlByPO5T89xYfhCvMVjRcywjATE4TrWvYkdsSlzE7W3a918uSYb1utYHDm8kAjoluwtBF4FePDi\ngTsCMS8kuhuXVzJ30YlzJdO9JfRS+v9kwuW1fCkTCfwx0Ukk9NcsssMS9nPqss3dwv8B0CZjMKwp\n6lsAAAAASUVORK5CYII=\n\" alt=\"\"\/><\/a><\/figure>\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\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1uSK8hpAPZX0ZRaH8s6Qlhr35s_Q2ZL51\/view?usp=drivesdk\" target=\"_blank\">OpenWeather-Weather-History-Get-by-Time.xml<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1tIiT_fOPDKiD7y7XI-RsGlhgJcvVhbvw\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1tIiT_fOPDKiD7y7XI-RsGlhgJcvVhbvw\/view?usp=sharing\">OpenWeather-Weather-History-Get-by-Time-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-02-25 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/openweather-weather-history-get-by-time\/\">https:\/\/support.questetra.com\/addons\/openweather-weather-history-get-by-time\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/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\">\n<li>Weather history data is used for planning snow removal (snowfall), forecasting of vegetable prices (temperature and cloud in production areas), etc.<\/li>\n\n\n\n<li>Weather data in OpenWeatherMap is calculated mechanically based on public information and airport observations.\n<ul class=\"wp-block-list\">\n<li>It differs from the weather data provided by meteorological companies.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The acquired forecast data and historical data can be freely used under the Open Database License.\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/openweathermap.org\/full-price#licenses\" rel=\"nofollow\">https:\/\/openweathermap.org\/full-price#licenses<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The date and time can be specified up to 5 days in advance (in World Standard Time).\n<ul class=\"wp-block-list\">\n<li>A date and time outside this range will cause an error.<\/li>\n\n\n\n<li>The string must begin with &#8220;YYYY-MM-DD HH&#8221; (Date type + static HH is also acceptable).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"102475\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/openweather-weather-history-get-by-time\/attachment\/openweather-weather-history-get-by-time-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" 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=\"OpenWeather-Weather-History-Get-by-Time-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Gets weather history for the specific time (corrected to zero minutes) from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also snow volume and wind gust can be obtained.\" class=\"wp-image-102475\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create an API key on the &#8220;API keys&#8221; page of your personal account beforehand.\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/home.openweathermap.org\/api_keys\" rel=\"nofollow\">https:\/\/home.openweathermap.org\/api_keys<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In this Addon the weather data is acquired via &#8220;One Call API (Historical weather data)&#8221;.\n<ul class=\"wp-block-list\">\n<li>Available in OpenWeather Free subscription.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Units of measurement in response\n<ul class=\"wp-block-list\">\n<li>(default): temperature in Kelvin and wind speed in meter\/sec<\/li>\n\n\n\n<li>&#8220;metric&#8221;: temperature in Celsius and wind speed in meter\/sec<\/li>\n\n\n\n<li>&#8220;imperial&#8221;: temperature in Fahrenheit and wind speed in miles\/hour<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Translation samples of weather description field, corresponding language codes\n<ul class=\"wp-block-list\">\n<li>eg. &#8220;broken clouds: muy nuboso&#8221;, &#8220;overcast clouds: nubes&#8221;, &#8220;light snow: nevada ligera&#8221;<\/li>\n\n\n\n<li><a href=\"https:\/\/openweathermap.org\/api\/one-call-api#multi\" rel=\"nofollow\">https:\/\/openweathermap.org\/api\/one-call-api#multi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/openweathermap.org\/weather-conditions\" rel=\"nofollow\">https:\/\/openweathermap.org\/weather-conditions<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Wind Direction degrees\n<ul class=\"wp-block-list\">\n<li>0 to 11, 349 to 359: N<\/li>\n\n\n\n<li>12 to 33: NNE<\/li>\n\n\n\n<li>34 to 56: NE<\/li>\n\n\n\n<li>57 to 78: ENE<\/li>\n\n\n\n<li>79 to 101: E<\/li>\n\n\n\n<li>102 to 123: ESE<\/li>\n\n\n\n<li>124 to 146: SE<\/li>\n\n\n\n<li>147 to 168: SSE<\/li>\n\n\n\n<li>169 to 191: S<\/li>\n\n\n\n<li>192 to 213: SSW<\/li>\n\n\n\n<li>214 to 236: SW<\/li>\n\n\n\n<li>237 to 258: WSW<\/li>\n\n\n\n<li>259 to 281: W<\/li>\n\n\n\n<li>282 to 303: WNW<\/li>\n\n\n\n<li>304 to 326: NW<\/li>\n\n\n\n<li>327 to 348: NNW<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Latitude and Longitude sample\n<ul class=\"wp-block-list\">\n<li>Metropolitan Government Building, Tokyo: 35.689472, 139.69175<\/li>\n\n\n\n<li>Kiyomizu-dera Temple, Kyoto: 34.994831, 135.785003<\/li>\n\n\n\n<li>Waikiki Beach, Hawaii: 21.275278, -157.825<\/li>\n\n\n\n<li>Oymyakon, Russia: 63.25, 143.15 (the coldest permanently inhabited settlement on Earth)<\/li>\n\n\n\n<li>Use Google Maps, Wikipedia, etc. to obtain the latitude and longitude of any point.\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.google.co.jp\/maps\/\" rel=\"nofollow\">https:\/\/www.google.co.jp\/maps\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"k71Pq2ICJl\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/openweather-weather-forecast-get-by-date\/\">OpenWeather #Weather_Forecast: Get by Date<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;OpenWeather #Weather_Forecast: Get by Date&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/openweather-weather-forecast-get-by-date\/embed\/#?secret=MXOLIdcZQP#?secret=k71Pq2ICJl\" data-secret=\"k71Pq2ICJl\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"iOJfknEp9a\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/openweather-weather-forecast-get-by-time\/\">OpenWeather #Weather_Forecast: Get by Time<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;OpenWeather #Weather_Forecast: Get by Time&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/openweather-weather-forecast-get-by-time\/embed\/#?secret=pCAY7pU5l7#?secret=iOJfknEp9a\" data-secret=\"iOJfknEp9a\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust.<\/p>\n","protected":false},"author":2,"featured_media":102473,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Gets weather history for the specific time (corrected to zero minutes) from OpenWeather with specifying latitude and longitude of the world. Not only temperature, humidity and wind speed, but also snow volume and wind gust can be obtained.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","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":[168],"tags":[382,366,378],"class_list":["post-102472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-date","tag-httpclient","tag-json-parse"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.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\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":0,"uagb_excerpt":"Gets weather history for the specific time from OpenWeather (corrected to zero minutes) with the specified latitude and longitude. Temperature, humidity and wind speed can be obtained as well as snow volume and wind gust.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-qEM","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":102481,"url":"https:\/\/support.questetra.com\/ja\/addons\/openweather-weather-history-get-by-time\/","url_meta":{"origin":102472,"position":0},"title":"OpenWeather #\u6c17\u8c61\u5c65\u6b74: \u6642\u523b\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","author":"IMAMURA, Genichi","date":"2021-02-26","format":false,"excerpt":"\u4efb\u610f\u6642\u523b\uff08\u6bce\u6642\u30bc\u30ed\u5206\u306b\u88dc\u6b63\uff09\u306e\u6c17\u8c61\u5c65\u6b74\u3092 OpenWeather \u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002\u4e16\u754c\u4e2d\u306e\u7def\u5ea6\u3068\u7d4c\u5ea6\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u6c17\u6e29\u3001\u6e7f\u5ea6\u3001\u98a8\u901f\u3060\u3051\u3067\u306a\u304f\u3001\u964d\u96ea\u91cf\u3084\u6700\u5927\u77ac\u9593\u98a8\u901f\u306a\u3069\u3082\u53d6\u5f97\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"OpenWeather: \u6c17\u8c61\u5c65\u6b74, \u6642\u523b\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-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\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-History-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102153,"url":"https:\/\/support.questetra.com\/ja\/addons\/openweather-weather-forecast-get-by-time\/","url_meta":{"origin":102472,"position":1},"title":"OpenWeather #\u6c17\u8c61\u4e88\u5831: \u6642\u523b\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","author":"IMAMURA, Genichi","date":"2021-02-19","format":false,"excerpt":"\u4efb\u610f\u6642\u523b\uff08\u6bce\u6642\u30bc\u30ed\u5206\u306b\u88dc\u6b63\uff09\u306e\u6c17\u8c61\u4e88\u5831\u3092 OpenWeather \u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002\u4e16\u754c\u4e2d\u306e\u7def\u5ea6\u3068\u7d4c\u5ea6\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u6c17\u6e29\u3001\u6e7f\u5ea6\u3001\u98a8\u901f\u3060\u3051\u3067\u306a\u304f\u3001\u4f53\u611f\u6e29\u5ea6\u3084\u8996\u7a0b\u8ddd\u96e2\uff08\u9727\u72b6\u614b\u306f1000m\u672a\u6e80\uff09\u306a\u3069\u3082\u53d6\u5f97\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"OpenWeather: \u6c17\u8c61\u4e88\u5831, \u6642\u523b\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Time-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\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Time-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":102472,"position":2},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":102074,"url":"https:\/\/support.questetra.com\/ja\/addons\/openweather-weather-forecast-get-by-date\/","url_meta":{"origin":102472,"position":3},"title":"OpenWeather #\u6c17\u8c61\u4e88\u5831: \u65e5\u4ed8\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","author":"IMAMURA, Genichi","date":"2021-02-18","format":false,"excerpt":"\u4efb\u610f\u65e5\u4ed8\u306e\u6c17\u8c61\u4e88\u5831\u3092 OpenWeather \u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002\u4e16\u754c\u4e2d\u306e\u7def\u5ea6\u3068\u7d4c\u5ea6\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u6c17\u6e29\u3001\u6e7f\u5ea6\u3001\u98a8\u901f\u3060\u3051\u3067\u306a\u304f\u3001\u65e5\u6ca1\u6642\u523b\u3084\u9732\u70b9\u6e29\u5ea6\u306a\u3069\u3082\u53d6\u5f97\u53ef\u80fd\u3067\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"OpenWeather: \u6c17\u8c61\u4e88\u5831, \u65e5\u4ed8\u3092\u6307\u5b9a\u3057\u3066\u53d6\u5f97","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Date-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\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/OpenWeather-Weather-Forecast-Get-by-Date-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":102472,"position":4},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":102472,"position":5},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-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\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=102472"}],"version-history":[{"count":13,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102472\/revisions"}],"predecessor-version":[{"id":149887,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/102472\/revisions\/149887"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102473"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=102472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=102472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=102472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}