Shows all form data received by selected vehicles during a defined date range.

Description

GET get_custom_form_data.php?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&form=FORM_NAME&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS

Parameters


Parameter
Description
Type
Note
Mandatory
companyRTI company keystring
yes
vehicleRTI vehicle keystringOne of vehicle, group or import must be defined!yes
groupRTI group keystringOne of vehicle, group or import must be defined!yes
import

RTI import key (all vehicles)

stringOne of vehicle, group or import must be defined!yes
startDatum ab dem alle Formulardaten zurückgegeben werdenstringFormat: YYYYMMDDHHMMSSyes
endDatum bis zu dem alle Formulardaten zurückgegeben werdenstringFormat: YYYYMMDDHHMMSSyes
formthe form namestringPossible to define form or custorder as parameter. Returns all if not given.no
custorderUser defined order numberstringPossible to define form or custorder as parameter. Returns all if not given.no
outputSelection of output formatstring

The output format. Possible values:

  • csv
  • json
  • json_v2

If nothing is set, the data will be returned as csv. The formats csv and json can only return up to 10 fields per form. The format json_v2 should therefore be favoured.

no
show_specReturns the form definition ( nothing -> no, 1 -> yes )integerA optional parameter, you can request the definition of the form. If you set the paramter with 1, you get the definition and if you send the request without the parameter it's not in the result.no
date_query(create, insert, complete)stringOptional. Create is default.no
complete_bufferhow long should a incomplete form be ignoredintegervalue in minutes. Has only affect if date_query = completeno

Return

A string is returned. 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

SeparatorSemicolon ( ; )
DelimiterDouble quote ( " )
Line break0x0D 0x0A (CarriageReturn LineFeed)
HeaderLine 1
EncodingUTF-8

Columns

Column
Description
DATEDate with format (YYYY-MM-DD HH:MM:SS)
VEHICLEVehicle sign
DRIVERDriver name (if avialable)
LATLatitude coordinate
LONLongitude coordinate
SATSatellite count
IGNITIONIgnition ON(1) or OFF(0)
ENTRY1Input field 1 value.
ENTRY2Input field 2 value.
ENTRY3Input field 3 value.
ENTRY4Input field 4 value.
ENTRY5Input field 5 value.
ENTRY6Input field 6 value.
ENTRY7Input field 7 value.
ENTRY8Input field 8 value.
ENTRY9Input field 9 value.
ENTRY10Input field 10 value.
KMCurrent mileage in kilometers of the vehicle at time of completing form
ORDERuser defined order number, if form is assigned to an order
FORMThe form name

/ if "show_desc" is part of request, the form definition in the result is in the "FORM" column

VEHICLE_COST_CENTER

cost center of the vehicle
DRIVER_MA_NUMBEREmployee number of the driver (only filled with activated ReinerSCT support)
RTI_IDENTRTI ident of the vehicle
TOURDATA

user defined number of tour/destination/shipment, if form is attached to a tour

Format as JSON like


"tourData": {"tour":"T1","dest":"T2","ship":"T3"}


Is null if not attached to tour.

PARENT_ID

If this is a nested form, this contains a hash to find the associated child forms. 

PARENT_RELATION

If this is part of a nestes form, this contains the hash of the assiciated parent form.

CUSTOM_ID

Unique identifier of this form data. Might be NULL for older data sets.

Example

CSV-Rückgabe-Format - ohne Parameter "show_desc":
"DATE";"VEHICLE";"DRIVER";"LAT";"LON";"SAT";"IGNITION";"ENTRY1";"ENTRY2";"ENTRY3";"ENTRY4";"ENTRY5";"ENTRY6";"ENTRY7";"ENTRY8";"ENTRY9";"ENTRY10";"KM";"ORDER";"FORM";"VEHICLE_COST_CENTER";"DRIVER_MA_NUMBER";"RTI_IDENT";"TOURDATA";"PARENT_ID";"PARENT_RELATION";"CUSTOM_ID" 
"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";"";"";"123456";"AUFTRAG1";"UNTERSCHRIFT";"Kostenstelle XYZ";"MA123456";"IDENT1";null;"22201eb2fd123df28156bc0c86e0aba2";"" ;"5"
CSV-Rückgabe-Format - mit Parameter "show_desc":
"DATE";"VEHICLE";"DRIVER";"LAT";"LON";"SAT";"IGNITION";"ENTRY1";"ENTRY2";"ENTRY3";"ENTRY4";"ENTRY5";"ENTRY6";"ENTRY7";"ENTRY8";"ENTRY9";"ENTRY10";"KM";"ORDER";"FORM";"VEHICLE_COST_CENTER";"DRIVER_MA_NUMBER";"RTI_IDENT";"TOURDATA";"PARENT_ID";"PARENT_RELATION";"CUSTOM_ID"  
"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";"";"";"123456";"AUFTRAG1";
"{""name"":""UNTERSCHRIFT"",""driver"":false,""entries"":[{""i"":1,""name"":""Ganzzahl"",""type"":""int"",""mand"":true},{""i"":2,""name"":""Datum"",""type"":""date"",""mand"":true},{""i"":3,""name"":""Zeit"",""type"":""time"",""mand"":true},{""i"":4,""name"":""Auswahlbox"",""type"":""sel"",""mand"":false,""spec"":""Eintrag1|Eintrag2|Eintrag8|Eintrag5""},{""i"":5,""name"":""Text"",""type"":""t10"",""mand"":false},{""i"":6,""name"":""Text"",""type"":""t30"",""mand"":false},{""i"":7,""name"":""Flie\u00dfkommazahl"",""type"":""flt"",""mand"":false},{""i"":8,""name"":""Frage"",""type"":""bool"",""mand"":true},{""i"":9,""name"":""Unterschrift"",""type"":""sig"",""mand"":false}]}";"Kostenstelle XYZ";"MA123456";"IDENT1";null;"22201eb2fd123df28156bc0c86e0aba2";"";"6" 

JSON Format

Example

JSON-Rückgabe-Format - ohne Parameter "show_desc":
[{
	"date":"2013-03-28 09:29:17",
	"customId": "7",
	"vehicle":"DD-AB 123",
	"driver":"Herr Fuchs",
	"lat":51.036687,
	"lon":13.599141,
	"sat":9,
	"ignition":0,
	"entry1":"111",
	"entry2":"22.12.89",
	"entry3":"11:33",
	"entry4":"Eintrag5",
	"entry5":"TEXT10",
	"entry6":"TEXT30",
	"entry7":"777.77",
	"entry8":"1",
	"entry9":"",
	"entry10":"",
	"km":"123456",
	"order":"AUFTRAG1",
	"tourData": null,
	"form":"UNTERSCHRIFT",
	"vehicleCostCenter":"Kostenstelle XYZ",
	"driverMaNumber":"MA123456",
	"rtiIdent":"Ident1",
 	"childForms":[
		{
		  	"date":"2013-03-28 08:29:17",
			"vehicle":"DD-AB 123",
			"driver":"Herr Fuchs",
			"lat":51.036687,
			"lon":13.599141,
			"sat":9,
			"ignition":0,
			"entry1":"Text",
			"entry2":"22.12.99",
			"entry3":"11:33",
			"km":"123456",
			"order":"",
			"tourData": null,
			"form":"Unterformular",
			"vehicleCostCenter":"Kostenstelle XYZ",
			"driverMaNumber":"MA123456",
			"rtiIdent":"Ident1"
		}
	]
 }] 
JSON-Rückgabe-Format - mit Parameter "show_desc":
[{
	"date":"2013-03-28 09:29:17",
	"customId": "8",
  	"vehicle":"DD-AB 123",
	"driver":"Herr Fuchs",
	"lat":51.036687,
	"lon":13.599141,
	"sat":9,
	"ignition":0,
	"entry1":"111",
	"entry2":"22.12.89",
	"entry3":"11:33",
	"entry4":"Eintrag5",
	"entry5":"TEXT10",
	"entry6":"TEXT30",
	"entry7":"777.77",
	"entry8":"1",
	"entry9":"",
	"entry10":"",
	"km":"123456",
	"order":"AUFTRAG1",
	"tourData": null,
	"form":{
	  "name": "UNTERSCHRIFT",
      "driver": false,
      "entries": [
        	{
          		"i": 1,
          		"name": "Ganzzahl",
          		"type": "int",
          		"mand": true
        	},
        	{
          		"i": 2,
          		"name": "Datum",
          		"type": "date",
          		"mand": true
        	},
        	{
          		"i": 3,
          		"name": "Zeit",
          		"type": "time",
          		"mand": true
        	},
        	{
          		"i": 4,
          		"name": "Auswahlbox",
          		"type": "sel",
          		"mand": false,
				"spec": "Eintrag1|Eintrag2|Eintrag8|Eintrag5" 
			},
        	{
          		"i": 5,
          		"name": "Text",
          		"type": "t10",
          		"mand": false
        	},
        	{
          		"i": 6,
          		"name": "Text",
          		"type": "t30",
          		"mand": false
        	},
        	{
          		"i": 7,
          		"name": "Fließkommazahl",
          		"type": "flt",
          		"mand": false
        	},
        	{
          		"i": 8,
          		"name": "Frage",
          		"type": "bool",
          		"mand": true
        	},
        	{
          		"i": 9,
          		"name": "Unterschrift",
          		"type": "sig",
          		"mand": false
        	}
		]
	},
	"vehicleCostCenter":"Kostenstelle XYZ",
	"driverMaNumber":"MA123456",
	"rtiIdent":"Ident1",
   	"childForms":[
		{
		  	"date":"2013-03-28 08:29:17",
			"customId": "7",
			"vehicle":"DD-AB 123",
			"driver":"Herr Fuchs",
			"lat":51.036687,
			"lon":13.599141,
			"sat":9,
			"ignition":0,
			"entry1":"Text",
			"entry2":"22.12.99",
			"entry3":"11:33",
			"km":"123456",
			"order":"",
			"tourData": null,
			"form":{
	  				"name": "Unterformular",
      				"driver": false,
      				"entries": [
        				{
          					"i": 1,
          					"name": "Textfeld",
          					"type": "t30",
          					"mand": true
        				},
        				{
          					"i": 2,
          					"name": "Datum",
          					"type": "date",
          					"mand": true
        				},
        				{
          					"i": 3,
          					"name": "Zeit",
          					"type": "time",
          					"mand": true
        				}
					]
			},
			"vehicleCostCenter":"Kostenstelle XYZ",
			"driverMaNumber":"MA123456",
			"rtiIdent":"Ident1"
		}
	] 
 }]

JSON_V2 Format

The parameters "form" and "custorder" are ignored if the output type "json_v2" is used.

Beispiel

JSON-Rückgabe-Format - mit Parameter "show_desc":
[{
	"date":"2019-11-26T10:51:39+01:00",
	"customId": "9",
	"vehicle":"DD-AB 123",
	"driver":"Herr Fuchs",
	"driverMaNumber":null,
	"lat":51.036687,
	"lon":13.599141,
	"textPos": "D-01723 Wilsdruff (Kesselsdorf), Am Wüsteberg 3",
	"sat":9,
	"ignition":0,
	"km":123456,
	"order":null,
	"orderMeta":null,
	"tourData": null,
	"vehicleCostCenter":null,
	"rtiIdent":null,
	"formName":"Beispielformular",
	"formDriverMandatory":true,
	"insertDate": "2020-07-22T16:08:00+02:00",
    "completeDate": "2020-07-22T16:08:00+02:00",
	"fields":
			[{
				"id":1,
				"name":"Fließkommazahl",
				"isMandatory":true,
				"type":"flt",
				"value":"111.11",
				"isIncomplete": false            
			},
			{
				"id":2,
				"name":"Text10",
				"isMandatory":true,
				"type":"t10",
				"value":"Text10",
				"isIncomplete": false
			},
			{
				"id":3,
				"name":"Text30",
				"isMandatory":true,
				"type":"t30",
				"value":"Text30",
				"isIncomplete": false
			},
			{
				"id":4,
				"name":"Text500",
				"isMandatory":true,
				"type":"t500",
				"value":"Text500",
				"isIncomplete": false
			},
			{	
				"id":5,
				"name":"Ganzzahl",
				"isMandatory":false,
				"type":"int",
				"value":"555",
				"isIncomplete": false
			},
			{
				"id":6,
				"name":"Bild",
				"isMandatory":false,
				"type":"img",
				"value":"48f5g3d04d177d95hs12182c39410a17e",
				"isIncomplete": false
			},
			{
				"id":7,
				"name":"Unterschrift",
				"isMandatory":false,
				"type":"sig",
				"value":"f7al12t4d177dfac0d2162f39410a17e",
				"isIncomplete": false
			},
			{
				"id":8,
				"name":"Auswahlbox",
				"isMandatory":false,
				"type":"sel",
				"value":"Eintrag 1",
				"selectionList":
								[
									"Eintrag 1",
									"Eintrag 2",
									"Eintrag 3",
									"Eintrag 4",
									"Eintrag 5",
									"Eintrag 6"
								]
			},
			{
				"id":9,
				"name":"Frage",
				"isMandatory":false,
				"type":"bool",
				"value":"1",
				"isIncomplete": false
			},
			{
				"id":10,
				"name":"Datum",
				"isMandatory":false,
				"type":"date",
				"value":"10.10.2010",
				"isIncomplete": false
			},
			{
				"id":11,
				"name":"Zeit",
				"isMandatory":false,
				"type":"time",
				"value":"11:11",
				"isIncomplete": false
			},
 			{
				"id":12,
				"name":"Formular",
				"isMandatory":false,
				"type":"nestedForm",
				"value":[ 
							{
 								"date":"2019-11-26T09:51:39+01:00",
								"customId": "7",        
								"vehicle":"DD-AB 123",
								"driver":"Herr Fuchs",
								"driverMaNumber":null,
								"lat":51.036687,
								"lon":13.599141,
								"textPos": "D-01723 Wilsdruff (Kesselsdorf), Am Wüsteberg 3",
								"sat":9,
								"ignition":0,
								"km":123456, 
								"order":"",
								"orderMeta":"",
								"tourData":null,
								"vehicleCostCenter":null,
								"rtiIdent":null,
								"formName":"Unterformular",
								"formDriverMandatory":false,
								"fields":[
											{
												"id":1,
												"name":"Textfeld",
												"isMandatory":false,
												"type":"t30",
												"value":"Text",
												"isIncomplete":false
											},
											{
												"id":2,
												"name":"Bild",
												"isMandatory":false,
												"type":"img",
												"value":null,
												"isIncomplete":false
											},
											{
												"id":3,
												"name":"Unterschrift",
												"isMandatory":false,
												"type":"sig",
												"value":null,
												"isIncomplete":false
											}
										],
								"insertDate":"2019-11-26T09:53:39+01:00",
								"completeDate":"2019-11-26T09:53:39+01:00"
							}
				],
				"isIncomplete": false
			}  ]}


Example calls

For all Vehicles at 2015-08-01 for form "Form Name"
https://map.yellowfox.de/rti/get_custom_form_data.php?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&form=Form+Name&start=20150801000000&end=20150801235959

https://map.yellowfox.de/rti/get_custom_form_data.php?company=COMPANY_RTIKEY&vehicle={"type":"car_ident","groupKey":"GROUP_RTIKEY","ident":"VEHICLE_IDENT"}&custorder=123456&start=20150801000000&end=20150831235959
For a single vehicle at august 2015 and custom order number 123456
https://map.yellowfox.de/rti/get_custom_form_data.php?company=COMPANY_RTIKEY&vehicle=VEHICLE_RTIKEY&custorder=123456&start=20150801000000&end=20150831235959




  • No labels