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

KeyDatatypeRequiredDescription
includeForeignIdsstringSet this to true to populate foreign ID values in the result.
archivedstringSet this to true to return details for an archived table. Defaults to false.
isGetLocalizedSchemastring

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&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;DATE&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;irure1&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;laboris0&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;sint5&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;sed0&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;et_1&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;URL&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;non_d&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},&quot;magna___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;fugiat0&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;est6c3&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;}