Get all rows of a table [BETA]
List all rows in a given table, including the header row (if exists), as comma-delimited values.
Methods
GET /tables/{owner}/{datasetid}/{tableid}/rows
Path parameters
| Parameter | Description | Data Type |
|---|---|---|
| owner | Dataset owner username. Included in data.world dataset URL path, after domain. For example, jonloyens in https://data.world/jonloyens/an-intro-to-dataworld-dataset |
string |
| datasetid | Dataset id. Included in data.world dataset URL, after owner's username. For example, an-intro-to-dataworld-dataset in https://data.world/jonloyens/an-intro-to-dataworld-dataset |
string |
| tableid | Table id. Retrieve acceptable values via the GET: /tables method | string |
Response
Response schema (Status 200)
Returns a comma-delimited list of the table rows.
Errors
| HTTP Status Code | Reason | Solution |
|---|---|---|
| 400 | Bad request. | Check syntax and URIs. |
| 401 | Unauthorized | Verify credentials / API key |
| 403 | Forbidden | |
| 404 | Not found. | |
| 422 | Bad request. | Check syntax and URIs. |
| 500 | Server error. |
Error Response Model:
{
"code": 0,
"message": "string",
"details": "string"
}
EXAMPLE
Request URL:
https://query.data.world/tables/jonloyens/an-intro-to-dataworld-dataset/datadotworldbballteam/rows
cURL:
$ curl -X GET \
https://query.data.world/tables/jonloyens/an-intro-to-dataworld-dataset/datadotworldbballteam/rows \
-H 'accept: text/csv' \
-H 'authorization: Bearer <API_TOKEN>'
Response Body:
Name,Height,Handedness
Jon,"6'5""",Right
Rob,"6'7.5""",Left
Sharon,"6'3""",Right
Alex,"6'2""",Right
Rebecca,7',Right
Ariane,"5'8""",Left
Bryon,7',Right
Brett,6',Right
Matt,"5'5""",Right