list_data_table_records

data_table

string

required

The table to read, by name (a case- and accent-insensitive substring of the table name) or its ObjectId. Must resolve to exactly one customer-facing (local or integration) table; an ambiguous name is rejected. Use list_data_tables to discover table names.

string

Free-text filter, matched the same way as the records page — a case- and accent-insensitive substring of the record’s name and external id. Omitted returns the table’s records unfiltered. AND-ed with the applied view’s row filter.

view

string

View to apply, by name (case- and accent-insensitive substring) or ObjectId — narrows the records to that view. Required only when the table reaches you through several shared views; otherwise omit it to read the whole table.

limit

integer

Page size, between 1 and 250. Defaults to 50.

offset

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.

data_table

object

Show object properties

string

resource_url

string

Deep link to open this data table in the Qobra web app.

name

string

api_key

string

source

string

integration

object

Show object properties

string

name

string

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

fields

object[]

Show object properties

name

string

api_key

string

Stable technical key for this field in Qobra’s public API (use it as a durable reference; the display name can change).

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.

linked_to

object

When type is object, the table this field points to; null otherwise.

Show object properties

string

name

string

records

object[]

Show object properties

string

name

string

source

string

Where the record comes from: integration (synced from a connected system) or local (created in Qobra). One of: integration, local, qobra, reporting.

source_id

string

The record’s id in its source system.

status

string

Integration record status (Created / Overwritten / Archived). Null for local-table records (no integration baseline) and for untouched integration rows.

archived

boolean

created_at

string

last_modified_at

string

fields

object[]

Show object properties

name

string

type

string

One of: float, amount, percentage, string, picklist, multipicklist, bool, date, user, object, group, record_status.

value

any

currency

string

One of: AED, AFN, ALL, AMD, ANG, AOA, ARS, AUD, AWG, AZN, BAM, BBD, BDT, BGN, BHD, BIF, BMD, BND, BOB, BOV, BRL, BSD, BTN, BWP, BYR, BZD, CAD, CDF, CHF, CLF, CLP, CNY, COP, COU, CRC, CUC, CUP, CVE, CZK, DJF, DKK, DOP, DZD, EGP, ERN, ETB, EUR, FJD, FKP, GBP, GEL, GHS, GIP, GMD, GNF, GTQ, GYD, HKD, HNL, HRK, HTG, HUF, IDR, ILS, INR, IQD, IRR, ISK, JMD, JOD, JPY, KES, KGS, KHR, KMF, KPW, KRW, KWD, KYD, KZT, LAK, LBP, LKR, LRD, LSL, LTL, LVL, LYD, MAD, MDL, MGA, MKD, MMK, MNT, MOP, MRO, MUR, MVR, MWK, MXN, MYR, MZN, NAD, NGN, NIO, NOK, NPR, NZD, OMR, PAB, PEN, PGK, PHP, PKR, PLN, PYG, QAR, RMB, RON, RSD, RUB, RWF, SAR, SBD, SCR, SDG, SEK, SGD, SHP, SLL, SOS, SRD, STD, SVC, SYP, SZL, THB, TJS, TMT, TND, TOP, TRY, TTD, TWD, TZS, UAH, UGX, USD, UYI, UYU, UZS, VEF, VND, VUV, WON, WST, XAF, XAG, XAU, XCD, XOF, XPD, XPF, XPT, XSU, YER, ZAR, ZMK, ZWL.

next_offset

integer

Parameters

Response

​Parameters

​Response

Parameters

Response