Delete column
curl --request DELETE \
--url https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}const url = 'https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}';
const options = {method: 'DELETE'};
fetch(url, options)
.then(res => res.json())
.then(json => console.log(json))
.catch(err => console.error(err));import requests
url = "https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}"
response = requests.delete(url)
print(response.text)Delete column
Permanently delete a column and its values. Rate limit: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. 100 column changes per UTC day per workspace.
DELETE
/
v1
/
tables
/
{table_id}
/
columns
/
{column_id}
Delete column
curl --request DELETE \
--url https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}const url = 'https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}';
const options = {method: 'DELETE'};
fetch(url, options)
.then(res => res.json())
.then(json => console.log(json))
.catch(err => console.error(err));import requests
url = "https://api.airscale.io/v1/tables/{table_id}/columns/{column_id}"
response = requests.delete(url)
print(response.text)Deleting a column is permanent. Its values are removed from every row and cannot be restored, unlike deleted tables and rows.
text, email, phone, url, number and json columns can be deleted through the API. Other types return 400 with code: "read_only_column".
The column disappears from responses immediately, and its values are cleared in the background. Until that finishes, other writes to the table return 409 with code: "table_operation_conflict"; retry after a few seconds.
Paid plans only. No credits are charged. Limits: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. 100 column changes per UTC day per workspace. See the Tables API overview for every limit.
Authentication
SendAuthorization: Bearer $AIRSCALE_API_KEY. The key determines the workspace. See Authentication.
Parameters
| Name | Location | Required | Description |
|---|---|---|---|
table_id | path | Yes | Table ID returned by Create table or List tables. |
column_id | path | Yes | Column ID from the table’s columns. |
Request example
Replace path variables with IDs returned by the API. Column UUIDs in the example body must belong to your table.curl --request DELETE "https://api.airscale.io/v1/tables/$TABLE_ID/columns/$COLUMN_ID" \
--header "Authorization: Bearer $AIRSCALE_API_KEY"
Response
200
The column was deleted.{
"deleted": true,
"id": "bc629d4d-cc75-4cee-b10a-851203d82fac"
}
Errors
| Status | Meaning |
|---|---|
| 400 | The column is read-only (enrichment, formula, date or deliverability), or an ID is invalid. |
| 401 | Missing or invalid API key. |
| 403 | The workspace does not have an active paid plan. |
| 404 | Table or column not found in this workspace, or deleted. |
| 409 | Another table operation is running. |
| 429 | A rate limit, the one-write-at-a-time rule or a daily limit was reached. Wait for Retry-After before retrying. |
| 502 | The service could not be reached. Retry with backoff. |
| 503 | The service is at capacity or temporarily unavailable. Retry after Retry-After. |
| 504 | The request timed out after 30 seconds. A write may still have been applied; check the result before retrying it. |