Skip to main content

Get base tables

Gets the schema of base tables

Function GetDatabaseTables(Val Token, Val Base) Export

ParameterCLI optionTypeRequiredDescription
Token--tokenStringToken
Base--baseStringBase identifier

Returns: Map Of KeyAndValue - serialized JSON response from Airtable


1C:Enterprise/OneScript code example
    Token = "patNn4BXW66Yx3pdj.5b93c53cab554a8387de02d...";
Base = "appaKLx2yhnY45n6b";

Result = OPI_Airtable.GetDatabaseTables(Token, Base);
    oint airtable GetDatabaseTables \
--token "***" \
--base "appUHJhiJ9eMFouSg"
Result
{
"tables": [
{
"id": "tblNSgNYYa98koTqI",
"name": "TestTable",
"primaryFieldId": "fld1DqCPCiKFhIyZS",
"fields": [
{
"type": "number",
"options": {
"precision": 0
},
"id": "fld1DqCPCiKFhIyZS",
"name": "Number"
},
{
"type": "richText",
"id": "fldQoWm38IHjko160",
"name": "String"
}
],
"views": [
{
"id": "viwMqBmhwYdBZUwHi",
"name": "Grid view",
"type": "grid"
}
]
}
]
}