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>,
			       "interval":{
			       		"from":<uint>,
			       		"to":<uint>,
			       		"flags":<uint>
			       },
			       "tzOffset":<uint>,
			       "lang":<text>}

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.

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

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 */
			{
				"nm":<text>,		/* table type */
				"text":<text>,		/* name */
				"f":<uint>,		/* table flags (see below) */
				"r":<uint>,		/* quantity of lines */
				"c":<uint>,		/* columns count */
				"h":[<text>],		/* array of table headers */
				"t":[<text>]		/* total */
			}
		],
		"attachments":[			/* attachments array (charts, photos) */
			{
				"n":<text>,		/* name */
				"t":<text>		/* type: chart, photo */
			}
		]
	},
	"reportLayer":{			/* graphic layer */
		"name":<text>,			/* layer name */
		"bounds":[
			<double>,			/* minimal latitude */
			<double>,			/* minimal longitude */
			<double>,			/* maximal latitude */
			<double>			/* maximal longitude */
		],
		"units": [{		/* units */
			"id": <long>,		/* unit ID */
			"msgs":{		/* messages */
				"count":<uint>,		/* messages count */
				"first":{		/* first message from interval */
					"time":<uint>,		/* time */
					"lat":<double>,		/* latitude */
					"lon":<double>		/* longitude */
				},
				"last":{		/* last message of interval */
					"time":<uint>,		/* time */
					"lat":<double>,		/* latitude */
					"lon":<double>		/* longitude */
				}
			},
			"mileage":<double>,	/* mileage */
			"max_speed":<double>	/* maximal speed */
		}]
	},
	"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: