Tables
Create table
Creates a table. Columns can be supplied at creation or added later. Requires a USER API key.
post/public/v1/tables
Request body
Example request
{
"name": "example",
"displayName": "example",
"emoji": "example",
"icon_color": "example",
"columns": [
{
"name": "example",
"type": "string",
"record_type_id": 1,
"recordTypeId": 1
}
]
}Response
Created table
Example response
{
"ok": true,
"data": {
"id": 1,
"name": "example",
"display_name": "example",
"type": "table",
"created_at": "example",
"updated_at": "example",
"description": "example",
"emoji": "example",
"icon_color": "example",
"field_count": 1,
"fields": [
{
"id": 1,
"name": "example",
"key": "example",
"type": "example",
"created_at": "example",
"updated_at": "example",
"format": "example",
"mode": "singleSelect",
"timezone": "example",
"decimals": 1,
"currency": "example",
"min": 1,
"max": 1,
"time_format": "example",
"allowed_file_types": [
"example"
],
"max_file_size": 1,
"related_table_id": 1,
"related_record_type_ids": [
1
],
"display_field_id": 1,
"relation_mode": "example",
"options": [
{
"id": 1,
"name": "example",
"color": "example",
"order": 1,
"created_at": "example",
"updated_at": "example"
}
],
"output_type": "example"
}
],
"views": [
{
"id": 1,
"name": "example",
"type": "TABLE",
"record_type_id": 1,
"created_at": "example",
"updated_at": "example",
"column_order": [
"example"
],
"hidden_columns": [
"example"
],
"sticky_columns": [
"example"
],
"grouping_field_id": 1,
"title_field_id": 1,
"display_field_ids": [
1
]
}
],
"record_types": [
{
"id": 1,
"name": "example",
"display_name": "example",
"single_noun": "example",
"emoji": "example",
"icon_color": "example",
"default_view_id": 1,
"field_ids": [
1
],
"views": [
{
"id": 1,
"name": "example",
"type": "TABLE",
"record_type_id": 1,
"created_at": "example",
"updated_at": "example",
"column_order": [
"example"
],
"hidden_columns": [
"example"
],
"sticky_columns": [
"example"
],
"grouping_field_id": 1,
"title_field_id": 1,
"display_field_ids": [
1
]
}
]
}
]
}
}