> ## 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.

# get_data_table

Get one data table's full field schema, resolved by name or id.

Returns the same shape as a `list_data_tables` row — source, public-API key,
integration and fields — plus, for every PICKLIST / MULTIPICKLIST field, its
selectable option labels. Reach for it to learn a table's columns and the exact
option labels to filter its records on; use `list_data_tables` to discover
which tables exist.

You only see the data tables you have access to. An identifier that matches no
accessible table, or several tables, is an error naming how to refine it — a
table outside your scope reads exactly like one that does not exist.

## Parameters

<Accordion title="Body" defaultOpen>
  <ParamField body="data_table" type="string" required>
    The data table to fetch, matched against its name (case- and
    accent-insensitive substring) or, when it is a valid ObjectId, against the
    table id. Must resolve to exactly one table.
  </ParamField>
</Accordion>

## Response

<Accordion title="Body" defaultOpen>
  <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>

      <ResponseField name="options" type="string[]">
        Selectable option labels for a PICKLIST / MULTIPICKLIST field, in
        definition order; null for every other field type. Use these exact
        labels when filtering records on this column.
      </ResponseField>
    </Expandable>
  </ResponseField>
</Accordion>