Execute report

To execute a report, use the command report/exec_report:

svc=report/exec_report&params={"reportResourceId":<long>,
			       "reportTemplateId":<long>,
			       "reportObjectId":<long>,
			       "reportObjectSecId":<long>,
			       "reportObjectIdList":[<uint>, ...]},
			       "interval":{
			       		"from":<uint>,
			       		"to":<uint>,
			       		"flags":<uint>
			       },
			       "reportTemplate":<object>}

Attention! There can be only one report in a session at the same time. Therefore if a session already has some report results, they must be cleared before executing a new report - with the command report/cleanup_result. Also current request can't be executed simultaneously with following requests:

• report/export_result,
• report/get_result_chart,
• report/get_result_map,
• messages/load_interval,
• render/create_messages_layer,
• unit/get_trips,
• resource/get_driver_bindings,
• resource/get_trailer_bindings,
• all requests from chapter Export and import,
• account/get_account_history.

You can find an example of this request in the sample Reports.

reportResourceId is required parameter, report will be executed as creator of this resource if reportTemplateId equals 0.

Interval flags:

{
	"reportResult":{	        	/* report execution result */
		"msgsRendered":<int>,		/* messages loaded: 0 - no, 1 - yes */
		"stats":[			/* array of statistics parameters */
			[<text>,<text>]		/* [parameter name, value] */
		],
        "tables":[          /* array of tables */
            {
                    "name":<text>,      /* table type */
                    "label":<text>,     /* name */
                    "grouping": {
                    "type":<text>        /* grouping type */ 
                      },
                   "flags":<uint>,      /* table flags (see below) */
                    "rows":<uint>,      /* quantity of lines */
                    "level":<uint>,     /* max level in table */
                    "columns":<uint>,   /* columns count */
                    "header":[<text> ], /* array of table headers */
                    "total":[           /* total */
                    <text>          /* array of cells */
                    ],
                   "header_type" [<text>],     /*  Array of table headers types */
                   "totalRaw" [                /* Array of values for the string "Total" */
                   {         
                    "v":<double>,   /* Original cell value */
                    "vt":<double>,  /* Value type */
                    }
                    ...
                    ] 
                    }
             ],
 
		"attachments":[			/* attachments array (charts, photos) */
                        {            /* for charts */
                            "name":<text>,      /* name */
                            "type":<text>,      /* type: chart, photo */
                            "datasets":[<text>] /* array with names of chart's curved lines */
                            "axis_x": <text>, /* Name for 'X' axis */
                            "flags": <uint>, /* Axis format, description below*/ 
                            "p":<text>, /* Chart settings */
                        },
			{		/* for photo and video */
				"name":<text>,	/* name and following parameters separated by ";" */
				"ftm":<text>,	/* formatted date */
				"uid":<text>,	/* unit ID */	
				"tm":<text>,	/* UNIX time */
				"idx":<text>,	/* index of the same-type attachments registered simultaneously */
				"lat":<text>,	/* latitude */
				"lon":<text>,	/* longitude */
				"type":<text>	/* attachment type */
			}
		]
	},
	"reportLayer":{			/* graphic layer */
		"name":<text>,			/* layer name */
		"bounds":[
			<double>,			/* minimal latitude */
			<double>,			/* minimal longitude */
			<double>,			/* maximal latitude */
			<double>			/* maximal longitude */
		]
	},
	"layerCount":<uint>	/* quantity of layers to be merged in report layer */
}

To get all available types of tables, make the request report/get_report_tables.

Table flags:

Chart flags: