{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["CloudReady Sensor Data API Example"]
[]
[]
["API Access Key","apikey=914abf670f2c09bb235ef0e3b467e5f7","Obtain on your CloudReady profile page."]
["Period",5,"Select"]
["ID(s)","9007,9008,9009","Comma-separated list"]
["Type",1,"Select"]
[]
["Query URL",{"$f":"CONCATENATE(\"https://secure.exoprise.com/api/v1/sensors/export_data.csv?apikey=\",IFERROR(RIGHT(B4,LEN(B4)-FIND(\"=\",B4)),B4),\"&period=\",VLOOKUP(B5,A18:B24,2),\"&ids=\",B6,IF(B7=2,\"&type=crowd\",\"\"))","v":"https://secure.exoprise.com/api/v1/sensors/export_data.csv?apikey=914abf670f2c09bb235ef0e3b467e5f7&period=7d&ids=9007,9008,9009"}]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"TEXT;\",queryURL)","v":"TEXT;https://secure.exoprise.com/api/v1/sensors/export_data.csv?apikey=914abf670f2c09bb235ef0e3b467e5f7&period=7d&ids=9007,9008,9009"}]
[]
[]
[1,"3h",1,"Sensor"]
[2,"6h",2,"Crowd"]
[3,"12h"]
[4,"1d"]
[5,"7d"]
[6,"30d"]
[7,"90d"]
[]
["created_at"]