Showns all form data, recieved by the selected vehicles, for defined date range.
Description
get_custom_form_data.php?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&form=FORM_NAME&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS
Parameters
Parameter | Description | Type | Note | Required |
---|---|---|---|---|
company | RTI company key | string | yes | |
vehicle or | RTI vehicle key | string | Attention At least one of the parameters (vehicle, group or import) must be defined! | yes |
group or | RTI group key | string | ||
import | RTI import key (all vehicles) | string | ||
start | Datum ab dem alle Formulardaten zurückgegeben werden | string | Format: YYYYMMDDHHMMSS | yes |
end | Datum bis zu dem alle Formulardaten zurückgegeben werden | string | Format: YYYYMMDDHHMMSS | yes |
form | the form name | string | no | |
custorder | User defined order number | string | Attention If "custorder" is defined, the form parameter is ignored. |
Return
Returned data are in CSV format. On error "ERROR:Description" is returned.
CSV format
If the request is valid, the data are returned as CSV (Comma Separated Value) format. The first response line is always
the header, defining the column names. After it the personal data follows.
Meta informations
Separator | Semicolon ( ; ) |
---|---|
Delimiter | Double quote ( " ) |
Line break | 0x0D 0x0A (CarriageReturn LineFeed) |
Header | Line 1 |
Encoding | UTF-8 |
Columns
Column | Description |
---|---|
DATE | Date with format (YYYY-MM-DD HH:MM:SS) |
VEHICLE | Vehicle sign |
DRIVER | Driver name (if avialable) |
LAT | Latitude coordinate |
LON | Longitude coordinate |
SAT | Satellite count |
IGNITION | Ignition ON(1) or OFF(0) |
ENTRY1 | Input field 1 value. |
ENTRY2 | Input field 2 value. |
ENTRY3 | Input field 3 value. |
ENTRY4 | Input field 4 value. |
ENTRY5 | Input field 5 value. |
ENTRY6 | Input field 6 value. |
ENTRY7 | Input field 7 value. |
ENTRY8 | Input field 8 value. |
ENTRY9 | Input field 9 value. |
ENTRY10 | Input field 10 value. |
ORDER | user defined order number if form is assigned to an order |
FORM | The form name |
Response-Example
"DATE";"VEHICLE";"DRIVER";"LAT";"LON";"SAT";"IGNITION";"ENTRY1";"ENTRY2";"ENTRY3";"ENTRY4";"ENTRY5";"ENTRY6";"ENTRY7";"ENTRY8";"ENTRY9";"ENTRY10";"ORDER";"FORM" "2013-03-28 09:29:17";"DD-AB 123";"Herr Fuchs";"51.036687";"13.599141";"9";"0";"111";"22.12.89";"11:33";"Eintrag5";"TEXT10";"TEXT30";"777.77";"1";"";"";"AUFTRAG1";"UNTERSCHRIFT"