curl -X POST https://api.crewship.dev/v1/tables \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"name": "leads",
"description": "Sales prospects",
"columns": [
{"name": "company", "type": "text", "required": true},
{"name": "score", "type": "number"},
{"name": "status", "type": "select", "options": ["new", "qualified"]}
]
}'
{
"id": "tbl_abc123xyz789",
"name": "leads",
"description": "Sales prospects",
"columns": [
{ "name": "company", "type": "text", "required": true },
{ "name": "score", "type": "number", "required": false },
{ "name": "status", "type": "select", "required": false, "options": ["new", "qualified"] }
],
"row_count": 0,
"created_at": "2024-01-15T10:35:00Z",
"updated_at": "2024-01-15T10:35:00Z"
}
{
"error": {
"message": "Table \"leads\" already exists"
}
}
Tables
Create Table
Create a new data table
POST
/
v1
/
tables
curl -X POST https://api.crewship.dev/v1/tables \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"name": "leads",
"description": "Sales prospects",
"columns": [
{"name": "company", "type": "text", "required": true},
{"name": "score", "type": "number"},
{"name": "status", "type": "select", "options": ["new", "qualified"]}
]
}'
{
"id": "tbl_abc123xyz789",
"name": "leads",
"description": "Sales prospects",
"columns": [
{ "name": "company", "type": "text", "required": true },
{ "name": "score", "type": "number", "required": false },
{ "name": "status", "type": "select", "required": false, "options": ["new", "qualified"] }
],
"row_count": 0,
"created_at": "2024-01-15T10:35:00Z",
"updated_at": "2024-01-15T10:35:00Z"
}
{
"error": {
"message": "Table \"leads\" already exists"
}
}
Request
string
required
Table name (unique within your organization)
string
Optional table description
array
required
Column definitions for the table
string
required
Column name
string
required
Column type:
text, number, boolean, datetime, select, url, email, jsonboolean
default:"false"
Whether the column is required on inserts
array
Required for
select columnsResponse
Returns HTTP 201 (Created).string
Table ID (e.g.,
tbl_abc123xyz789)string
Table name
string
Table description or
nullarray
Persisted column definitions
number
Initial row count (
0)string
ISO 8601 timestamp
string
ISO 8601 timestamp
curl -X POST https://api.crewship.dev/v1/tables \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"name": "leads",
"description": "Sales prospects",
"columns": [
{"name": "company", "type": "text", "required": true},
{"name": "score", "type": "number"},
{"name": "status", "type": "select", "options": ["new", "qualified"]}
]
}'
{
"id": "tbl_abc123xyz789",
"name": "leads",
"description": "Sales prospects",
"columns": [
{ "name": "company", "type": "text", "required": true },
{ "name": "score", "type": "number", "required": false },
{ "name": "status", "type": "select", "required": false, "options": ["new", "qualified"] }
],
"row_count": 0,
"created_at": "2024-01-15T10:35:00Z",
"updated_at": "2024-01-15T10:35:00Z"
}
{
"error": {
"message": "Table \"leads\" already exists"
}
}