| [in] usn | The user-name that you need to use to authenticate on this interface. |
| [in] pwd | The password that you need to use to authenticate on this interface. |
| [out] errorMsg | If an error happpens this string contains the error message. In case an error has happened (this variable contains a valid non-empty string) then the return value will not contain any usable data, do not try to parse it as an xml. |
| [in] columns | String array of the requested columns. For the full list of supported columns please refer to the Database API Documentation. If a non-existing column is requested then that column will appear in the returned XML and every entry in that column will be an empty string. |
| [in] options | String parameter. This is currently unused and reserved for future versions of the API. Pass in an empty string. |
| return value |
If the errorMsg variable is null or empty then the returned string contains the
requested data in xml format. The xml has the following structure:
<?xml version="1.0\" encoding="utf-16\"?>
Please note this.
<root> <EX_HoS_DriverAvailableHours> <row DriverID="1" DriverName="driver1" VehicleID="3" VehicleName="vehicle3" TrailerNo="12345" ShippingDocNo="913" CarrierName="Carrier 1" GPRSConnected="False" ReadingsAreStale="1" DataTerminalConnected="" LatestDutyStartTime="2010-10-08 02:44:00Z" LatestDutyDurationMinutes="60" DutyStateID="4" DutyDescription="On Duty" CustomDutyStateID="" CustomDutyDescription="" Location="La Crosse, WI" Remarks="" DrivingTimeRemainingMinutes="150" DrivingDurationMinutes="0" DailyDutyDurationMinutes="600" WeeklyDutyDurationMinutes="3600" AdvisorSleeperBerthProvision1="" AdvisorSleeperBerthProvision2="" AdvisorDailyDutyReset="0" AdvisorWeeklyCycleReset="2040" ServerTimeStamp="2012-12-21 11:16:13Z" /> <row DriverID="2" DriverName="driver2" VehicleID="4" VehicleName="vehicle4" TrailerNo="12346" ShippingDocNo="914" CarrierName="Carrier 1" GPRSConnected="False" ReadingsAreStale="1" DataTerminalConnected="" LatestDutyStartTime="2011-02-15 09:36:00Z" LatestDutyDurationMinutes="120" DutyStateID="4" DutyDescription="On Duty" CustomDutyStateID="" CustomDutyDescription="" Location="Colombia, WI" Remarks="" DrivingTimeRemainingMinutes="300" DrivingDurationMinutes="0" DailyDutyDurationMinutes="600" WeeklyDutyDurationMinutes="3600" AdvisorSleeperBerthProvision1="" AdvisorSleeperBerthProvision2="" AdvisorDailyDutyReset="0" AdvisorWeeklyCycleReset="2040" ServerTimeStamp="2012-12-21 11:16:13Z" /> </EX_HoS_DriverAvailableHours> </root> |
Please see this page.