Table of Contents

Get table rows

To get specified quantity of rows from a report table, use the command report/get_result_rows:

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

:!: Attention! Current command returns rows as array regardless their nesting level.

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

Parameters

Name Description
tableIndex index of report table
indexFrom index of first requested row
indexTo index of last requested row

Response

[
	{
		"n":<uint>,	/* row index (from 0) */
		"i1":<uint>,	/* number of first message in specified interval */
		"i2":<uint>,	/* number of last message in specified interval */
		"t1":<uint>,	/* time of first message in specified interval */
		"t2":<uint>,	/* time of last message in specified interval */
		"d":<int>,	/* quantity of rows with next nesting level */
		"c":[		/* cells array */
			<text>,		/* text value of cell */
			{		/* or object */
				"t":<text>,	/* cell value */
				"v":<double>,	/* исходное значение ячейки */
				"y":<double>,	/* latitude */
				"x":<double>	/* longitude */
			}			
		]
	}
]
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2024 Gurtam