listRows
HTTP Request
Path parameters
tableReference
Query parameters
format
The response format. Either csv
, jsonl
, or arrow
. Defaults to jsonl
for the JSON-lines format.
selectedVariables
Optional. A comma separated list of the variables to return, case insensitive. The order of variables in this list will determine the order of values in the response.
If not specified, all variables belonging to the table will be returned.
maxResults
Optional. Maximum number of rows to return.
Authorization
Data access to the table is required. If a table's data is not public, your access token must have one of the following scopes:
data.data
data.edit
Learn more about authorization.
Request body
The request body must be empty.
Response body
The response is returned in the JSON Lines format, with each row represented as an object of key:value pairs.
Please note the following regarding response data formats:
Date variables are formatted as
YYYY-MM-DD
DateTime variables are formatted at
YYYY-MM-DD HH:MM:SS[.DDDDDD]
Time variables are formatted as
HH:MM:SS[.DDDDDD]
Geography variables are formatted as well-known text (WKT)
Last updated
Was this helpful?