Manage data tables where extracted data is stored and organized.
Data tables serve as centralized storage for extracted data. All extractions created from the same extract template are stored in the same data table, providing a unified view of your data. Data tables are also used as sources when configuring loads to destinations.
Get a data table
Get detailed info about data table
path Parameters
data_table_idData Table ID
Get a data table › Responses
Get a Data Table
titleData Table title
freshnessData Table freshness date
datasource_nameData source name
report_typeReport type
data_classData class
workspaceWorkspace ID
sql_nameSQL name
auto_extract_new_accountsAuto extract new accounts
Fields object
Update a data table
Updates which fields (columns) of the data table are selected for delivery. selected_fields must contain the full list of field name values (as returned by the detail endpoint's fields[].name) that should be selected — any field not listed becomes deselected. Field selection is set at the data table level and affects all loads delivering this data table.
Unknown field names are ignored. Dimension fields cannot be deselected — omitting a dimension field from selected_fields returns 400. Fields the detail endpoint returns with can_edit: false are not meant to be toggled and should always be included in selected_fields.
path Parameters
data_table_idData Table ID
Update a data table › Request Body
selected_fieldsFull list of field name values that should be selected. Any field of the data table not listed becomes deselected.
Update a data table › Responses
Update a Data Table
titleData Table title
freshnessData Table freshness date
datasource_nameData source name
report_typeReport type
data_classData class
workspaceWorkspace ID
sql_nameSQL name
auto_extract_new_accountsAuto extract new accounts
Fields object