listRows

HTTP Request

GET /tables/:tableReference/rows

Path parameters

Parameter
tableReference	A qualified reference to the table. See referencing resources for more information.

Query parameters

Parameter
format	The response format. Either csv or ndjson. If no format is provided, the response will be returned as an ndjson array per row.
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.

This endpoint extends the general API structure.

Authorization

This endpoint is accessible without authorization for tables which are public and under 100MB. However, certain rate limits may be enforced (and may change in the future) for unauthenticated users – we still recommend providing authorization information in the request header whenever possible.

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

?format=ndjson

The response is returned in the JSON Lines format, with each row represented as an array of values on a single line. The order of the values in each row is determined by the selectedVariables query parameter, or the otherwise the order of the variables in the table.

// e.g.: ...table_ref/rows?selectedVariables=id,date,decimal,text
["1","2012-01-01","4.2","Some text"]
["2","2012-02-02","3.14","Some other text"]
["3", ...]

Please note the following regarding response data formats:

• All numeric values will be encoded as strings in order to preserve precision.

• 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)

?format=csv

The response is returned as a comma-separated file.

// e.g.: table_ref/rows?format=csv&selectedVariables=id,date,decimal,text
"1","2012-01-01","4.2","Some text"
"2","2012-02-02","3.14","Some other text"
"3", ...

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)