Vehicles feed
One row for each vehicle of your organization. A lookup table for the other feeds. Part of BI analytics in the documentation.
GET/v1/analytics/vehicles
Returns one row for each vehicle of your organization. Rows sort by device id. This feed does not use since or until.
Use it as a lookup table. Relate the other feeds to it on device_id.
| Parameter | Required | Notes |
|---|---|---|
limit | No | Rows per page, from 1 to 5000. Default 1000. |
offset | No | First row to return. Default 0. Use next_ from the answer to read the next page. |
Send an API key with the analytics:read scope in the Authorization header. A key reads data for its organization only. See BI analytics for the rules that all feeds share.
Example
Request:
curl 'https://filodos.gr/filodos-dashboard/api/scoring/v1/analytics/vehicles?limit=5000' \
-H "Authorization: Bearer filodos_REPLACE_WITH_YOUR_KEY"
Answer (200). The example shows two rows of 2. A real page has up to limit rows. next_offset is null on the last page.
{
"rows": [
{
"device_id": 43,
"vehicle_name": "IKX-1234",
"unique_id": "018271406491",
"model": "V7 Pro",
"category": "truck",
"status": "online",
"last_update": "2026-10-05T10:14:03+03:00",
"current_driver_names": "Nikos Papadopoulos",
"recorded_distance_km": 18432.7,
"last_trip_at": "2026-10-05T09:02:41+03:00"
},
{
"device_id": 44,
"vehicle_name": "IKY-5678",
"unique_id": "018271406502",
"model": null,
"category": "van",
"status": "offline",
"last_update": "2026-10-04T19:40:11+03:00",
"current_driver_names": null,
"recorded_distance_km": 9120.4,
"last_trip_at": "2026-10-04T18:55:20+03:00"
}
],
"total": 2,
"limit": 5000,
"offset": 0,
"next_offset": null
}
In Excel
- Make the query in the Excel Power Query procedure.
- Set
Feed = "vehicles"in the query. - Select Close & Load.
The sheet then has one row for each row in the answer. A null value gives an empty cell. Some of the columns of the example look like this:
device_ | vehicle_ | status | last_ | current_ | recorded_ |
|---|---|---|---|---|---|
| 43 | IKX-1234 | online | 2026-10-05T10:14:03+03:00 | Nikos Papadopoulos | 18432.7 |
| 44 | IKY-5678 | offline | 2026-10-04T19:40:11+03:00 | 9120.4 |
Fields
Each row has these fields, in this order. A timestamp is ISO 8601 Europe/Athens time with an explicit offset.
| Field | Type | Meaning |
|---|---|---|
device_ | integer | The Filodos device id. |
vehicle_ | text | The vehicle name, usually the plate. |
unique_ | text | The device identifier (for a JT/T808 device, the terminal phone number). |
model | text or null | The device model, if set. |
category | text or null | The vehicle category on the map, if set. |
status | text | online, offline, or unknown. |
last_ | timestamp or null | The time of the last report from the device. |
current_ | text or null | The drivers linked to the vehicle now. |
recorded_ | number | The total trip distance that Filodos recorded. It is not the vehicle odometer. |
last_ | timestamp or null | The start time of the most recent trip. |
The Power Query recipe sends since and until to all feeds. This feed ignores them.
Errors
An error answer has a JSON body with a detail field.
| Status | Cause |
|---|---|
401 | The Authorization header is missing, or the key is unknown or revoked. |
403 | The key does not have the analytics:read scope, or the caller is a driver login. |
422 | limit or offset is out of range. |
503 | The live device list is not available. Try again later. |