/
Raw Value Select

Raw Value Select

Owned by machlake (Unlicensed)
Last updated: Feb 21, 2023
15 min read
[ 1 HTTP Request ] [ 1.1 Parameters ] [ 2 Request Example ] [ 3 Response Example ] [ 4 Sample Code ]

This API is used to extract raw sensor data stored in the data lake with various options. For more detailed usage, refer to the Parameter section below.

HTTP Request

Parameters

Optional

Type

Description

Example

Optional

Type

Description

Example

type

string

select type

&type=raw

tag_name

string

tag name with , separator

&tag_name=tag1,tag2,tag3

start_time

string

start time of select (MUST be eralier than end_time)

type 1 : time string format

  • start_time=2018-01-16 14:40:05 000
    or

  • start_time=2018-01-16 14:40:05.000

type 2 : timestamp (second or millisecond)

  • start_time=1618813188
    or

  • start_time=1618813188123

&start_time=2018-01-16 14:40:05 000
or
&start_time=2018-01-16 14:40:05.000
or
&start_time=1618813188
or
&start_time=1618813188123

  • datetime in parameter is supported only up to millisecond

separator

string

separator for tag_name, columns, and_condition

&separator=| (default : ,)

and_condition

string

filtering condition (need escape sequence)

  • column name is wrapped in double quotes

&and_condition=”value” > 345,”name” = 'sjkim'

end_time

string

end time of select  (MUST be later than start_time)

  • same as start_time

same as start_time

date_format

string

date format of select time
or
timestamp type ("SECOND", "MILLISECOND", "MICROSECOND", "NANOSECOND")

&date_format=YYYY-MM-DD HH24:MI:SS
or
&date_format=MILLISECOND

(default : YYYY-MM-DD HH24:MI:SS)

offset

int

count of skip

&offset=500

limit

int

count of display

&limit=1000 (default : Restricted by 'lake tier' by lake tier)

columns

string

columns to filter out

&columns=value,value2 (default : value)
name, time is the default choice

aliases

string

columns to be aliased (Must be blank or equal to columns,)

&aliases=myvalue,myvalue2
Can not be use alias for name and time.

direction

int

ascend or descent by time

&direction=0 : ascend (default)
or
&direction=1 : descend

Request Example

Response Example

Sample Code

In this sample, try to show variety parameter combination, but can’t show all combination, but should find parameter option from using this sample

github

chcp 65001 :: Text Encoding to UTF-8 in CMD :: Example For Select Raw Data for tag API by using curl in window script :: written by yeony kim set API_KEY=YOUR_API_KEY set LAKE_ID=YOUR_LAKE_ID set CLOUD_VENDOR=YOUR_CLOUD_VENDOR set CLOUD_REGION=YOUR_CLOUD_REGION set CONTENT_HEADER="Content-Type: application/json" set API_HEADER="x-api-key: %API_KEY%" set URL="https://%CLOUD_VENDOR%.%CLOUD_REGION%.machlake.com/v1/lakes/%LAKE_ID%/values" set SELECT_TYPE=raw :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set TAG_NAME=sensor1 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-06 17:00:00 000:000:000 set END_TIME=2021-01-06 21:00:00 000:000:000 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor1","2021-01-06 17:00:00 001:000:000",1], :: ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 003:000:000",2], :: ["sensor1","2021-01-06 17:00:00 004:000:000",1], :: ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 006:000:000",2], :: ["sensor1","2021-01-06 17:00:00 007:000:000",1], :: ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 009:000:000",2], :: ["sensor1","2021-01-06 18:00:00 001:000:000",2], :: ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], :: ["sensor1","2021-01-06 18:00:00 003:000:000",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS set TAG_NAME=sensor1 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS set START_TIME=2021-01-06 17:00:00 set END_TIME=2021-01-06 21:00:00 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor1","2021-01-06 17:00:00",1], :: ["sensor1","2021-01-06 17:00:00",1.5], :: ["sensor1","2021-01-06 17:00:00",2], :: ["sensor1","2021-01-06 17:00:00",1], :: ["sensor1","2021-01-06 17:00:00",1.5], :: ["sensor1","2021-01-06 17:00:00",2], :: ["sensor1","2021-01-06 17:00:00",1], :: ["sensor1","2021-01-06 17:00:00",1.5], :: ["sensor1","2021-01-06 17:00:00",2], :: ["sensor1","2021-01-06 18:00:00",2], :: ["sensor1","2021-01-06 18:00:00",2.5], :: ["sensor1","2021-01-06 18:00:00",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS, data inserted with date skip mmm:uuu:nnn set TAG_NAME=sensor2 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-06 17:00:00 000:000:000 set END_TIME=2021-01-06 21:00:00 000:000:000 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor2","2021-01-06 17:00:00 000:000:000",1], :: ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], :: ["sensor2","2021-01-06 17:00:02 000:000:000",2], :: ["sensor2","2021-01-06 17:00:03 000:000:000",1], :: ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], :: ["sensor2","2021-01-06 17:00:05 000:000:000",2], :: ["sensor2","2021-01-06 18:00:00 001:000:000",2], :: ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], :: ["sensor2","2021-01-06 18:00:00 003:000:000",2], :: ["sensor2","2021-01-06 20:00:04 000:000:000",2], :: ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], :: ["sensor2","2021-01-06 20:00:06 000:000:000",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with UTC-0 timezone set TZ=Africa/Abidjan set TAG_NAME=sensor2 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-06 17:00:00 000:000:000 set END_TIME=2021-01-06 21:00:00 000:000:000 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "timezone=%TZ%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor2","2021-01-06 17:00:00 007:000:000",1], :: ["sensor2","2021-01-06 17:00:00 008:000:000",1.5], :: ["sensor2","2021-01-06 17:00:00 009:000:000",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with local timezone, data inserted UTC-0 timezone setting set TAG_NAME=sensor2 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-07 02:00:00 000:000:000 set END_TIME=2021-01-07 12:00:00 000:000:000 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor2","2021-01-07 02:00:00 007:000:000",1], :: ["sensor2","2021-01-07 02:00:00 008:000:000",1.5], :: ["sensor2","2021-01-07 02:00:00 009:000:000",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with limit and offset set TAG_NAME=sensor1,sensor2 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-06 17:00:00 000:000:000 set END_TIME=2021-01-06 21:00:00 000:000:000 set LIMIT=10 set OFFSET=5 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" \ --data-urlencode "limit=%LIMIT%" \ --data-urlencode "offset=%OFFSET%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor1","2021-01-06 17:00:00 006:000:000",2], :: ["sensor1","2021-01-06 17:00:00 007:000:000",1], :: ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 009:000:000",2], :: ["sensor1","2021-01-06 18:00:00 001:000:000",2], :: ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], :: ["sensor1","2021-01-06 18:00:00 003:000:000",2], :: ["sensor1","2021-01-06 20:00:04 000:000:000",2], :: ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], :: ["sensor1","2021-01-06 20:00:06 000:000:000",2] :: ] :: } :: } :: ------------------------------------------------------------------------------------------------- :: :: CASE - DATA GET with descent by time set TAG_NAME=sensor1,sensor2 set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn set START_TIME=2021-01-06 17:00:00 000:000:000 set END_TIME=2021-01-06 21:00:00 000:000:000 set DIRECTION=1 curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% \ --data-urlencode "type=%SELECT_TYPE%" \ --data-urlencode "tag_name=%TAG_NAME%" \ --data-urlencode "date_format=%DATE_FORMAT%" \ --data-urlencode "start_time=%START_TIME%" \ --data-urlencode "end_time=%END_TIME%" \ --data-urlencode "direction=%DIRECTION%" :: Return Format :: { :: "success":true, :: "reason":"success", :: "data":{ :: "columns":[ :: {"name":"NAME","type":5,"length":80}, :: {"name":"TIME","type":5,"length":4096}, :: {"name":"VALUE","type":20,"length":17} :: ], :: "rows":[ :: ["sensor2","2021-01-06 20:00:06 000:000:000",2], :: ["sensor1","2021-01-06 20:00:06 000:000:000",2], :: ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], :: ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], :: ["sensor2","2021-01-06 20:00:04 000:000:000",2], :: ["sensor1","2021-01-06 20:00:04 000:000:000",2], :: ["sensor2","2021-01-06 18:00:00 003:000:000",2], :: ["sensor1","2021-01-06 18:00:00 003:000:000",2], :: ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], :: ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], :: ["sensor2","2021-01-06 18:00:00 001:000:000",2], :: ["sensor1","2021-01-06 18:00:00 001:000:000",2], :: ["sensor2","2021-01-06 17:00:05 000:000:000",2], :: ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], :: ["sensor2","2021-01-06 17:00:03 000:000:000",1], :: ["sensor2","2021-01-06 17:00:02 000:000:000",2], :: ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 009:000:000",2], :: ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 007:000:000",1], :: ["sensor1","2021-01-06 17:00:00 006:000:000",2], :: ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 004:000:000",1], :: ["sensor1","2021-01-06 17:00:00 003:000:000",2], :: ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], :: ["sensor1","2021-01-06 17:00:00 001:000:000",1], :: ["sensor2","2021-01-06 17:00:00 000:000:000",1] :: ] :: } :: }

github

# Text Encoding to UTF-8 in CMD # Example For Select Raw Data for tag API by using curl in ubuntu LAKE_ID=$YOUR_LAKE_ID API_KEY=$YOUR_API_KEY CLOUD_VENDOR=$YOUR_CLOUD_VENDOR CLOUD_REGION=$YOUR_CLOUD_REGION CONTENT_HEADER=Content-Type:application/json API_HEADER=x-api-key:$API_KEY URL=https://${CLOUD_VENDOR}.${CLOUD_REGION}.machlake.com/v1/lakes/${LAKE_ID}/values SELECT_TYPE=raw # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn TAG_NAME=sensor1 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-06 17:00:00 000:000:000" END_TIME="2021-01-06 21:00:00 000:000:000" curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00 001:000:000",1], # ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 003:000:000",2], # ["sensor1","2021-01-06 17:00:00 004:000:000",1], # ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 003:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS TAG_NAME=sensor1 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS" START_TIME="2021-01-06 17:00:00" END_TIME="2021-01-06 21:00:00" curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 18:00:00",2], # ["sensor1","2021-01-06 18:00:00",2.5], # ["sensor1","2021-01-06 18:00:00",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS, data inserted with date skip mmm:uuu:nnn TAG_NAME=sensor2 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-06 17:00:00 000:000:000" END_TIME="2021-01-06 21:00:00 000:000:000" curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 17:00:00 000:000:000",1], # ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:02 000:000:000",2], # ["sensor2","2021-01-06 17:00:03 000:000:000",1], # ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:05 000:000:000",2], # ["sensor2","2021-01-06 18:00:00 001:000:000",2], # ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor2","2021-01-06 18:00:00 003:000:000",2], # ["sensor2","2021-01-06 20:00:04 000:000:000",2], # ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor2","2021-01-06 20:00:06 000:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with UTC-0 timezone TZ="Africa/Abidjan" TAG_NAME=sensor2 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-06 17:00:00 000:000:000" END_TIME="2021-01-06 21:00:00 000:000:000" curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "timezone=$TZ" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 17:00:00 007:000:000",1], # ["sensor2","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor2","2021-01-06 17:00:00 009:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with local timezone, data inserted UTC-0 timezone setting TAG_NAME=sensor2 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-07 02:00:00 000:000:000" END_TIME="2021-01-07 12:00:00 000:000:000" curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-07 02:00:00 007:000:000",1], # ["sensor2","2021-01-07 02:00:00 008:000:000",1.5], # ["sensor2","2021-01-07 02:00:00 009:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with limit and offset TAG_NAME=sensor1 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-06 17:00:00 000:000:000" END_TIME="2021-01-06 21:00:00 000:000:000" LIMIT=10 OFFSET=5 curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" \ --data-urlencode "limit=$LIMIT" \ --data-urlencode "offset=$OFFSET" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 003:000:000",2], # ["sensor1","2021-01-06 20:00:04 000:000:000",2], # ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor1","2021-01-06 20:00:06 000:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with descent by time TAG_NAME=sensor1,sensor2 DATE_FORMAT="YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn" START_TIME="2021-01-06 17:00:00 000:000:000" END_TIME="2021-01-06 21:00:00 000:000:000" DIRECTION=1 curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADER \ --data-urlencode "type=$SELECT_TYPE" \ --data-urlencode "tag_name=$TAG_NAME" \ --data-urlencode "date_format=$DATE_FORMAT" \ --data-urlencode "start_time=$START_TIME" \ --data-urlencode "end_time=$END_TIME" \ --data-urlencode "direction=$DIRECTION" # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 20:00:06 000:000:000",2], # ["sensor1","2021-01-06 20:00:06 000:000:000",2], # ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor2","2021-01-06 20:00:04 000:000:000",2], # ["sensor1","2021-01-06 20:00:04 000:000:000",2], # ["sensor2","2021-01-06 18:00:00 003:000:000",2], # ["sensor1","2021-01-06 18:00:00 003:000:000",2], # ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor2","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor2","2021-01-06 17:00:05 000:000:000",2], # ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:03 000:000:000",1], # ["sensor2","2021-01-06 17:00:02 000:000:000",2], # ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 004:000:000",1], # ["sensor1","2021-01-06 17:00:00 003:000:000",2], # ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 001:000:000",1], # ["sensor2","2021-01-06 17:00:00 000:000:000",1] # ] # } # }

github

// Example For Select Raw Data for tag API by using request in node js // process.env.NODE_TLS_REJECT_UNAUTHORIZED ="0"; const API_KEY ="YOUR_API_TOKEN"; const LAKE_ID ="YOUR_LAKE_ID"; const CLOUD_VENDOR="CLOUD_VENDOR"; const CLOUD_REGION="CLOUD_REGION"; const URL = `https://${CLOUD_VENDOR}.${CLOUD_REGION}.machlake.com/v1/lakes/${LAKE_ID}/values`; var request = require('request'); const SELECT_TYPE="raw"; /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor1", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-06 17:00:00 000:000:000", end_time: "2021-01-06 21:00:00 000:000:000" }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor1","2021-01-06 17:00:00 001:000:000",1], // ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 003:000:000",2], // ["sensor1","2021-01-06 17:00:00 004:000:000",1], // ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 006:000:000",2], // ["sensor1","2021-01-06 17:00:00 007:000:000",1], // ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 009:000:000",2], // ["sensor1","2021-01-06 18:00:00 001:000:000",2], // ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], // ["sensor1","2021-01-06 18:00:00 003:000:000",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor1", date_format: "YYYY-MM-DD HH24:MI:SS", start_time: "2021-01-06 17:00:00", end_time: "2021-01-06 21:00:00" }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor1","2021-01-06 17:00:00",1], // ["sensor1","2021-01-06 17:00:00",1.5], // ["sensor1","2021-01-06 17:00:00",2], // ["sensor1","2021-01-06 17:00:00",1], // ["sensor1","2021-01-06 17:00:00",1.5], // ["sensor1","2021-01-06 17:00:00",2], // ["sensor1","2021-01-06 17:00:00",1], // ["sensor1","2021-01-06 17:00:00",1.5], // ["sensor1","2021-01-06 17:00:00",2], // ["sensor1","2021-01-06 18:00:00",2], // ["sensor1","2021-01-06 18:00:00",2.5], // ["sensor1","2021-01-06 18:00:00",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS, data inserted with date skip mmm:uuu:nnn request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor2", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-06 17:00:00 000:000:000", end_time: "2021-01-06 21:00:00 000:000:000" }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor2","2021-01-06 17:00:00 000:000:000",1], // ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], // ["sensor2","2021-01-06 17:00:02 000:000:000",2], // ["sensor2","2021-01-06 17:00:03 000:000:000",1], // ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], // ["sensor2","2021-01-06 17:00:05 000:000:000",2], // ["sensor2","2021-01-06 18:00:00 001:000:000",2], // ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], // ["sensor2","2021-01-06 18:00:00 003:000:000",2], // ["sensor2","2021-01-06 20:00:04 000:000:000",2], // ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], // ["sensor2","2021-01-06 20:00:06 000:000:000",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with UTC-0 timezone request.get({ url: URL, qs: { type: SELECT_TYPE, timezone: "Africa/Abidjan", tag_name: "sensor2", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-06 17:00:00 000:000:000", end_time: "2021-01-06 21:00:00 000:000:000" }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor2","2021-01-06 17:00:00 007:000:000",1], // ["sensor2","2021-01-06 17:00:00 008:000:000",1.5], // ["sensor2","2021-01-06 17:00:00 009:000:000",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with local timezone, data inserted UTC-0 timezone setting request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor2", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-07 02:00:00 000:000:000", end_time: "2021-01-07 12:00:00 000:000:000" }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor2","2021-01-07 02:00:00 007:000:000",1], // ["sensor2","2021-01-07 02:00:00 008:000:000",1.5], // ["sensor2","2021-01-07 02:00:00 009:000:000",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with limit and offset request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor1", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-06 17:00:00 000:000:000", end_time: "2021-01-06 21:00:00 000:000:000", limit: 10, offset: 5 }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor1","2021-01-06 17:00:00 006:000:000",2], // ["sensor1","2021-01-06 17:00:00 007:000:000",1], // ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 009:000:000",2], // ["sensor1","2021-01-06 18:00:00 001:000:000",2], // ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], // ["sensor1","2021-01-06 18:00:00 003:000:000",2], // ["sensor1","2021-01-06 20:00:04 000:000:000",2], // ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], // ["sensor1","2021-01-06 20:00:06 000:000:000",2] // ] // } // } }) /* ------------------------------------------------------------------------------------------------- */ // CASE - DATA GET with descent by time request.get({ url: URL, qs: { type: SELECT_TYPE, tag_name: "sensor1,sensor2", date_format: "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", start_time: "2021-01-06 17:00:00 000:000:000", end_time: "2021-01-06 21:00:00 000:000:000", direction: 1 }, headers: { "x-api-key": API_KEY }}, function(error, response, body) { console.log(body); // Return Format // { // "success":true, // "reason":"success", // "data":{ // "columns":[ // {"name":"NAME","type":5,"length":80}, // {"name":"TIME","type":5,"length":4096}, // {"name":"VALUE","type":20,"length":17} // ], // "rows":[ // ["sensor2","2021-01-06 20:00:06 000:000:000",2], // ["sensor1","2021-01-06 20:00:06 000:000:000",2], // ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], // ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], // ["sensor2","2021-01-06 20:00:04 000:000:000",2], // ["sensor1","2021-01-06 20:00:04 000:000:000",2], // ["sensor2","2021-01-06 18:00:00 003:000:000",2], // ["sensor1","2021-01-06 18:00:00 003:000:000",2], // ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], // ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], // ["sensor2","2021-01-06 18:00:00 001:000:000",2], // ["sensor1","2021-01-06 18:00:00 001:000:000",2], // ["sensor2","2021-01-06 17:00:05 000:000:000",2], // ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], // ["sensor2","2021-01-06 17:00:03 000:000:000",1], // ["sensor2","2021-01-06 17:00:02 000:000:000",2], // ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 009:000:000",2], // ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 007:000:000",1], // ["sensor1","2021-01-06 17:00:00 006:000:000",2], // ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 004:000:000",1], // ["sensor1","2021-01-06 17:00:00 003:000:000",2], // ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], // ["sensor1","2021-01-06 17:00:00 001:000:000",1], // ["sensor2","2021-01-06 17:00:00 000:000:000",1] // ] // } // } })

github

""" Example For Select Raw Data for tag API by using request in python written by yeony kim """ import requests API_KEY = "YOUR_API_TOKEN" LAKE_ID = "YOUR_LAKE_ID" CLOUD_VENDOR="CLOUD_VENDOR" CLOUD_REGION="CLOUD_REGION" URL = f"https://{CLOUD_VENDOR}.{CLOUD_REGION}.machlake.com/v1/lakes/{LAKE_ID}/values" SELECT_TYPE="raw" headers = { "Content-Type": "application/json", "x-api-key": API_KEY } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn params = { "type": SELECT_TYPE, "tag_name": "sensor1", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-06 17:00:00 000:000:000", "end_time": "2021-01-06 21:00:00 000:000:000" } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00 001:000:000",1], # ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 003:000:000",2], # ["sensor1","2021-01-06 17:00:00 004:000:000",1], # ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 003:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS params = { "type": SELECT_TYPE, "tag_name": "sensor1", "date_format": "YYYY-MM-DD HH24:MI:SS", "start_time": "2021-01-06 17:00:00", "end_time": "2021-01-06 21:00:00" } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 17:00:00",1], # ["sensor1","2021-01-06 17:00:00",1.5], # ["sensor1","2021-01-06 17:00:00",2], # ["sensor1","2021-01-06 18:00:00",2], # ["sensor1","2021-01-06 18:00:00",2.5], # ["sensor1","2021-01-06 18:00:00",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS, data inserted with date skip mmm:uuu:nnn params = { "type": SELECT_TYPE, "tag_name": "sensor1", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-06 17:00:00 000:000:000", "end_time": "2021-01-06 21:00:00 000:000:000" } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 17:00:00 000:000:000",1], # ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:02 000:000:000",2], # ["sensor2","2021-01-06 17:00:03 000:000:000",1], # ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:05 000:000:000",2], # ["sensor2","2021-01-06 18:00:00 001:000:000",2], # ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor2","2021-01-06 18:00:00 003:000:000",2], # ["sensor2","2021-01-06 20:00:04 000:000:000",2], # ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor2","2021-01-06 20:00:06 000:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with UTC-0 timezone params = { "type": SELECT_TYPE, "timezone": "Africa/Abidjan", "tag_name": "sensor1", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-06 17:00:00 000:000:000", "end_time": "2021-01-06 21:00:00 000:000:000" } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 17:00:00 007:000:000",1], # ["sensor2","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor2","2021-01-06 17:00:00 009:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with local timezone, data inserted UTC-0 timezone setting params = { "type": SELECT_TYPE, "tag_name": "sensor2", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-07 02:00:00 000:000:000", "end_time": "2021-01-07 12:00:00 000:000:000" } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-07 02:00:00 007:000:000",1], # ["sensor2","2021-01-07 02:00:00 008:000:000",1.5], # ["sensor2","2021-01-07 02:00:00 009:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with limit and offset params = { "type": SELECT_TYPE, "tag_name": "sensor1", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-06 17:00:00 000:000:000", "end_time": "2021-01-06 21:00:00 000:000:000", "limit": 10, "offset": 5 } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 003:000:000",2], # ["sensor1","2021-01-06 20:00:04 000:000:000",2], # ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor1","2021-01-06 20:00:06 000:000:000",2] # ] # } # } # ------------------------------------------------------------------------------------------------- # # CASE - DATA GET with descent by time params = { "type": SELECT_TYPE, "tag_name": "sensor1,sensor2", "date_format": "YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn", "start_time": "2021-01-06 17:00:00 000:000:000", "end_time": "2021-01-06 21:00:00 000:000:000", "direction": 1 } response = requests.get(URL, headers=headers, params=params, verify=False) print(response.content.decode("utf-8")) # Return Format # { # "success":true, # "reason":"success", # "data":{ # "columns":[ # {"name":"NAME","type":5,"length":80}, # {"name":"TIME","type":5,"length":4096}, # {"name":"VALUE","type":20,"length":17} # ], # "rows":[ # ["sensor2","2021-01-06 20:00:06 000:000:000",2], # ["sensor1","2021-01-06 20:00:06 000:000:000",2], # ["sensor2","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor1","2021-01-06 20:00:05 000:000:000",2.5], # ["sensor2","2021-01-06 20:00:04 000:000:000",2], # ["sensor1","2021-01-06 20:00:04 000:000:000",2], # ["sensor2","2021-01-06 18:00:00 003:000:000",2], # ["sensor1","2021-01-06 18:00:00 003:000:000",2], # ["sensor2","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor1","2021-01-06 18:00:00 002:000:000",2.5], # ["sensor2","2021-01-06 18:00:00 001:000:000",2], # ["sensor1","2021-01-06 18:00:00 001:000:000",2], # ["sensor2","2021-01-06 17:00:05 000:000:000",2], # ["sensor2","2021-01-06 17:00:04 000:000:000",1.5], # ["sensor2","2021-01-06 17:00:03 000:000:000",1], # ["sensor2","2021-01-06 17:00:02 000:000:000",2], # ["sensor2","2021-01-06 17:00:01 000:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 009:000:000",2], # ["sensor1","2021-01-06 17:00:00 008:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 007:000:000",1], # ["sensor1","2021-01-06 17:00:00 006:000:000",2], # ["sensor1","2021-01-06 17:00:00 005:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 004:000:000",1], # ["sensor1","2021-01-06 17:00:00 003:000:000",2], # ["sensor1","2021-01-06 17:00:00 002:000:000",1.5], # ["sensor1","2021-01-06 17:00:00 001:000:000",1], # ["sensor2","2021-01-06 17:00:00 000:000:000",1] # ] # } # }

 

Related content