get_d8_bookings.php
Table of Contents
compatibility
To us this function, you need one vehicle with activated D8-interface
Return all bookings of D8 interface.
You need at least an activated RTI interface and an generated RTI-Key for requested vehicles!
Description
GET get_d8_bookings.php?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS&format=CSV
Parameter
| Parameter | Description | Type | Note | Mandatory |
|---|---|---|---|---|
| company | RTI company key | string | yes | |
| import | RTI import key | string | either import, vehicle or group Parameter | (yes) |
| vehicle | RTI vehicle key | string | either import, vehicle or group Parameter | (yes) |
| group | RTI group key | string | either import, vehicle or group Parameter | yes |
| start | Startzeitpunkt der Ausgabe | string | the requested persiod may not exceed 31 days | yes |
| end | Endzeitpunkt der Ausgabe | string | the requested persiod may not exceed 31 days | yes |
| format | return format | string | support
| yes |
Return
Return a string. In case of error it returns "ERROR:Description".
JSON format
return a string as json
Example output
return in json
[
{
"date": "2020-03-01T02:25:04+01:00",
"vehicle": "YF1234",
"ignition": 0,
"lat": 51.04,
"lon": 13.6,
"key": "DF47110815123000",
"eventtype": 1,
"state": 0,
"eventid": "CF1C6C0DA98DC17B48B7C4C7DD3F0EE428EF9A61"
},
{
"date": "2020-03-01T02:25:24+01:00",
"vehicle": "YF1234",
"ignition": 0,
"lat": 51.04,
"lon": 13.6,
"key": null,
"eventtype": 3,
"state": 1,
"eventid": "EF8F2B94F43228F8F6151D050413E5D9BEFBDE96"
}
]
CSV Format
Meta informations
| Separator | Semicolon ( ; ) |
|---|---|
| Delimiter | Double quote |
| Line break | 0x0D 0x0A (CarriageReturn LineFeed) |
| Header | Line1 |
| Coding | Windows-1252 |
CSV Columns
| Column | Description | |
|---|---|---|
| DATE | date and time of digitacho | format ISO 8601 |
| VEHICLE | user defined RTI vehicle ident (if the user define no vehicle ident, we return the vehicle sign) | |
| IGNITION | ignition state by digitacho | 1: ignition on 0: ignition off |
| LAT | latitude | |
| LON | longitude | |
| KEY | driver key | |
| EVENTTYPE | event | 0: card activitity on 1. Slot 1: card activity on 2. Slot 2: Activity on 1. Slot 3: Activity on 2. Slot |
| STATE | state | Event 0/1: 0: card removed 1: card inserted Event 2/3: 0: pause or rest 1: standby time 2: work time 3: steering time |
| EVENTID | unique hash of booking |
Example output
Ausgabe in CSV
"DATE";"VEHICLE";"IGNITION";"LAT";"LON";"KEY";"EVENTTYPE";"STATE","EVENTID"
"2020-03-01T02:25:04+01:00";"YF1234";1;51.04;13.6;"DF47110815123000";1;0;"CF1C6C0DA98DC17B48B7C4C7DD3F0EE428EF9A61"
"2020-03-01T02:25:24+01:00";"YF1234";0;51.04;13.6;"DF47110815123000";3;1;"EF8F2B94F43228F8F6151D050413E5D9BEFBDE96"
Example call
Request in CSV format
https://map.yellowfox.de/rti/get_d8_bookings.php?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&start=20200302000000&end=20200305235959&format=CSV