Versions Compared

Old Version 27

changes.mady.by.user YellowFox R&D

Saved on

compared with

New Version Current

changes.mady.by.user YellowFox R&D

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Sv translation
languageen


Info
titlecompatibility

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

Status
colourGreen
titleGET
 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 string. In case of error it returns "ERROR:Description".

JSON format

return a string as json

example

Example output

Code Block
languagejs
titlereturn 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

Code Block
titleAusgabe 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

Code Block
title 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