> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qobra.co/llms.txt
> Use this file to discover all available pages before exploring further.

# list_data_tables

List your company's data tables and their fields, with filters and pagination.

Only local and integration-synced tables are returned. Each table carries its
source, its public-API key, the integration it syncs from for integration
tables, and its fields. Every field carries its public-API key in
`<origin>.<key>` form, its data type and — for a link field pointing at
another table — that table's id and name.

You only see the data tables you have access to. Rows are ordered alphabetically
by table name (A→Z).

## Parameters

<Accordion title="Body" defaultOpen>
  <ParamField body="search" type="string">
    Filter matched against the table name (case- and accent-insensitive
    substring) or, when it is a valid ObjectId, against the table id.
  </ParamField>

  <ParamField body="source" type="string">
    Filter restricting results to local or integration tables. Omit to return
    both kinds.
  </ParamField>

  <ParamField body="integration" type="string">
    Filter restricting results to tables synced from a matching integration.
    Matched against the integration name or type (case- and accent-insensitive
    substring) or, when it is a valid ObjectId, against the integration id.
    Local tables never match, so this filter excludes them.
  </ParamField>

  <ParamField body="limit" type="integer">
    Page size, between 1 and 250. Defaults to 50.
  </ParamField>

  <ParamField body="offset" type="integer">
    Row offset into the result set — the number of rows to skip before this
    page. Pass the next\_offset returned by the previous call, or None for the
    first page.
  </ParamField>
</Accordion>

## Response

<Accordion title="Body" defaultOpen>
  <ResponseField name="data_tables" type="object[]">
    <Expandable title="object properties">
      <ResponseField name="id" type="string" />

      <ResponseField name="resource_url" type="string">
        Deep link to open this data table in the Qobra web app.
      </ResponseField>

      <ResponseField name="name" type="string" />

      <ResponseField name="api_key" type="string" />

      <ResponseField name="source" type="string" />

      <ResponseField name="integration" type="object">
        <Expandable title="object properties">
          <ResponseField name="id" type="string" />

          <ResponseField name="name" type="string" />

          <ResponseField name="integration_type" type="string">
            One of: `kombo`, `salesforce`, `pipedrive`, `microsoft_dynamics`,
            `hubspot`, `odoo`, `zoho`, `attio`, `postgresql`, `gcp-postgresql`,
            `snowflake`, `snowflake-keys`, `redshift`, `microsoft-azure-sql`,
            `microsoft-azure-synapse`, `bigquery`, `s3`, `sftp`, `netsuite`,
            `public_api`.
          </ResponseField>
        </Expandable>
      </ResponseField>

      <ResponseField name="fields" type="object[]">
        <Expandable title="object properties">
          <ResponseField name="name" type="string" />

          <ResponseField name="api_key" type="string">
            Stable technical key for this field in Qobra's public API (use it as
            a durable reference; the display name can change).
          </ResponseField>

          <ResponseField name="type" type="string">
            Field data type: amount, percentage, float, string, bool, date,
            picklist, multipicklist, user, or object (a reference to another
            data table — see linked\_to). One of: `float`, `amount`,
            `percentage`, `string`, `picklist`, `multipicklist`, `bool`, `date`,
            `user`, `object`, `group`, `record_status`.
          </ResponseField>

          <ResponseField name="linked_to" type="object">
            When type is object, the table this field points to; null otherwise.

            <Expandable title="object properties">
              <ResponseField name="id" type="string" />

              <ResponseField name="name" type="string" />
            </Expandable>
          </ResponseField>
        </Expandable>
      </ResponseField>
    </Expandable>
  </ResponseField>

  <ResponseField name="next_offset" type="integer" />
</Accordion>