Searching:
0 results found
BackCharts/ExportChartstoCSV
Description
To retrieve data from Axonize in a CSV format, see the following for request and response details:
See Also
Request ‒ Charts/ExportChartstoCSV
This request has all the same properties as Request – Charts/CreateChart.
Example JSON Charts/ExportChartstoCSV Request
curl -X POST \
https://api.dev.axonize.com/api/charts/exportChartToCSV \
-H ‘Authorization: Token’ \
-H ‘Content-Type: application/json’ \
-H ‘appId: 801A048A-9F23-429F-BF0D-B6D35B22771E’ \
-d ‘{“interval”:”days”,”series”:[{“eventName”:”Humidity”,”eventType”:8,”aggregation”:”average”,”inputType”:0,”inputId”:”5b3c8ed719ec0c1cfc4107bf”,”startDate”:”2018-05-05T21:00:00.000Z”,”endDate”:”2018-07-25T20:59:59.000Z”,”id”:16,”machineLearningMethod”:null}],”timezone”:”Asia/Jerusalem”}”
Response ‒ Charts/exportChartstoCSV
This response has the same data as Request – Charts/CreateChart, except that it is returned in a CSV format.
*Note ‒ The response does not return any of the display metadata that CreateChart returns.
Example JSON Charts/ExportChartstoCSV Response
Status 200 – OK
Timestamp, DeviceName, DeviceId, EventType, EventName,Spice World – Humidity
7/4/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,1.40322617170527E+37
7/5/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,3.97215994948154E+37
7/6/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,5.22947804898479E+37
7/7/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,2.42099694270886E+37
7/8/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,5.08418687646662E+37
7/9/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,2.55045285763822E+37
7/10/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,3.14486122831409E+37
7/11/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,4.25352933298161E+37
7/12/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,3.98225856696379E+37
7/13/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,2.83014785651534E+37
7/14/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,5.38335157933859E+37
7/15/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,7.08365563943675E+37
7/16/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,5.79199592563922E+37
7/17/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,5.66029571303069E+37
7/18/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,7.07813882402456E+37
7/19/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,2.83568622198774E+37
7/20/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,2.43056971879503E+37
7/21/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,1.38890753730012E+37
7/22/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,1.41782156093367E+37
7/23/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,1.38890753730012E+37
7/24/2018 9:00:00 PM +00:00,Spice World,5b3c8ed719ec0c1cfc4107bf,8,Humidity,1.36112938655412E+37