# Text Encoding to UTF-8 in CMD
# Example For Select Raw Data for tag API by using curl in ubuntu
# written by yeony kim
LAKE_ID=$YOUR_LAKE_ID
API_KEY=YOUR$YOUR_API_TOKEN_KEY
CLOUD_VENDOR=$YOUR_CLOUD_VENDOR
CLOUD_REGION=$YOUR_CLOUD_REGION
CONTENT_HEADER=Content-Type:application/json
API_HEADER=x-api-key:$API_KEY
LAKE_ID=YOUR_LAKE_ID
URL=https://$LAKE_ID${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
# {"data":{"calc_mode
# "success":true,
# "reason":"rawsuccess","columns":[
# "data":{
# "columns":[
# {"name":"TIMENAME","type":5,"length":409680},
# {"name":"VALUETIME","type":205,"length":174096}],"samples":[{"tag_name":"sensor1","data":[{"TIME":,
# {"name":"VALUE","type":20,"length":17}
# ],
# "rows":[
# ["sensor1","2021-01-06 17:00:00 001:000:000","VALUE":1},{"TIME":"],
# ["sensor1","2021-01-06 17:00:00 002:000:000","VALUE":1.5},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 003:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 004:000:000","VALUE":1},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 005:000:000","VALUE":1.5},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 006:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 007:000:000","VALUE":1},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 008:000:000","VALUE":1.5},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 009:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 001:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 002:000:000","VALUE":2.5},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 003:000:000","VALUE":2},{"TIME":"2021-01-06 20:00:04 000:000:000","VALUE":2},{"TIME":"2021-01-06 20:00:05 000: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
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 "tag_nametype=$TAG$SELECT_NAME"TYPE" \
--data-urlencode "datetag_formatname=$DATE$TAG_FORMATNAME" \
--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":"sensor1VALUE","datatype":[{20,"TIMElength":"2021-01-06 17:00:00","VALUE":1},{"TIME":17}
# ],
# "rows":[
# ["sensor1","2021-01-06 17:00:00","VALUE":1.5},{"TIME":1],
# ["sensor1","2021-01-06 17:00:00",1.5],"VALUE":2},{"TIME":
# ["sensor1","2021-01-06 17:00:00","VALUE":1},{"TIME":"2],
# ["sensor1","2021-01-06 17:00:00","VALUE":1.5},{"TIME":1],
# ["sensor1","2021-01-06 17:00:00","VALUE":2},{"TIME":1.5],
# ["sensor1","2021-01-06 17:00:00",2],
# ["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 18:00:00","VALUE":2},{"TIME":2],
# ["sensor1","2021-01-06 18:00:00","VALUE":2.5},{"TIME":],
# ["sensor1","2021-01-06 18:00:00","VALUE":2},{"TIME":"2021-01-06 20:00:04","VALUE":2},{"TIME":"2021-01-06 20:00:05","VALUE":2.5},{"TIME":"2021-01-06 20:00:06","VALUE":2}]}]},"status":"success"}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# / 현재 Insert된 데이터를 가져오며"success":true,
InsertStandard를# 수행한 후 실행하면 하기와 같은 response를 받을 수 있음
# {"data":{"calc_mode":"raw","columns":[ "reason":"success",
# "data":{
# "columns":[
# {"name":"NAME","type":5,"length":80},
# {"name":"TIME","type":5,"length":4096},
# {"name":"VALUE","type":20,"length":17}
# ],"samples":[{"tag_name":"sensor2","data":[{"TIME":"
# "rows":[
# ["sensor2","2021-01-06 17:00:00 000:000:000","VALUE":1},{"TIME":],
# ["sensor2","2021-01-06 17:00:01 000:000:000","VALUE":1.5},{"TIME":],
# ["sensor2","2021-01-06 17:00:02 000:000:000","VALUE":2},{"TIME":],
# ["sensor2","2021-01-06 17:00:03 000:000:000","VALUE":1},{"TIME":],
# ["sensor2","2021-01-06 17:00:04 000:000:000","VALUE":1.5},{"TIME":],
# ["sensor2","2021-01-06 17:00:05 000:000:000","VALUE":2},{"TIME":],
# ["sensor2","2021-01-06 18:00:00 001:000:000","VALUE":2},{"TIME":],
# ["sensor2","2021-01-06 18:00:00 002:000:000","VALUE":2.5},{"TIME":],
# ["sensor2","2021-01-06 18:00:00:00 003:000:000","VALUE":2},{"TIME":" 003:000:000",2],
# ["sensor2","2021-01-06 20:00:04 000:000:000","VALUE":2},{"TIME":],
# ["sensor2","2021-01-06 20:00:05 000:000:000","VALUE":2.5},{"TIME":],
# ["sensor2","2021-01-06 20:00:06 000:000:000","VALUE":2}]}]},"status":"success"]
# ]
# }
# }
# ------------------------------------------------------------------------------------------------- #
# CASE - DATA GET with date format YYYY-MM-DD HH24:MI:SS and 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 "Use-Timezone: Africa/Abidjan" -H $CONTENT_HEADER -H $API_HEADER000: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# / 현재 Insert된 데이터를 가져오며, InsertStandard를 수행한 후 실행하면 하기와 같은 response를 받을 수 있음
# {"data":{"calc_mode":"raw","columns":["success":true,
# "reason":"success",
# "data":{
# "columns":[
# {"name":"NAME","type":5,"length":80},
# {"name":"TIME","type":5,"length":4096},
# {"name":"VALUE","type":20,"length":17}
# ],"samples":[{"tag_name":"sensor2","data":[{"TIME":"
# "rows":[
# ["sensor2","2021-01-06 17:00:00 007:000:000","VALUE":1},{"TIME":],
# ["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
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":{"calc_mode":"raw","columns":[
# "columns":[
# {"name":"NAME","type":5,"length":80},
# {"name":"TIME","type":5,"length":4096},4096},
# {"name":"VALUE","type":20,"length":17}
# ],"samples":[{"tag_name":
# "rows":[
# ["sensor2","data":[{"TIME":"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 date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn
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"
LIMIT=10
OFFSET=5
DIRECTION=0
VALUE_RETURN_FORM
DIRECTION=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 " --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":[offset=$OFFSET" \
--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}
# ],"samples":[{"tag_name":
# "rows":[
# ["sensor1","data":[{"TIME":"2021-01-06 17:00:00 006:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 007:000:000","VALUE":1},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 008:000:000","VALUE":1.5},{"TIME":],
# ["sensor1","2021-01-06 17:00:00 009:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 001:000:000","VALUE":2},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 002:000:000","VALUE":2.5},{"TIME":],
# ["sensor1","2021-01-06 18:00:00 003:000:000","VALUE":2},{"TIME":],
# ["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 date format YYYY-MM-DD HH24:MI:SS mmm:uuu:nnn
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"
LIMIT=
OFFSET=
DIRECTION=1
VALUE_RETURN_FORM=1
curl -k -G $URL -H $CONTENT_HEADER -H $API_HEADERDIRECTION=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
# {
# "success":true,
# "reason":"success",
# "data":{
# "columns":[
# {"calc_modename":"NAME"raw,"type":5,"columnslength":[80},
# {"name":"TIME","type":5,"length":4096},
# {"name":"VALUE","type":20,"length":17}
# ],"samples":[{"tag_name":
# "rows":[
# ["sensor2","2021-01-06 20:00:06 000:000:000",2],
# ["sensor2","2021-01-06 20:00:05 000:000:000",2.5],
# ["sensor2","data":{"TIME":["2021-01-06 20:00:0604 000:000:000",2],
# ["sensor2","2021-01-06 2018:00:0500 000003:000:000","2021-01-06 20:00:04 000:000:000,2],
# ["sensor2","2021-01-06 18:00:00 003002:000:000",2.5],
# ["sensor2","2021-01-06 18:00:00 002001:000:000",2],
# ["sensor2","2021-01-06 1817:00:0005 001000:000:000000",2],
# ["sensor2","2021-01-06 17:00:0504 000:000:000","2021-01-06 17:00:04 000:000:0001.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],
# ["sensor2","2021-01-06 17:00:00 000:000:000"],"VALUE":[2,2.5,2,2,2.5,2,2,1.5,1,2,1.5,1]}},{"tag_name":"sensor1","data":{"TIME":[",
# ["sensor1","2021-01-06 20:00:06 000:000:000",2],
# ["sensor1","2021-01-06 20:00:05 000:000:000",2.5],
# ["sensor1","2021-01-06 20:00:04 000:000:000",2],
# ["sensor1","2021-01-06 18:00:00 003:000:000:000:000",2],
# ["sensor1","2021-01-06 18:00:00 002:000:000",2.5],
# ["sensor1","2021-01-06 18:00:00 002001:000:000",2],
# ["sensor1","2021-01-06 1817:00:00 001009:000:000",2],
# ["sensor1","2021-01-06 17:00:00 009008:000:000",1.5],
# ["sensor1","2021-01-06 17:00:00 008007:000:000",1],
# ["sensor1","2021-01-06 17:00:00 007006:000:000",2],
# ["sensor1","2021-01-06 17:00:00 006005:000:000000",1.5],
# ["sensor1","2021-01-06 17:00:00 005004:000:000","2021-01-06 17:00:00 004:000:0001],
# ["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"],"VALUE":[2,2.5,2,2,2.5,2,2,1.5,1,2,1.5,1,2,1.5,1]}}]},"status":"success"]
# ]
# }
# }
# ------------------------------------------------------------------------------------------------- # |