Return all draft tables

GET {{baseUrl}}/cms/v3/hubdb/tables/draft?sort=<string>&sort=<string>&after=<string>&limit=<integer>&createdAt=<dateTime>&createdAfter=<dateTime>&createdBefore=<dateTime>&updatedAt=<dateTime>&updatedAfter=<dateTime>&updatedBefore=<dateTime>&archived=<boolean>&contentType=<string>

Returns the details for each draft table defined in the specified account, including column definitions.

Request Params

KeyDatatypeRequiredDescription
sortstringSpecifies which fields to use for sorting results. Valid fields are name, createdAt, updatedAt, createdBy, updatedBy. createdAt will be used by default.
sortstringSpecifies which fields to use for sorting results. Valid fields are name, createdAt, updatedAt, createdBy, updatedBy. createdAt will be used by default.
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.
createdAtstringOnly return tables created at exactly the specified time.
createdAfterstringOnly return tables created after the specified time.
createdBeforestringOnly return tables created before the specified time.
updatedAtstringOnly return tables last updated at exactly the specified time.
updatedAfterstringOnly return tables last updated after the specified time.
updatedBeforestringOnly return tables last updated before the specified time.
archivedstringSpecifies whether to return archived tables. Defaults to false.
contentTypestring

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&quot;results&quot;:[{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;columns&quot;:[{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;FILE&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;options&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;width&quot;:&quot;\u003cinteger\u003e&quot;,&quot;foreignTableId&quot;:&quot;\u003clong\u003e&quot;,&quot;foreignColumnId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;foreignIds&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;foreignIdsByName&quot;:{&quot;labore_1&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;ut2c6&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;foreignIdsById&quot;:{&quot;aute8&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;aute_7&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;optionCount&quot;:&quot;\u003cinteger\u003e&quot;},{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;MULTISELECT&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;options&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;width&quot;:&quot;\u003cinteger\u003e&quot;,&quot;foreignTableId&quot;:&quot;\u003clong\u003e&quot;,&quot;foreignColumnId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;foreignIds&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;foreignIdsByName&quot;:{&quot;aute3_6&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;foreignIdsById&quot;:{&quot;Duisa0&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;optionCount&quot;:&quot;\u003cinteger\u003e&quot;}],&quot;published&quot;:&quot;\u003cboolean\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;columnCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;rowCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;createdBy&quot;:{&quot;email&quot;:&quot;\u003cstring\u003e&quot;,&quot;firstName&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastName&quot;:&quot;\u003cstring\u003e&quot;},&quot;updatedBy&quot;:{&quot;email&quot;:&quot;\u003cstring\u003e&quot;,&quot;firstName&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastName&quot;:&quot;\u003cstring\u003e&quot;},&quot;useForPages&quot;:&quot;\u003cboolean\u003e&quot;,&quot;allowChildTables&quot;:&quot;\u003cboolean\u003e&quot;,&quot;enableChildTablePages&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isOrderedManually&quot;:&quot;\u003cboolean\u003e&quot;,&quot;dynamicMetaTags&quot;:{&quot;pariatur_2&quot;:&quot;\u003cinteger\u003e&quot;,&quot;Duis664&quot;:&quot;\u003cinteger\u003e&quot;},&quot;allowPublicApiAccess&quot;:&quot;\u003cboolean\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;publishedAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;columns&quot;:[{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;CTA&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;options&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;width&quot;:&quot;\u003cinteger\u003e&quot;,&quot;foreignTableId&quot;:&quot;\u003clong\u003e&quot;,&quot;foreignColumnId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;foreignIds&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;foreignIdsByName&quot;:{&quot;aliquip_31&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;velit_ec&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;commodo_2&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;nulla_0ec&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;foreignIdsById&quot;:{&quot;proident8&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;elit464&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;optionCount&quot;:&quot;\u003cinteger\u003e&quot;},{&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;CTA&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;options&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;order&quot;:&quot;\u003cinteger\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;label&quot;:&quot;\u003cstring\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&quot;:&quot;\u003cdateTime\u003e&quot;}],&quot;width&quot;:&quot;\u003cinteger\u003e&quot;,&quot;foreignTableId&quot;:&quot;\u003clong\u003e&quot;,&quot;foreignColumnId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;foreignIds&quot;:[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;foreignIdsByName&quot;:{&quot;pariatur_004&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;sit8&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;foreignIdsById&quot;:{&quot;laboris2ab&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}},&quot;optionCount&quot;:&quot;\u003cinteger\u003e&quot;}],&quot;published&quot;:&quot;\u003cboolean\u003e&quot;,&quot;deleted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;columnCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;rowCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;createdBy&quot;:{&quot;email&quot;:&quot;\u003cstring\u003e&quot;,&quot;firstName&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastName&quot;:&quot;\u003cstring\u003e&quot;},&quot;updatedBy&quot;:{&quot;email&quot;:&quot;\u003cstring\u003e&quot;,&quot;firstName&quot;:&quot;\u003cstring\u003e&quot;,&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lastName&quot;:&quot;\u003cstring\u003e&quot;},&quot;useForPages&quot;:&quot;\u003cboolean\u003e&quot;,&quot;allowChildTables&quot;:&quot;\u003cboolean\u003e&quot;,&quot;enableChildTablePages&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isOrderedManually&quot;:&quot;\u003cboolean\u003e&quot;,&quot;dynamicMetaTags&quot;:{&quot;occaecat_2f&quot;:&quot;\u003cinteger\u003e&quot;,&quot;nullace&quot;:&quot;\u003cinteger\u003e&quot;},&quot;allowPublicApiAccess&quot;:&quot;\u003cboolean\u003e&quot;,&quot;createdAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;publishedAt&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;updatedAt&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;}}}