EP. Get Category Metrics Historical Values - CSV
Fetch the historical values of all metrics that are assigned a specific category, in CSV format.
URI
/api/v1/locations/{LOCATION_ID}/categories/{CATEGORY_ID}/csv?q={FILTER}
Request Query Parameters
| Request Parameter | Description |
|---|---|
LOCATION_ID | UUID assigned to a specific location |
CATEGORY_ID | ID of a target category |
FILTER | A base64 encoded filter query |
{
"type": "object",
"properties": {
"period": {
"type": "string"
},
"scale": {
"type": "string"
},
"date_from": {
"type": "string"
},
"date_to": {
"type": "string"
},
"scale": {
"type": "string"
},
"show_average": {
"type": "boolean"
},
"show_min": {
"type": "boolean"
},
"show_max": {
"type": "boolean"
},
"show_summary": {
"type": "boolean"
},
"display_hours": {
"type": "string"
},
"hide_zero_buckets": {
"type": "boolean"
}
}
}
| Parameter | Description | Example/Valid Values |
|---|---|---|
period | Specifies the time period for the data. | CustomRange, FixedRange, Today, Yesterday, ThisWeek, LastWeek, ThisMonth, LastMonth |
scale | Determines the time bucket for each data value. | OneMinute, TenMinute, Hour, Day |
date_from | The RFC3339 date string representing the start of the data period. It should be the local time of the venue, represented in UTC. Only used if period is CustomRange or FixedRange. | 2022-06-01T15:00:00Z means "3pm in the time zone of the venue". |
date_to | The end date for the data range. See comments above. | See above. |
show_average | A boolean indicating whether to show average values or not. | true, false |
show_min | A boolean indicating whether to show minimum values or not. | true, false |
show_max | A boolean indicating whether to show maximum values or not. | true, false |
event_value_type | Reserved. Always Count. | Count |
data_type | Reserved. Always use example value. | {"type": "Count", "value": "Count"} |
display_hours | Use Venue Operating Hours or 24 hours (when period is e.g. Today) | OH, 24H |
show_summary | A boolean indicating whether to show a summary of data or not. | true, false |
hide_zero_buckets | Valid for API requests that provide response with Content-Type: text/csv. A boolean indicating whether to exclude rows which have zero values only. | true, false |
Sample Filter Query
Response
Row 1:
Column 1 : 'Time'
Column 2+: Name of a metric
Row 2+:
Column 1 : Time of a bucket as RFC3339 date string
Column 2+: Value of metric