---
title: "PATCH /data-tables/{data_table_id}"
method: PATCH
path: "/data-tables/{data_table_id}"
tags: ["data-tables"]
---

# PATCH /data-tables/{data_table_id}

`PATCH /data-tables/{data_table_id}`

This class exists to have a standard rate limit across all authenticated API endpoints

## Path parameters

- `data_table_id` string, uuid, required

## Request body

- PatchedSourceDataTable
  - `id` string, uuid
  - `name` string
  - `active` boolean
  - `settings` object
  - `created_at` string, date-time
  - `connection` Connection
    - `id` string, uuid, required
    - `active` boolean, required
    - `type` string, nullable, required — Return the category of the associated Integration model for backwards compatibility Returns: The integration category (See Integration.CATEGORIES)
    - `friendly_source` string, required
    - `integration` Integration, required
      - `id` integer, required
      - `source` 'METABASE' | 'QUICKBOOKS' | 'XERO' | 'NETSUITE' | 'SALESFORCE' | 'SAGE_INTACCT' | 'RILLET' | 'CAMPFIRE' | 'CHARTHOP' | 'RIPPLING' | 'GOOGLE' | 'OKTA' | 'BOOMI' | 'SAML' | 'OPEN_EXCHANGE_RATES' | 'NETSUITE_RATES' | 'MERGE', required — * `METABASE` - Metabase * `QUICKBOOKS` - QuickBooks * `XERO` - Xero * `NETSUITE` - NetSuite * `SALESFORCE` - Salesforce * `SAGE_INTACCT` - Sage Intacct * `RILLET` - Rillet * `CAMPFIRE` - Campfire * `CHARTHOP` - ChartHop * `RIPPLING` - Rippling * `GOOGLE` - Google SSO * `OKTA` - Okta (OIDC) * `BOOMI` - Boomi * `SAML` - SAML * `OPEN_EXCHANGE_RATES` - Open Exchange Rates * `NETSUITE_RATES` - NetSuite Saved Search * `MERGE` - Cube Universal Connect
      - `category` 'BI' | 'GL' | 'HRIS' | 'SSO' | 'CRM' | 'OTHER' | 'UAP', required — * `BI` - Business Intelligence * `GL` - General Ledger * `HRIS` - Human Resource Information Service * `SSO` - Single Sign On * `CRM` - Customer Relationship Management * `OTHER` - Other * `UAP` - Unified API Platform
      - `name` string, required
      - `logo_url` string, nullable, required
    - `settings` object, required
    - `metadata` object, required
  - `type` 'AD_HOC' | 'ERP_CONNECTION' | 'GENERIC' | 'EMPLOYEE_ROSTER' | 'HRIS' — * `AD_HOC` - Ad Hoc * `ERP_CONNECTION` - ERP Connection * `GENERIC` - Generic * `EMPLOYEE_ROSTER` - Employee Roster * `HRIS` - HRIS Connection
  - `type_friendly` string
  - `last_import` object
  - `last_successful_import` object
  - `source_type` string — Returns the human-friendly category of the connection's Integration, if the table has a connection. Otherwise, returns 'Data Table'. Returns: The human-friendly source category
  - `mapping_data` object
  - `description` string

## Response `200`

- SourceDataTable
  - `id` string, uuid, required
  - `name` string, required
  - `active` boolean, required
  - `settings` object, required
  - `created_at` string, date-time, required
  - `connection` Connection, required
    - `id` string, uuid, required
    - `active` boolean, required
    - `type` string, nullable, required — Return the category of the associated Integration model for backwards compatibility Returns: The integration category (See Integration.CATEGORIES)
    - `friendly_source` string, required
    - `integration` Integration, required
      - `id` integer, required
      - `source` 'METABASE' | 'QUICKBOOKS' | 'XERO' | 'NETSUITE' | 'SALESFORCE' | 'SAGE_INTACCT' | 'RILLET' | 'CAMPFIRE' | 'CHARTHOP' | 'RIPPLING' | 'GOOGLE' | 'OKTA' | 'BOOMI' | 'SAML' | 'OPEN_EXCHANGE_RATES' | 'NETSUITE_RATES' | 'MERGE', required — * `METABASE` - Metabase * `QUICKBOOKS` - QuickBooks * `XERO` - Xero * `NETSUITE` - NetSuite * `SALESFORCE` - Salesforce * `SAGE_INTACCT` - Sage Intacct * `RILLET` - Rillet * `CAMPFIRE` - Campfire * `CHARTHOP` - ChartHop * `RIPPLING` - Rippling * `GOOGLE` - Google SSO * `OKTA` - Okta (OIDC) * `BOOMI` - Boomi * `SAML` - SAML * `OPEN_EXCHANGE_RATES` - Open Exchange Rates * `NETSUITE_RATES` - NetSuite Saved Search * `MERGE` - Cube Universal Connect
      - `category` 'BI' | 'GL' | 'HRIS' | 'SSO' | 'CRM' | 'OTHER' | 'UAP', required — * `BI` - Business Intelligence * `GL` - General Ledger * `HRIS` - Human Resource Information Service * `SSO` - Single Sign On * `CRM` - Customer Relationship Management * `OTHER` - Other * `UAP` - Unified API Platform
      - `name` string, required
      - `logo_url` string, nullable, required
    - `settings` object, required
    - `metadata` object, required
  - `type` 'AD_HOC' | 'ERP_CONNECTION' | 'GENERIC' | 'EMPLOYEE_ROSTER' | 'HRIS', required — * `AD_HOC` - Ad Hoc * `ERP_CONNECTION` - ERP Connection * `GENERIC` - Generic * `EMPLOYEE_ROSTER` - Employee Roster * `HRIS` - HRIS Connection
  - `type_friendly` string, required
  - `last_import` object, required
  - `last_successful_import` object, required
  - `source_type` string, required — Returns the human-friendly category of the connection's Integration, if the table has a connection. Otherwise, returns 'Data Table'. Returns: The human-friendly source category
  - `mapping_data` object, required
  - `description` string

---

[API](https://skmtc.net/cubesoftware/apis/cube-api.md) · [All operations](https://skmtc.net/cubesoftware/apis/cube-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cubesoftware/cube-api/revisions/67d9f45bb99b/schema)