get_result_subrows

The get_result_subrows function is used to get nested rows of the next level from a report table.

Copied!
svc=report/get_result_subrows&params={"tableIndex":<uint>,
				      				  "rowIndex":<uint>}

The request allows receiving subrows up to the second level only. If you need to get more nested rows, use the report/select_result_rows request.

Parameters

NameDescription

tableIndex

Table index.

rowIndex

Row index.

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 JSON format */
				"v":<double>, /* cell value */
				"vt":<int> /* cell value type */
			},	
		]
	}
]

If the specified row doesn’t contain any nested rows, the returned result is:

Copied!
{
	"error":0
}

Possible error codes:

CodeDescription

6

Failed to fetch the user.

5

Failed to fetch the report result.

4Wrong input parameters.
Download PDF file
Download Word document

See also