68. Jbus Trip Report

Returns JBus trip report data and accumulated totals over a given period of time.

68.1 Request Data

Required Information
Name Description
action showopen
operation jbustrip
format xml
start epoch timestamp for start of report.
end epoch timestamp for end of report.
Optional Information
target Specific asset to report data for, rather than entire fleet. If specified then reqtype must be specified as well. See asset target for details.
reqtype Flag to identify the key being used to query. Acceptable values:
  • tag Key is a Zonar RFID tag number. In version 2 a type must also be specified.
  • exsid Key is the external system id.
  • vin Key is the Vehicle Identification Number (VIN).
  • dbid Key is the internal id number. This is the most reliable key to use.
  • fleet Key is the asset fleet number. In version 2 a type must also be specified.
type When using reqtype of tag or fleet this must also be specified in version 2. In version 1.x type Standard (0) is assumed. See asset types for more details.
Note: Value should be a string e.g. Standard or TRAILER

Data Returned

Returned information:
DTD:
<!ELEMENT jbustrip(trip*) >
<!ATTLIST jbustrip count CDATA>
<!ATTLIST jbustrip ver CDATA>
<!ELEMENT trip(asset, start, end, fuel, pto_fuel, idle_fuel, fuel_units, miles, mpg, engine_hours, pto_hours, totals)>
<!ELEMENT asset >
<!ATTLIST asset id CDATA>
<!ATTLIST asset fleet CDATA>
<!ATTLIST asset exsid CDATA>
<!ELEMENT start (#PCDATA) #REQUIRED>
<!ELEMENT end (#PCDATA) #REQUIRED>
<!ELEMENT fuel (#PCDATA) #REQUIRED>
<!ELEMENT pto_fuel (#PCDATA) #REQUIRED>
<!ELEMENT idle_fuel (#PCDATA) #REQUIRED>
<!ELEMENT fuel_units (#PCDATA) #REQUIRED>
<!ELEMENT miles (#PCDATA) #REQUIRED>
<!ELEMENT mpg (#PCDATA) #REQUIRED>
<!ELEMENT engine_hours (#PCDATA) #REQUIRED>
<!ELEMENT pto_hours (#PCDATA) #REQUIRED>
<!ELEMENT totals(fuel_total, idle_fuel_total, pto_fuel_total, odometer, odometer_units, engine_hours_total, pto_hours_total)>
<!ELEMENT fuel_total (#PCDATA) #REQUIRED>
<!ELEMENT idle_fuel_total (#PCDATA) #REQUIRED>
<!ELEMENT pto_fuel_total (#PCDATA) #REQUIRED>
<!ELEMENT odometer (#PCDATA) #REQUIRED>
<!ELEMENT odometer_units (#PCDATA) #REQUIRED>
<!ELEMENT engine_hours_total (#PCDATA) #REQUIRED>
<!ELEMENT pto_hours_total (#PCDATA) #REQUIRED>

Example Request:
http://development.zonarsystems.net/interface.php?action=showopen&operation=jbustrip&format=xml&start=1288942257&end=1289374257

Example Success Reply XML