Get details of a published table
GET {{baseUrl}}/cms/v3/hubdb/tables/:tableIdOrName?includeForeignIds=<boolean>&archived=<boolean>&isGetLocalizedSchema=<boolean>
Returns the details for the published
version of the specified table. This will include the definitions for the columns in the table and the number of rows in the table.
Note: This endpoint can be accessed without any authentication if the table is set to be allowed for public access.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
includeForeignIds | string | Set this to true to populate foreign ID values in the result. | |
archived | string | Set this to true to return details for an archived table. Defaults to false . | |
isGetLocalizedSchema | string |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Accept | string |
RESPONSES
status: OK
{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","id":"\u003cstring\u003e","columns":[{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"DATE","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":{"irure1":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"laboris0":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"sint5":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"sed0":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"et_1":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"optionCount":"\u003cinteger\u003e"},{"label":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"URL","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":{"non_d":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"},"magna___6":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","type":"\u003cstring\u003e"}},"foreignIdsById":{"fugiat0":{"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":{"est6c3":"\u003cinteger\u003e"},"allowPublicApiAccess":"\u003cboolean\u003e","createdAt":"\u003cdateTime\u003e","publishedAt":"\u003cdateTime\u003e","updatedAt":"\u003cdateTime\u003e"}