table-export

Export table rows as a CSV or Excel file

Download a table's rows as a file. Two scopes: send sorts/where/column_ids to export what the grid is currently showing, or record_ids to export a specific row selection. The two are mutually exclusive.

format picks the file, and it changes how values are written. A CSV holds everything as text: timestamps in ISO 8601, lists and objects as JSON, so the file round-trips back through an import. Free-text cells are neutralised against spreadsheet formula injection; numbers are not, so they stay summable.

An .xlsx keeps native types instead, so a number stays summable, a date sorts as a date and a checkbox is a real boolean. Nothing needs neutralising there, because a string cell is never evaluated as a formula.

A CSV streams synchronously in keyset pages, so a large export starts downloading immediately. A workbook is a zip and cannot be streamed, so it is built in full before the response begins.

post/tables/{table_id}/export/

Request

  • Base URL: https://api.getoneprofile.ai (the document declares no server; this is the origin it was published from)
  • URL: https://api.getoneprofile.ai/tables/{table_id}/export/
  • Auth: one of:
    • API key in header X-API-Key
    • HTTP bearer

Path parameters

table_idstring uuid required

Request body

column_idsstring[] nullable

Export these columns, in this order. Omit for every column, in the table's own column order.

format'csv' | 'xlsx'

The file a table export is downloaded as.

The two differ in more than their extension. A CSV is text, so every value becomes a string and free text is defanged against a spreadsheet reading a leading "=" as a formula. A workbook keeps native types, so a number stays summable and a date sorts as a date, and no defanging is needed because a string cell is never evaluated.

record_idsstring[] nullable

Export exactly these rows, in display order. Mutually exclusive with sorts and where.

Response

The table as a CSV or Excel file.

Changes

No recorded changes to this operation across all 1 revision of this API.