get_result_rows

The get_result_rows function is used to get a specified quantity of rows from a report table.

Copied!
svc=report/get_result_rows&params={"tableIndex":<uint>,
				   				   "indexFrom":<uint>,
								   "indexTo":<uint>}

The request returns the rows as an array, regardless of their nesting level.

Parameters

NameDescription

tableIndex

The index of the report table.

indexFrom

The index of the first requested row.

indexTo

The index of the last requested row.

Returned result

Copied!
[
	{
		"n":<uint>,	/* row index (from 0) */
		"i1":<uint>,	/* the number of the first message in the specified interval */
		"i2":<uint>,	/* the number of the last message in the specified interval */
		"t1":<uint>,	/* the time of the first message in the specified interval */
		"t2":<uint>,	/* the time of the last message in the specified interval */
		"d":<int>,	/* the quantity of rows with the next nesting level */
		"c":[		/* cells array */
			{		/* common cell type */
				"t":"<text>",		/* cell value */
				"y":<double>,	/* latitude */
				"x":<double>,	/* longitude */
				"v":<double> /* only for the date/time stamp cell values */
			},
			{	/* cell type: video or image */
				"t":"<text>", /* cell value text */
				"j":<JSON>, /* cell value in a JSON format */ 
				"v":<double>, /* cell value */ 
				"vt":<int> /* cell value type */ 
			},
			...
		]
	}
]

The value types are described here.

Possible error codes:

CodeDescription

6

Failed to fetch the user.

5

Failed to fetch the report result.

4

Wrong input parameters.

Download PDF file
Download Word document

See also