Get list of table types
To get the list of tables which can be included in reports, use the command report/get_report_tables:
svc=report/get_report_tables¶ms={}
Response
[
{
"id":<uint>, /* table ID */
"n":<text>, /* system table name */
"l":<text>, /* default table name */
"t":<text>, /* table type */
"ct":<text>, /* type of template in which this table can be used */
"pt":<text>, /* text parameters */
"gt":<text>, /* advanced grouping settings */
"col":[ /* array of columns */
{
"n":<text>, /* system column name */
"l":<text>, /* default column name */
"sl":<text>, /* list of column headers (if it is a statistics table) */
"t":<text>, /* column type */
"f":<uint> /* column flags (see below) */
}
]
}
]
Report template types are described in the chapter Get templates data.
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 |
Values for "pt"-param
| Value | Description |
| geozones | Geozones/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 | Thefts |
| duration_format | Furation format |
| geozones_ex | Extended geozones/units |
| username | Username mask |
| route_points | Route points |
| event_mask | Events mask |
| rides | Rides, applicable for “Unit”-“Unfinished rides”, “Unit group”-“Rides” |
| fields_config | Fields type, applicable for “Custom fields” tables |
| units | Units, applicable for “Maneuvers” tables |
| interval | trace interval in minutes, applicable for “Unit” -“Sensor tracing” |
| group_zones_pass | “Consider group as a whole” option is available, applicable for “Unit group”-“Non-visited geofences” |
| routes | applicable for “Routes” tables |
| last_location | “Consider report interval” option is available, applicable for “Unit latest data” table |
| hide_total | “Total” checkbox is hidden for that table |
| groupitem | “Group itself” option is available, applicable for “Unit group” –> “Log” and “Custom Fields” tables |
| noschedule | No “Time limitation” option available, applicable for “Summary” and “Latest unit data” tables |