Get all published tables
GET {{baseUrl}}/cms/v3/hubdb/tables?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 the published version of each table defined in an account, including column definitions.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
sort | string | Specifies which fields to use for sorting results. Valid fields are name, createdAt, updatedAt, createdBy, updatedBy. createdAt will be used by default. | |
sort | string | Specifies which fields to use for sorting results. Valid fields are name, createdAt, updatedAt, createdBy, updatedBy. createdAt will be used by default. | |
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. | |
createdAt | string | Only return tables created at exactly the specified time. | |
createdAfter | string | Only return tables created after the specified time. | |
createdBefore | string | Only return tables created before the specified time. | |
updatedAt | string | Only return tables last updated at exactly the specified time. | |
updatedAfter | string | Only return tables last updated after the specified time. | |
updatedBefore | string | Only return tables last updated before the specified time. | |
archived | string | Specifies whether to return archived tables. Defaults to false. | |
contentType | string |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string |
RESPONSES
status: OK
{"results":[{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","id":"\u003cstring\u003e","columns":[{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"FILE","id":"\u003cstring\u003e","deleted":"\u003cboolean\u003e","options":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}],"width":"\u003cinteger\u003e","foreignTableId":"\u003clong\u003e","foreignColumnId":"\u003cinteger\u003e","description":"\u003cstring\u003e","foreignIds":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}],"foreignIdsByName":{"labore_1":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"ut2c6":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"aute8":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"aute_7":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"optionCount":"\u003cinteger\u003e"},{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"MULTISELECT","id":"\u003cstring\u003e","deleted":"\u003cboolean\u003e","options":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}],"width":"\u003cinteger\u003e","foreignTableId":"\u003clong\u003e","foreignColumnId":"\u003cinteger\u003e","description":"\u003cstring\u003e","foreignIds":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}],"foreignIdsByName":{"aute3_6":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"Duisa0":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"optionCount":"\u003cinteger\u003e"}],"published":"\u003cboolean\u003e","deleted":"\u003cboolean\u003e","columnCount":"\u003cinteger\u003e","rowCount":"\u003cinteger\u003e","createdBy":{"email":"\u003cstring\u003e","firstName":"\u003cstring\u003e","id":"\u003cstring\u003e","lastName":"\u003cstring\u003e"},"updatedBy":{"email":"\u003cstring\u003e","firstName":"\u003cstring\u003e","id":"\u003cstring\u003e","lastName":"\u003cstring\u003e"},"useForPages":"\u003cboolean\u003e","allowChildTables":"\u003cboolean\u003e","enableChildTablePages":"\u003cboolean\u003e","isOrderedManually":"\u003cboolean\u003e","dynamicMetaTags":{"pariatur_2":"\u003cinteger\u003e","Duis664":"\u003cinteger\u003e"},"allowPublicApiAccess":"\u003cboolean\u003e","createdAt":"\u003cdateTime\u003e","publishedAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"},{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","id":"\u003cstring\u003e","columns":[{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"CTA","id":"\u003cstring\u003e","deleted":"\u003cboolean\u003e","options":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}],"width":"\u003cinteger\u003e","foreignTableId":"\u003clong\u003e","foreignColumnId":"\u003cinteger\u003e","description":"\u003cstring\u003e","foreignIds":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}],"foreignIdsByName":{"aliquip_31":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"velit_ec":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"commodo_2":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"nulla_0ec":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"proident8":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"elit464":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"optionCount":"\u003cinteger\u003e"},{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"CTA","id":"\u003cstring\u003e","deleted":"\u003cboolean\u003e","options":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","order":"\u003cinteger\u003e","type":"\u003cstring\u003e","label":"\u003cstring\u003e","createdAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}],"width":"\u003cinteger\u003e","foreignTableId":"\u003clong\u003e","foreignColumnId":"\u003cinteger\u003e","description":"\u003cstring\u003e","foreignIds":[{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}],"foreignIdsByName":{"pariatur_004":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"sit8":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"laboris2ab":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"optionCount":"\u003cinteger\u003e"}],"published":"\u003cboolean\u003e","deleted":"\u003cboolean\u003e","columnCount":"\u003cinteger\u003e","rowCount":"\u003cinteger\u003e","createdBy":{"email":"\u003cstring\u003e","firstName":"\u003cstring\u003e","id":"\u003cstring\u003e","lastName":"\u003cstring\u003e"},"updatedBy":{"email":"\u003cstring\u003e","firstName":"\u003cstring\u003e","id":"\u003cstring\u003e","lastName":"\u003cstring\u003e"},"useForPages":"\u003cboolean\u003e","allowChildTables":"\u003cboolean\u003e","enableChildTablePages":"\u003cboolean\u003e","isOrderedManually":"\u003cboolean\u003e","dynamicMetaTags":{"occaecat_2f":"\u003cinteger\u003e","nullace":"\u003cinteger\u003e"},"allowPublicApiAccess":"\u003cboolean\u003e","createdAt":"\u003cdateTime\u003e","publishedAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}],"total":"\u003cinteger\u003e","paging":{"next":{"after":"\u003cstring\u003e","link":"\u003cstring\u003e"}}}