Create a new table
POST {{baseUrl}}/cms/v3/hubdb/tables
Creates a new draft HubDB table given a JSON schema. The table name and label should be unique for each account.
Request Body
{"label"=>"<string>", "name"=>"<string>", "useForPages"=>"<boolean>", "allowPublicApiAccess"=>"<boolean>", "allowChildTables"=>"<boolean>", "enableChildTablePages"=>"<boolean>", "columns"=>[{"id"=>"<integer>", "label"=>"<string>", "name"=>"<string>", "options"=>[{"id"=>"<string>", "name"=>"<string>", "order"=>"<integer>", "type"=>"<string>", "label"=>"<string>", "createdAt"=>"<dateTime>", "updatedAt"=>"<dateTime>"}, {"id"=>"<string>", "name"=>"<string>", "order"=>"<integer>", "type"=>"<string>", "label"=>"<string>", "createdAt"=>"<dateTime>", "updatedAt"=>"<dateTime>"}], "type"=>"NUMBER", "foreignTableId"=>"<long>", "foreignColumnId"=>"<integer>"}, {"id"=>"<integer>", "label"=>"<string>", "name"=>"<string>", "options"=>[{"id"=>"<string>", "name"=>"<string>", "order"=>"<integer>", "type"=>"<string>", "label"=>"<string>", "createdAt"=>"<dateTime>", "updatedAt"=>"<dateTime>"}, {"id"=>"<string>", "name"=>"<string>", "order"=>"<integer>", "type"=>"<string>", "label"=>"<string>", "createdAt"=>"<dateTime>", "updatedAt"=>"<dateTime>"}], "type"=>"NULL", "foreignTableId"=>"<long>", "foreignColumnId"=>"<integer>"}], "dynamicMetaTags"=>{"dolore487"=>"<integer>", "voluptate_0"=>"<integer>"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: Created
{"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"}