Modify table
Changes the name and/or description of the base
- Parameters
- Advanced call ?
Function ModifyTable(Val Token, Val Base, Val Table, Val Name = "", Val Description = "") Export
| Parameter | CLI option | Type | Required | Description |
|---|---|---|---|---|
| Token | --token | String | ✔ | Token |
| Base | --base | String | ✔ | Base identifier |
| Table | --table | String | ✔ | Table identifier |
| Name | --title | String | ✖ | New name |
| Description | --description | String | ✖ | New description |
Returns
Map Of KeyAndValue - serialized JSON response from Airtable
| Parameter | Description |
|---|---|
| proxy | InternetProxy or a structure with fields Protocol, Host, Port, User, Password, UseOSAuthentication |
| timeout | Request execution timeout |
| adv_response | Formats the response as a complete HTTP structure with fields code, body, and headers |
| retries | Number of HTTP request send attempts on 5** status codes or internal client errors |
| dontwait | Creates a background job and returns its data (for 1C and OneScript only) |
1C:Enterprise/OneScript code example
Token = "patNn4BXW66Yx3pdj.5b93c53cab554a8387de02d...";
Base = "appJiRrCJhRhnaVAo";
Table = "tblFGmvh2eldM8MuJ";
Name = "Test table 2 (change.)";
Description = "New table (change.)";
Result = OPI_Airtable.ModifyTable(Token, Base, Table, Name, Description);
- Bash
- CMD/Bat
oint airtable ModifyTable \
--token "***" \
--base "app86bmgLaVuoXh4T" \
--table "tblGKn3wdfOQGs7G3" \
--title "Test table 2 (change.)" \
--description "New table (change.)"
oint airtable ModifyTable ^
--token "***" ^
--base "app86bmgLaVuoXh4T" ^
--table "tblGKn3wdfOQGs7G3" ^
--title "Test table 2 (change.)" ^
--description "New table (change.)"
Result
{
"id": "tblGKn3wdfOQGs7G3",
"name": "Test table 2 (change.)",
"description": "New table (change.)",
"primaryFieldId": "fldzJFzZdPERWIDJ5",
"fields": [
{
"id": "fldzJFzZdPERWIDJ5",
"name": "Number",
"type": "number",
"options": {
"precision": 0
}
},
{
"id": "fldMF1aCUHxSxELab",
"name": "String",
"type": "richText"
},
{
"id": "fldQB66Pnh0vMr4q7",
"name": "Attachment",
"type": "multipleAttachments",
"options": {
"isReversed": false
}
},
{
"id": "fldtpBxr7bkFJlER8",
"name": "Checkbox",
"type": "checkbox",
"options": {
"icon": "check",
"color": "yellowBright"
}
},
{
"id": "fld1oUVP4S1DdQaTT",
"name": "Date",
"type": "date",
"options": {
"dateFormat": {
"name": "iso",
"format": "YYYY-MM-DD"
}
}
},
{
"id": "fldhRyUMHIdsdcf3h",
"name": "Phone",
"type": "phoneNumber"
},
{
"id": "flda9APjYtjNjZ5TG",
"name": "Email",
"type": "email"
},
{
"id": "fldrlDQhzs13tdJEd",
"name": "Link",
"type": "url"
}
],
"views": [
{
"id": "viwgZmI133I2gYv9R",
"name": "Grid view",
"type": "grid"
}
]
}