Data -> Internal Tables
Add BI Column
API Documentation
Organization -> Organizations
Organization -> Workspaces
Organization -> Projects
Projects (Deprecated)
Projects -> Api Key
Connections
Data -> Catalogs
Data -> Internal Tables
Data -> Queries
Data -> Semantic Catalogs
Data -> Cache
Embedded Peaka Api
Supported Drivers
Data -> Metadata
- PUTUpdate Metadata
- PUTUpdate Relation From Metadata
- DELDelete Relation From Metadata
- PUTGenerate categorical values from the the column.
- POSTGenerate semantics for the table
- POSTAdd Relation To Metadata
- GETList of golden sqls for the project.
- POSTCreate golden sql for the project
- GETGet Project Metadata
- GETGet Project Catalog Metadata Relations
- GETGenerate sample ai questions for the project
- DELDelete golden sql from the project.
Data -> Internal Tables
Add BI Column
POST
/
data
/
projects
/
{projectId}
/
bitable
/
{tableName}
/
columns
curl --request POST \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/bitable/{tableName}/columns \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '[
{
"dataType": "bigint",
"displayName": "num19",
"defaultValue": null,
"name": "num19"
},
{
"dataType": "bigint",
"displayName": "num18",
"defaultValue": 3,
"isUnique": true,
"name": "num18"
}
]'
[
{
"name": "num19",
"dataType": "bigint",
"displayName": "num19",
"defaultValue": null,
"isNotNull": false,
"isUnique": false
},
{
"name": "num18",
"dataType": "bigint",
"displayName": "num18",
"defaultValue": "3",
"isNotNull": false,
"isUnique": true
}
]
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Body
application/json
Column Request
This class represents a ColumnRequest. It contains the name, data type, display name, default value, not null and unique status of the column request.
Response
200 - */*
Column added successfully
The response is of type object
.
curl --request POST \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/bitable/{tableName}/columns \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '[
{
"dataType": "bigint",
"displayName": "num19",
"defaultValue": null,
"name": "num19"
},
{
"dataType": "bigint",
"displayName": "num18",
"defaultValue": 3,
"isUnique": true,
"name": "num18"
}
]'
[
{
"name": "num19",
"dataType": "bigint",
"displayName": "num19",
"defaultValue": null,
"isNotNull": false,
"isUnique": false
},
{
"name": "num18",
"dataType": "bigint",
"displayName": "num18",
"defaultValue": "3",
"isNotNull": false,
"isUnique": true
}
]