Content Comparison

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_TOKENKEY
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 LAKE_ID=YOUR_LAKE_ID
set URL="https://%LAKE_ID%%CLOUD_VENDOR%.%CLOUD_REGION%.machlake.com/v1/lakes/%LAKE_ID%/values/raw""

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
:: {"data":{"calc_mode":"raw","columns":[{"name":"TIME","type":5
::     "success":true,
::     "reason":"success",
::     "data":{
::         "columns":[
::             {"name":"NAME","type":5,"length":409680},
::             {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_
::             {"name":"sensor1VALUE","datatype":[{20,"TIMElength":"2021-01-06 17:00:00 001:000:000","VALUE":1},{"TIME":17}
::         ],
::         "rows":[
::             ["sensor1","2021-01-06 17:00:00 002001:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor1","2021-01-06 17:00:00 003002:000:000",1.5],"VALUE":2},{"TIME":
::             ["sensor1","2021-01-06 17:00:00 004003:000:000","VALUE":1},{"TIME":"2],
::             ["sensor1","2021-01-06 17:00:00 005004:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor1","2021-01-06 17:00:00 006005:000:000","VALUE":2},{"TIME":1.5],
::             ["sensor1","2021-01-06 17:00:00 007006:000:000","VALUE":1},{"TIME":"2],
::             ["sensor1","2021-01-06 17:00:00 008007:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor1","2021-01-06 17:00:00 009008:000:000",1.5],"VALUE":2},{"TIME":"
::             ["sensor1","2021-01-06 1817:00:00 001009:000:000","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 18:00:00 002001:000:000","VALUE":2.5},{"TIME":2],
::             ["sensor1","2021-01-06 18:00:00 003002:000:000","VALUE":2},{"TIME":"2021-01-06 20:00:04 000:000:000","VALUE":2},{"TIME":2.5],
::             ["sensor1","2021-01-06 2018:00:0500 000003:000:000","VALUE":2.5},{"TIME":"2021-01-06 20:00:06 000:000:000","VALUE":2}]}]},"status":"success"2]
::         ]
::     }
:: }

:: ------------------------------------------------------------------------------------------------- ::

:: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS

set DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
set curl -k -G %URL% -H %CONTENT_HEADER% -H %API_HEADER% --data-urlencode "tag_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
:: {"data":{"calc_mode":"raw","columns":[{"name":"TIME","type":5,"length":4096},{"name":"VALUE
::     "success":true,
::     "reason":"success",
::     "data":{
::         "columns":[
::             {"name":"NAME","type":205,"length":1780}],"samples":[{"tag_
::             {"name":"sensor1TIME","datatype":[{5,"TIMElength":"2021-01-06 17:00:00","VALUE":1},{"TIME":"2021-01-06 17:00:00","VALUE":1.5},{"TIME":4096},
::             {"name":"VALUE","type":20,"length":17}
::         ],
::         "rows":[
::             ["sensor1","2021-01-06 17:00:00","VALUE":2},{"TIME":"2021-01-06 17:00:00","VALUE":1},{"TIME":1],
::             ["sensor1","2021-01-06 17:00:00","VALUE":1.5},{"TIME":],
::             ["sensor1","2021-01-06 17:00:00","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 17:00:00","VALUE":1},{"TIME":],
::             ["sensor1","2021-01-06 17:00:00","VALUE":1.5},{"TIME":],
::             ["sensor1","2021-01-06 17:00:00","VALUE":2},{"TIME":"],
::             ["sensor1","2021-01-06 1817:00:00",1],"VALUE":2},{"TIME":"
::             ["sensor1","2021-01-06 1817:00:00","VALUE":21.5},{"TIME":],
::             ["sensor1","2021-01-06 1817:00:00","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 2018:00:0400","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 2018:00:0500","VALUE":2.5},{"TIME":"2021-01-06 20:00:06","VALUE":2}]}]},"status":"success"],
::             ["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
/ 현재 Insert된 데이터를 가져오며, InsertStandard를 수행한 후 실행하면 하기와 같은 response를 받을 수 있음
:: {:: {
::     "success":true,
::     "reason":"success",
::     "data":{"calc_mode":"raw","columns":[
::         "columns":[
::             {"name":"TIMENAME","type":5,"length":409680},
::             {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_
::             {"name":"sensor2VALUE","datatype":[{20,"TIMElength":"2021-01-06 17:00:00 000:000:000","VALUE":1},{"TIME":17}
::         ],
::         "rows":[
::             ["sensor2","2021-01-06 17:00:0100 000:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor2","2021-01-06 17:00:0201 000:000:000",1.5],"VALUE":2},{"TIME":"
::             ["sensor2","2021-01-06 17:00:0302 000:000:000","VALUE":1},{"TIME":"2],
::             ["sensor2","2021-01-06 17:00:0403 000:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor2","2021-01-06 17:00:0504 000:000:000",1.5],"VALUE":2},{"TIME":"
::             ["sensor2","2021-01-06 1817:00:0005 001000:000:000","VALUE":2},{"TIME":"],
::             ["sensor2","2021-01-06 18:00:00 002001:000:000","VALUE":2.5},{"TIME":2],
::             ["sensor2","2021-01-06 18:00:00 003002:000:000","VALUE":2},{"TIME":2.5],
::             ["sensor2","2021-01-06 2018:00:0400 000003:000:000","VALUE":2},{"TIME":],
::             ["sensor2","2021-01-06 20:00:0504 000:000:000","VALUE":2.5},{"TIME":2],
::             ["sensor2","2021-01-06 20:00:0605 000:000:000","VALUE":2}]}]},"status":"success"2.5],
::             ["sensor2","2021-01-06 20:00:06 000:000:000",2]
::         ]
::     }
:: }

:: ------------------------------------------------------------------------------------------------- ::

:: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS and with UTC-0 timezone
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 "Use-Timezone: Africa/Abidjan"%CONTENT_HEADER% -H %CONTENT%API_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
/ 현재 Insert된 데이터를 가져오며, InsertStandard를 수행한 후 실행하면 하기와 같은 response를 받을 수 있음
:: {:: {
::     "success":true,
::     "reason":"success",
::     "data":{"calc_mode":"raw","
::         "columns":[
::             {"name":"TIMENAME","type":5,"length":409680},
::             {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_
::             {"name":"sensor2VALUE","datatype":[{20,"TIMElength":"2021-01-06 17:00:00 007:000:000","VALUE":1},{"TIME":17}
::         ],
::         "rows":[
::             ["sensor2","2021-01-06 17:00:00 007:000:000",1],
::             ["sensor2","2021-01-06 17:00:00 008:000:000","VALUE":1.5},{"TIME":],
::             ["sensor2","2021-01-06 17:00:00 009:000:000","VALUE":2}]}]},"status":"success"]
::         ]
::     }
:: }

:: ------------------------------------------------------------------------------------------------- ::

:: CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS and 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
:: {"data":{"calc_mode
::     "success":true,
::     "reason":"rawsuccess",
::     "data":{
::         "columns":[
::             {"name":"TIMENAME","type":5,"length":409680},
::             {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_
::             {"name":"sensor2VALUE","data":[{"TIME":"type":20,"length":17}
::         ],
::         "rows":[
::             ["sensor2","2021-01-07 02:00:00 007:000:000","VALUE":1},{"TIME":],
::             ["sensor2","2021-01-07 02:00:00 008:000:000","VALUE":1.5},{"TIME":],
::             ["sensor2","2021-01-07 02:00:00 009:000:000","VALUE":2}]}]},"status":"success"]
::         ]
::     }
:: }

:: ------------------------------------------------------------------------------------------------- ::

:: CASE - DATA GET with datelimit and formatoffset
YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn
set 
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
set DIRECTION=0
set VALUE_RETURN_FORM=0

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%" --data-urlencode "direction=%DIRECTION%"\
    --data-urlencode "value_return_form=%VALUE_RETURN_FORM%offset=%OFFSET%"

:: Return Format
:: {"data":{"calc_mode":"raw","columns":[{"name":"TIME","type":5,"length":4096},{"name":"VALUE"
::     "success":true,
::     "reason":"success",
::     "data":{
::         "columns":[
::             {"name":"NAME","type":205,"length":1780}],"samples":[{"tag_
::             {"name":"sensor1TIME","datatype":[{5,"TIMElength":"2021-01-06 17:00:00 006:000:000","VALUE":2},{"TIME":"4096},
::             {"name":"VALUE","type":20,"length":17}
::         ],
::         "rows":[
::             ["sensor1","2021-01-06 17:00:00 007006:000:000",2],"VALUE":1},{"TIME":"
::             ["sensor1","2021-01-06 17:00:00 008007:000:000","VALUE":1.5},{"TIME":1],
::             ["sensor1","2021-01-06 17:00:00 009008:000:000","VALUE":2},{"TIME":"1.5],
::             ["sensor1","2021-01-06 1817:00:00 001009:000:000","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 18:00:00 002001:000:000","VALUE":2.5},{"TIME":2],
::             ["sensor1","2021-01-06 18:00:00 003002:000:000","VALUE":2},{"TIME":2.5],
::             ["sensor1","2021-01-06 18:00:00 003:000:000",2],
::             ["sensor1","2021-01-06 20:00:04 000:000:000","VALUE":2},{"TIME":],
::             ["sensor1","2021-01-06 20:00:05 000:000:000","VALUE":2.5},{"TIME":],
::             ["sensor1","2021-01-06 20:00:06 000:000:000","VALUE":2}]}]},"status":"success"]
::         ]
::     }
:: }

:: ------------------------------------------------------------------------------------------------- ::

:: CASE - DATA GET with descent dateby formattime
YYYY-MM-DD
HH24:MI:SS mmm:uuu:nnn
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=
set OFFSET=
set DIRECTION=1
set
VALUE_RETURN_FORM=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 "limit=%LIMIT%" --data-urlencode "offset=%OFFSET%"\
    --data-urlencode "direction=%DIRECTION%" --data-urlencode "value_return_form=%VALUE_RETURN_FORM%"

:: Return Format
:: {"data":{"calc_mode":"raw","columns":[{"name":"TIME","type":
::     "success":true,
::     "reason":"success",
::     "data":{
::         "columns":[
::             {"name":"NAME","type":5,"length":409680},
::             {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_
::             {"name":"sensor2VALUE","datatype":{20,"TIMElength":["2021-01-06 20:00:06 000:000:000:17}
::         ],
::         "rows":[
::             ["sensor2","2021-01-06 20:00:0506 000:000:000","20212],
::             ["sensor1","2021-01-06 20:00:0406 000:000:000","2021-01-06 18:00:00 003:000:0002],
::             ["sensor2","2021-01-06 1820:00:0005 002000:000:000","2021-01-06 18:00:00 001:000:000,2.5],
::             ["sensor1","2021-01-06 1720:00:05 000:000:000",2.5],
::             ["sensor2","2021-01-06 1720:00:04 000:000:000","2021-01-06 17:00:03 000:000:000,2],
::             ["sensor1","2021-01-06 1720:00:0204 000:000:000","2021-01-06 17:00:01 000:000:0002],
::             ["sensor2","2021-01-06 1718:00:00 000003:000:000"],"VALUE":[2,2.5,2,2,2.5,2,2,1.5,1,2,1.5,1]}},{"tag_name":,
::             ["sensor1","data":{"TIME":["2021-01-06 2018:00:0600 000003:000:000","2021-01-06 20:00:05 000:000:000","2021-01-06 20:00:04 000:000:0002],
::             ["sensor2","2021-01-06 18:00:00 003002: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 1718:00:00 009001:000:000",2],
::             ["sensor2","2021-01-06 17:00:0005 008000:000:000",2],
::             ["sensor2","2021-01-06 17:00:0004 007000:000:000","2021-01-06 17:00:00 006:000:0001.5],
::             ["sensor2","2021-01-06 17:00:0003 005000:000:000",1],
::             ["sensor2","2021-01-06 17:00:0002 004000:000:000",2],
::             ["sensor2","2021-01-06 17:00:0001 003000:000:000",1.5],
::             ["sensor1","2021-01-06 17:00:00 002009:000:000",2],
::             ["sensor1","2021-01-06 17:00:00 001008:000:000"],"VALUE":[2,2.5,2,2,2.5,2,2,1.5,1,2,1.5,1,2,1.5,1]}}]},"status":"success"}
::  :: ------------------------------------------------------------------------------------------------- ::           ["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]
::         ]
::     }
:: }