id, name (the table’s
name column), source, source_id (external id), status, archived,
created_at, last_modified_at and its values.
values are positional: the Nth value is the Nth entry of data_table.fields,
which states each column’s name and type once. A cell is {value, currency},
currency only for an amount. value is a number (a percentage as its ratio),
text, a boolean, an ISO-8601 UTC instant for a date, an option label (a list of
labels for a multipicklist), a user as {id, email, name}
({user_integration_id, imported: false} for someone who is not a Qobra user),
or a linked record as {id, name, integration_id}.
On a table with many fields, pass field_ids (the ids get_data_table returns)
to serve only those columns, in the order given.
Rows are ordered by creation, newest first, on a local table; by record name
on an integration table. A table you cannot access reads “not found” (see
get_data_table). The views of
data_table have a null access; get_data_table says who can read a view.
The result carries a list-level application_url that reopens the list you
just fetched, with the view selected. It is only set when you pass a view_id;
otherwise it is null and the table’s own resource_url opens the page.
Parameters
Body
Body
string
required
Id of the table, from list_data_tables.
string
The record’s name or external id, as one phrase matched as a case- and
accent-insensitive substring (words are not matched separately). Combined
with the view’s row filter.
string
Id of a view of the table (its
views, from list_data_tables) whose row
filter applies. Required only when several views shared with you reach the
table; with full access, omit it for every record.integer
Rows per page, 1 to 25. Default 25.
integer
Rows to skip. Omit it for the first page, never null or the string ‘None’;
for the next page pass the previous next_offset.