Rows
List rows
Retrieve a paginated list of rows from a table.
GET
/
v1
/
tables
/
{table_id}
/
rows
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
result = client.tables.rows("tbl_abc123", page=1, limit=50, sort_by="name")
for row in result["data"]:
print(row["data"]["name"], row["data"]["price"])
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/rows?page=1&limit=50&sort_by=name" \
-H "Authorization: Bearer lasso_..."
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}
Path parameters
string
required
The unique identifier of the table.
Query parameters
integer
default:"1"
Page number for pagination.
integer
default:"25"
Number of items per page (max 100).
string
Column key to sort by. Sorts by the value in
extracted_data for that column.string
default:"asc"
Sort direction:
asc or desc.Response
array
Show Row object
Show Row object
string
Unique row identifier.
integer
Position of the row in the table.
object
Extracted data keyed by column key.
string | null
Validation status.
object | null
Validation error details.
object | null
Per-column enhancement status.
boolean
Whether the row has been manually edited.
string
ISO 8601 timestamp.
object
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
result = client.tables.rows("tbl_abc123", page=1, limit=50, sort_by="name")
for row in result["data"]:
print(row["data"]["name"], row["data"]["price"])
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/rows?page=1&limit=50&sort_by=name" \
-H "Authorization: Bearer lasso_..."
The Python SDK has a
results_as_dataframe helper that fetches all rows and returns a pandas DataFrame:df = client.tables.results_as_dataframe("tbl_abc123")
print(df.head())
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}
⌘I
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
result = client.tables.rows("tbl_abc123", page=1, limit=50, sort_by="name")
for row in result["data"]:
print(row["data"]["name"], row["data"]["price"])
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/rows?page=1&limit=50&sort_by=name" \
-H "Authorization: Bearer lasso_..."
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}