get_report_tables

The get_report_tables function is used to get the list of tables that can be included in the reports.

Copied!

svc=report/get_report_tables&params={}

Returned result

Copied!

[
	{
		"id":<uint>,		/* table ID */
		"n":"<text>",			/* system table name */
		"l":"<text>",			/* default table name */
		"t":"<text>",			/* table type */
		"ct":"<text>",		/* type of the template in which this table can be used */
		"pt":"<text>",		/* text parameters */
		"gt":"<text>",		/* advanced grouping settings */
		"col":[				/* the array of columns */
			{
				"n":"<text>",		/* system column name */
				"l":"<text>",		/* default column name */
				"sl":"<text>",	/* the list of column headers (if it is a statistics table) */
				"t":"<text>",		/* column type */
				"f":<uint>		/* column flags (see below) */
			}
		]
	}
]

The types of report templates are described on the get_report_data page.

Column flags:

Flag	Description
0x01	Show as table column.
0x02	Show as statistics column.
0x04	Show as global switcher.
0x08	Show as column with position data.
0x10	Show as chart axis.

The values of the “pt” parameter:

Value	Description
geozones	Geofences/Units.
unfinished_ival	Unfinished interval.
duration	Duration.
mileage	Mileage.
base_eh_sensor	Engine hours sensor.
engine_hours	Engine hours.
speed	Speed.
trips	Trips.
stops	Stops.
parkings	Parkings.
sensors	Sensors.
sensor_name	Sensor mask.
driver	Driver.
trailer	Trailer.
fillings	Fillings.
thefts	Fuel drains.
duration_format	Duration format.
geozones_ex	Extended geofences/units.
username	Username mask.
route_points	Route points.
event_mask	Event mask.
rides	Rides, applicable for the Unit and Rides tables.
fields_config	Field type, applicable for the Custom fields tables.
units	Units, applicable for the Manoeuvres table.
interval	Tracing interval in minutes, applicable for the Unit → Sensor tracing table.
group_zones_pass	The Consider group as a whole option is available. Applicable for the Unit group → Non-visited geofences table.
routes	Applicable for the Route type tables.
last_location	The Consider report interval option is available. Applicable for the Unit latest data table.
hide_total	The Total checkbox is hidden for that table.
groupitem	The Group itself option is available. Applicable for the Unit group → Log and Custom fields tables.
noschedule	No Time limitation option available. Applicable for the Summary and Latest unit data tables.
hide_driver_split	The Retrieve intervals checkbox is hidden in the driver filter.
account_tree	Account tree.
custom_fields_mask	Custom fields mask.
drv_activity	Driver activity.
movement_chronology	Movement chronology.
sensor_val	Sensor value.
timeout_sensor	Sensor timeout.
custom_sensor_name	Custom sensor name.
filter_notifications	Keep only messages with a notification text.

Possible error codes:

Code	Description
6	Undefined error.

get_report_tables

Returned result

See also