Get Latest Current Readings Graph Data (300 most recent readings)

Overview

This can be used to get the 300 most recent readings of current readings graph data from compatible devices that are being managed with T&D WebStorage Service.

Request

URI

https://api.webstorage-service.com/v1/devices/latest-data

Access Restrictions:

Read-Only ID is also possible.

Compatible model series which can get data using this API:

TR-7wb/nw/wf Series and TR4 Series

TR-7wb/nw/wf series 、TR4 series

*We are planning to include Graph Data for Remote Units in the RTR-500 Series and Current Readings Graph Data for the TR-700W Series in future revisions.

Rate Limit

60 times per 60 seconds

We set this rate limit to allow for the retrieval of the most recent few minutes of recorded data when the auto-upload interval is set at one minute for around ten devices set to measure at the shortest possible recording interval of 1 second.<br/> Note that if the number of registered devices is more than 60, data cannot be received from all of them every minute without a loss of data. On the other hand, it is possible to issue the API every second to a maximum of 300 devices without data loss. This will take 5 minutes to complete one cycle during which each device set at a recording interval of 1 sec will record 5 minutes worth of readings or the maximum amount of 300 readings which can be received with this API. Therefore even with this rate limit it is still possible to get the latest 300 readings from up to 300 devices without any loss of data.

The rate limit itself is designed to avoid concentrated access during a short period of time and balance out the load. Please be aware of this before using.

Number of Stored Readings in Current Readings Graph by Device

Series NameUpper Limit for Number of Stored Readings in Current Readings Graph
TR4 Series“160,000” readings
TR-7wb/nw/wf Series“80,000” readings
RTR-500 Series (Remote Unit) (*)“1,500” readings
RTR-700W Series (*)“1,500” readings

(*)The current API is not designed to retrieve Current Readings Graph Data from RTR-500 Series (Remote Units) or RTR-700W Series. We are however planning to include compatibility for these in future revisions.

Request Header

Item NameValue
HTTP MethodPOST
X-HTTP-Method-OverrideGET
Hostapi.webstorage-service.com:443
Content-Typeapplication/json

Request Parameter

Parameter NameFormatRequiredDefault ValueDetails
api-keystring(45 characters)Yes---Already acquired API Key
login-idstring(8 characters)Yes---User ID Read-Only ID is also possible. (*1)
login-passstring(4-16 characters)Yes---The password for the above User ID.
remote-serialstring(8 characters)Yes---Device Serial Number of the device from which graph data will be extracted. Not possible to select more than one unit at a time.
typestring( json/csv )jsonThese are the formats in which graph data can be received. Select either json format or csv format.
temperature-unitstring(device/C/F)deviceThis can be used to specify the temperature units used when retrieving recorded data.
[device] : Values will be returned as per the units set in the device. (default)
[C] : Values will be returned in Celsius.
[F] : Values will be returned in Fahrenheit.

Request Example

Request Header

POST /v1/devices/latest-data HTTP/1.1
Host: api.webstorage-service.com:443
Content-Type: application/json
X-HTTP-Method-Override: GET

Request Body

{
"api-key":"73pfobnche8d1p6laqnemsbnpkght3bjv047oid6p2sg3",
"login-id":"tbzz9999",
"login-pass":"ppaasswwoorrdd",
"remote-serial":"52120001"
}

*In this example, 100 readings of current readings graph data are being retrieved in json format from TR-71wf[52120001].

Response

Response Header

Item NameValueDetails
HTTP status code(**)HTTP Status Code
Content-Typeapplication/json; charset=utf-8
text/csv; charset=utf-8
The format will be changed according to the specified format, either JSON or CSV. (Character code is UTF-8)
X-RateLimit-Limit(integer)Access Limit per unit of time
X-RateLimit-Reset(integer)Number of seconds per unit of time
X-RateLimit-Remaining(integer)Remaining number of accesses per unit of time

(**) If the HTTP status code is “200”, then the process has been completed successfully. If any other HTTP status code is returned, then an error has occurred and processing was not completed. As shown below, if an error does occur, JSON data with the error info included will be returned.

HTTP/1.1 400 Bad Request
Server: api.webstorage-service.com
Content-Type: application/json; charset=utf-8
X-RateLimit-Limit: 60
X-RateLimit-Reset: 60
X-RateLimit-Remaining: 57

{
	"error":{
		"code": error code,
		"message": "error details"
	}
}

Response Parameter (JSON format)

In the following, when an item name includes a period (.) as in “channel.name”, this indicates that the elements of the array are included in the item, in this case “channel”.

Item Name Format Required Details
serial string Yes Serial Number of Selected Device
model string Yes Model Name of Selected Device
time-diff number Yes Device Time Difference Info [in units of minutes] shown here. If it is a Remote Unit, then the time difference info will be that set in Base Unit to which it is registered.
std-bias number Yes Device Time Difference from Standard [in units of minutes] shown here. If it is a Remote Unit, then the time difference from standard info will be that set in Base Unit to which it is registered.
dst-bias number Yes Device Time Difference during Daylight Savings Time [in units of minutes] shown here. If it is a Remote Unit, then the time difference during daylight savings time info will be that set in Base Unit to which it is registered.
name string Yes Device Name of Selected Device
channel Array Measurement Channel Info shown here. If the device selected does not include sufficient data, it may result in an empty array.
  channel.name string Yes Channel Name
  channel.num number Yes Channel Number (0~)
  channel.unit string Yes Unit of Measurement for Channel(*1)
data Array If the number of data readings is "0”, then the array is blank.
  data.unixtime number Yes unixtime of graph data
  data.data-id number Yes data-id(*2) of graph data
  data.ch1 number Yes The value for ch1(*3) for the above unixtime.
  data.ch2 number The value for ch2(*3) for the above unixtime. This will not exist, if the device has no ch2 measurement.

(*1) When Celsius or Fahrenheit is specified in "temperature-unit" in Request Parameter, the specified unit will be used instead of the unit set in the device.
(*2) The data-id is an ID which starts at 1 and will continually increase until it is initialized. The continuity of data can be confirmed by looking at the continuity of this value. However, note that monitoring data for TR4 is always "data-id": 0.
(*3) This value will reflect the data value, or an error code if no valid data is available. Refer to the "Error Code List (Recorded Data)" below to see the error code list.

Response Example(JSON format)

*Please note that actual responses may not be in such clear understandable form as shown in the example below.

HTTP/1.1 200 OK
Server: api.webstorage-service.com
Content-Type: application/json; charset=utf-8
X-RateLimit-Limit: 60
X-RateLimit-Reset: 60
X-RateLimit-Remaining: 57

{
	"serial":"52140001",
	"model":"TR-72wf",
	"name":"outside window on east side",
	"channel":[
		{
			"name":"temp",
			"num":0,
			"unit":"C"
		},{
			"name":"humid",
			"num":1,
			"unit":"%"
		}],
	"data":[
		{
			"unixtime": 123456789,
			"ch1":23.5,
			"ch2":65
		},{
			"unixtime": 123456800,
			"ch1":25.5,
			"ch2":68
		}, ... ,{
			"unixtime": 123456999,
			"ch1":21.5,
			"ch2":60
		}
	]
}

Response Parameter (CSV format)

The following explains data formatting for when data is received in CSV format.<br/> This is the same format as when data is output in CSV format in T&D Graph.

Line 1 (Header row) Date/Time (Fixed value) Date/Time (Fixed value) No. 1 (Fixed value) No. 2 (fixed Value) (Increases or decreases depending on number of channels)
Line 2 (Header row) Time Difference:GMT**:**/Daylight Savings Time:on/off (*1) (Device Time Difference Settings) Serial Value for Date (Excel) (fixed value) Channel Name of channel 1 Channel Name of channel 2 (Increases or decreases depending on number of channels)
Line 3 (Header row) (fixed value of blank data) (fixed value of blank data) Ch 1 Unit of Measurement(*4) Ch 2 Unit of Measurement (*4)(Increases or decreases depending on number of channels)
Line 4 and after (data rows) Time at Measurement (*2) Serial value in Excel for Time at Measurement (*3) Ch 1 Measurement Reading(*5) Ch 2 Measurement Reading(*5) (Increases or decreases depending on number of channels)

(*1) Both the time difference info set in the device and the “On/Off” for the daylight savings time setting in the WebStorage management screen will be displayed here.
(*2) The time at measurement will be calculated using the time difference info of the device and the time adjustment, if any, for daylight savings time and will be displayed in the following format: "yyyy-mm-dd HH:mm:ss".
(*3) This is will be the date and time after adjustments carried out in (*2) and converted into a serial value for use in Excel.
(*4) When Celsius or Fahrenheit is specified in "temperature-unit" in Request Parameter, the specified unit will be used instead of the unit set in the device.
(*5) This value will reflect the data value, or an error code if no valid data is available. Refer to the "Error Code List (Recorded Data)" below to see the error code list.

Response Example (CSV format)

HTTP/1.1 200 OK
Server: api.webstorage-service.com
Content-Type: text/csv; charset=utf-8
X-RateLimit-Limit: 60
X-RateLimit-Reset: 60
X-RateLimit-Remaining: 57

"Date/Time","Date/Time","No.1"
"time difference:GMT+9:00/daylight savings time:off","date as serial value(Excel)","Temp&quot
"","","C"
"2016-12-14 15:46:14","42718.657106481","24.1"
"2016-12-14 15:46:24","42718.657222222","24.0"
"2016-12-14 15:46:34","42718.657337963","24.0"
"2016-12-14 15:46:44","42718.657453704","24.1"
"2016-12-14 15:46:54","42718.657569444","24.1"
"2016-12-14 15:47:04","42718.657685185","24.0"
"2016-12-14 15:47:14","42718.657800926","24.0"
"2016-12-14 15:47:24","42718.657916667","24.0"
"2016-12-14 15:47:34","42718.658032407","24.0"
"2016-12-14 15:47:44","42718.658148148","24.1"
"2016-12-14 15:47:54","42718.658263889","24.2"
"2016-12-14 15:48:04","42718.65837963","24.2"
.....

MENU