Tables
Export table
Export table data as CSV, XLSX, JSON, or a ZIP of images.
GET
/
v1
/
tables
/
{table_id}
/
export
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv
Path parameters
string
required
The unique identifier of the table.
Query parameters
string
required
Export format. One of:
csv, xlsx, json, images.string
Comma-separated list of column keys to include. Omit to export all columns.
Response
The response depends on the chosen format:| Format | Content-Type | Description |
|---|---|---|
csv | text/csv | Semicolon-delimited CSV file. |
xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | Excel spreadsheet. |
json | application/json | JSON array of row objects. |
images | application/zip | ZIP archive of all images from image columns, organized by row. |
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv
⌘I
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv