Get base tables
Gets the schema of base tables
- Parameters
- Advanced call ?
Function GetDatabaseTables(Val Token, Val Base) Export
| Parameter | CLI option | Type | Required | Description |
|---|---|---|---|---|
| Token | --token | String | ✔ | Token |
| Base | --base | String | ✔ | Base identifier |
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";
Result = OPI_Airtable.GetDatabaseTables(Token, Base);
- Bash
- CMD/Bat
oint airtable GetDatabaseTables \
--token "***" \
--base "app86bmgLaVuoXh4T"
oint airtable GetDatabaseTables ^
--token "***" ^
--base "app86bmgLaVuoXh4T"
Result
{
"tables": [
{
"id": "tbl7RiHedDu9oSPi8",
"name": "TestTable",
"primaryFieldId": "fldjQy39z6mK3NgHH",
"fields": [
{
"type": "number",
"options": {
"precision": 0
},
"id": "fldjQy39z6mK3NgHH",
"name": "Number"
},
{
"type": "richText",
"id": "fld8sJRtJfudYSGDh",
"name": "String"
}
],
"views": [
{
"id": "viwpaiNpAINZddhe0",
"name": "Grid view",
"type": "grid"
}
]
}
]
}