Get rows for a table

GET {{baseUrl}}/cms/v3/hubdb/tables/:tableIdOrName/rows?sort=<string>&sort=<string>&after=<string>&limit=<integer>&properties=<string>&properties=<string>&offset=<integer>&archived=<boolean>

Returns a set of rows in the published version of the specified table. Row results can be filtered and sorted. Filtering and sorting options will be sent as query parameters to the API request. For example, by adding the query parameters column1__gt=5&sort=-column1, API returns the rows with values for column column1 greater than 5 and in the descending order of column1 values. Refer to the overview section for detailed filtering and sorting options. Note: This endpoint can be accessed without any authentication, if the table is set to be allowed for public access.

Request Params

KeyDatatypeRequiredDescription
sortstringSpecifies the column names to sort the results by. See the above description for more details.
sortstringSpecifies the column names to sort the results by. See the above description for more details.
afterstringThe cursor token value to get the next set of results. You can get this from the paging.next.after JSON property of a paged response containing more results.
limitstringThe maximum number of results to return. Default is 1000.
propertiesstringSpecify the column names to get results containing only the required columns instead of all column details.
propertiesstringSpecify the column names to get results containing only the required columns instead of all column details.
offsetstring
archivedstring

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&quot;results&quot;:[{&quot;values&quot;:{&quot;velit683&quot;:{},&quot;qui_ff7&quot;:{}},&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;path&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;childTableId&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;publishedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;values&quot;:{&quot;culpab&quot;:{},&quot;sed79d&quot;:{}},&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;path&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;childTableId&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;publishedAt&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;total&quot;:&quot;\u003cinteger\u003e&quot;,&quot;paging&quot;:{&quot;next&quot;:{&quot;after&quot;:&quot;\u003cstring\u003e&quot;,&quot;link&quot;:&quot;\u003cstring\u003e&quot;,&quot;offset&quot;:&quot;\u003cinteger\u003e&quot;}},&quot;type&quot;:&quot;RANDOM_ACCESS&quot;}