Path
GET /api/table/{tableId}/record Request
Path Parameters
tableId (string): The unique identifier of the table (how to get).Basic Query Parameters
All parameters are optionalstring
Specifies the view ID to fetch records from. If not specified, records will be returned in order of creation time, including all records and fields.
number
Specifies the number of records to retrieve, maximum value is 1000.
number
Specifies the number of records to skip, used for pagination.
string
default:"name"
Defines the key type for fields in records, possible values:
name: Use field names as keys (default)id: Use field IDs as keysdbFieldName: Use field dbFieldName as keys
string
default:"json"
Defines the return format for cell values, possible values:
json: Returns structured JSON data (default)text: Returns plain text format
string[]
If you only need specific fields, specify them through this parameter. Otherwise, all visible fields will be retrieved. Parameter values depend on fieldKeyType setting (using field names or IDs or dbFieldName).
string
Array of sort objects specifying how records should be ordered.
string
Complex query condition object for filtering results. Supports complex query conditions based on fields, operators, and values.
string[]
Search for records matching specified fields and values.
Advanced Query Parameters
Advanced Query Parameters
string
Array of group objects specifying how records should be grouped.
string[]
Array of group IDs to collapse.
string[]
Filter selected records by record IDs.
boolean
When viewId is specified, setting this to true will ignore the view’s filters, sorting, and other settings.
string[]
Filter records from the linked table that can be selected by the specified link cell. For example, for one-to-many or one-to-one relationship fields, already selected record IDs will not appear.
string[]
Filter records from the linked table that are already selected by this link cell. Note: viewId, filter, and orderBy will not take effect in this case, as selected records have their own order.