Retrieves paginated rows from a specific table in an extraction. This endpoint is useful for accessing large tables efficiently.
Usage Notes
- Use pagination to retrieve rows from large tables
- Row indexes are 0-based, meaning the first row has an index of 0
Request
The ID of the extraction.
The key of the table to retrieve rows from.
The number of rows to skip. Minimum value is 0.
The maximum number of rows to return. Minimum value is 1, maximum value is
1000.
Filter the rows to return:
- “all” - Return all rows (default)
- “valid” - Return only rows that pass all validations
- “error” - Return only rows that fail at least one validation
curl -X GET https://api.tableflow.com/v2/extractions/uT2bJNWN75YPU95r/tables/line_items/rows?offset=0&limit=100 \
-H "Authorization: Bearer YOUR_API_KEY"
Response
Pagination information.
Total number of rows in the table.
Offset for the next page of results. Will be null on the last page.
The applied filter (“all”, “valid”, or “error”).
Array of table rows.
Map of column keys to their cell values.
Map of column keys to arrays of validation issues.
Array of validation issues for the cell.
The validation that failed.
Severity of the validation issue (“error”, “warn”, “info”).
Error message describing the validation issue.
{
"pagination": {
"offset": 0,
"limit": 100,
"total": 3,
"next_offset": null,
"filter": "all"
},
"rows": [
{
"index": 0,
"values": {
"description": "Ergonomic Office Chair",
"quantity": "1",
"unit_price": "249.99",
"amount": "249.99"
},
"validations": {}
},
{
"index": 1,
"values": {
"description": "Wireless Keyboard",
"quantity": "2",
"unit_price": "59.95",
"amount": "119.90"
},
"validations": {}
},
{
"index": 2,
"values": {
"description": "27-inch Monitor",
"quantity": "2",
"unit_price": "329.99",
"amount": "659.98"
},
"validations": {}
}
]
}
Error Responses
Error message describing what went wrong.