API and integrations · Guide 6 of 8
Evocon API - Connecting Process Metrics data to Excel
API URL and URL parameters of the clientmetrics_json report endpoint for loading Process Metrics data into Excel.
On this page
General information
The general guide for connecting Evocon API data to Excel is available here:
API URL
https://api.evocon.com/api/reports/clientmetrics_json?startTime=2023-06-04&endTime=2025-01-01&stationId=13&groupByDate=1
URL Parameters
There are 4 different parameters for this API endpoint.
stationId(required) id of the station that you want to get data for. To get data for multiple stations, use them all in the query (...stationId=1&stationId=2&stationId=3&....)startTime(required) parameter specifies the start date of the shift for the dataset.endTimeparameter specifies the end date of the shift for the dataset.groupByDateparameter (value either 1 or parameter not used). If the parameter is used and the value is 1, group the sum of the values by station, shift name and shift date. If this parameter is not used, each data point is returned individually. Requesting data for more than a month and 1 station may time out if requesting each value.