Data Operations
Get table data
Get table data
get/tables/data/{dbId}/{tableId}
Path parameters
dbIdstring string required
Database ID
tableIdstring string required
Table ID
Query parameters
limitinteger
Number of rows to return (default: 100, max: 10000)
offsetinteger
Number of rows to skip for pagination (default: 0)
c[field_name]string
Filter by field value(s). Use c[field_name] format to avoid conflicts with reserved parameters. Supported formats:
- Range: c[age]=1-12 (values between 1 and 12)
- Multiple values: c[sex]=1,2,3 (any of these values)
- Combined: c[age]=1-12,24-30,7,9 (range and individual values)
- Greater than: c[age]=>10 (values >= 10)
- Less than: c[age]=<10 (values <= 10)
- Exclusion: c[sex]=!5 (exclude value 5)
- Quoted strings: c[name]="John Doe" (exact string match)
fieldsstring
A comma separated list of fields to output. If not specified, all fields are returned.
formatstring
Output format - json (default) or csv
debugboolean
Include debug information (options, features, filters) in response
Response
successful operation