Get rows from draft table
GET {{baseUrl}}/cms/v3/hubdb/tables/:tableIdOrName/rows/draft?sort=<string>&sort=<string>&after=<string>&limit=<integer>&properties=<string>&properties=<string>&offset=<integer>&archived=<boolean>
Returns rows in the draft
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.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
sort | string | Specifies the column names to sort the results by. | |
sort | string | Specifies the column names to sort the results by. | |
after | string | The 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. | |
limit | string | The maximum number of results to return. Default is 1000 . | |
properties | string | Specify the column names to get results containing only the required columns instead of all column details. If you want to include multiple columns in the result, use this query param as many times. | |
properties | string | Specify the column names to get results containing only the required columns instead of all column details. If you want to include multiple columns in the result, use this query param as many times. | |
offset | string | ||
archived | string |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Accept | string |
RESPONSES
status: OK
{"results":[{"values":{"velit683":{},"qui_ff7":{}},"id":"\u003cstring\u003e","path":"\u003cstring\u003e","name":"\u003cstring\u003e","childTableId":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e","publishedAt":"\u003cdateTime\u003e"},{"values":{"culpab":{},"sed79d":{}},"id":"\u003cstring\u003e","path":"\u003cstring\u003e","name":"\u003cstring\u003e","childTableId":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e","publishedAt":"\u003cdateTime\u003e"}],"total":"\u003cinteger\u003e","paging":{"next":{"after":"\u003cstring\u003e","link":"\u003cstring\u003e","offset":"\u003cinteger\u003e"}},"type":"RANDOM_ACCESS"}