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

ParameterDescriptionTypeNoteMandatory
companyRTI company keystring
yes
importRTI import keystringeither import, vehicle or group Parameter(yes)
vehicleRTI vehicle keystringeither import, vehicle or group Parameter(yes)
groupRTI group keystringeither import, vehicle or group Parameteryes
startStartzeitpunkt der Ausgabestringthe requested persiod may not exceed 31 daysyes
endEndzeitpunkt der Ausgabestringthe requested persiod may not exceed 31 daysyes
formatreturn formatstringsupport
  • csv
  • json
yes

Return

Return a stringIn 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

SeparatorSemicolon ( ; )
DelimiterDouble quote
Line break0x0D 0x0A (CarriageReturn LineFeed)
HeaderLine1
CodingWindows-1252

CSV Columns

Column

Description



 
DATEdate and time of digitachoformat ISO 8601
VEHICLE

user defined RTI vehicle ident

(if the user define no vehicle ident, we return the vehicle sign)


IGNITIONignition state by digitacho

1: ignition on

0: ignition off

LATlatitude

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

STATEstate

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
  • No labels