Create base

Creates a new database

Function CreateDatabase(Val Token, Val Workspace, Val Name, Val TableCollection) Export

Parameter	CLI option	Type	Required	Description
Token	--token	String	✔	Token
Workspace	--ws	String	✔	Workspace identifier
Name	--title	String	✔	New base name
TableCollection	--tablesdata	Map Of KeyAndValue	✔	Table description: Key > name, Value > array of fields

Returns: Map Of KeyAndValue - serialized JSON response from Airtable

1C:Enterprise/OneScript code example

    Token  = "patNn4BXW66Yx3pdj.5b93c53cab554a8387de02d...";
    Region = "wspdf8yl1yZz3PmWZ";
    Name   = "TestDatabase";

    FieldArray = New Array;
    FieldArray.Add(OPI_Airtable.GetNumberField("Number"));
    FieldArray.Add(OPI_Airtable.GetStringField("String"));

    TableName = "TestTable";

    TableMapping = New Map;
    TableMapping.Insert(TableName, FieldArray);

    Result = OPI_Airtable.CreateDatabase(Token, Region, Name, TableMapping);

Bash

    # JSON data can also be passed as a path to a .json file
    
    oint airtable CreateDatabase \
     --token "***" \
     --ws "wspdf8yl1yZz3PmWZ" \
     --title "TestDatabase" \
     --tablesdata "{'TestTable':[{'name':'Number','type':'number','options':{'precision':0}},{'name':'String','type':'richText'}]}"

CMD/Bat

    :: JSON data can also be passed as a path to a .json file
    
    oint airtable CreateDatabase ^
     --token "***" ^
     --ws "wspdf8yl1yZz3PmWZ" ^
     --title "TestDatabase" ^
     --tablesdata "{'TestTable':[{'name':'Number','type':'number','options':{'precision':0}},{'name':'String','type':'richText'}]}"

Result

{
 "id": "appD2vawGftoNUTKW",
 "tables": [
  {
   "id": "tblbhqzh3PL3cS6Ch",
   "name": "TestTable",
   "primaryFieldId": "fld9JrMjoVLwSPy3C",
   "fields": [
    {
     "type": "number",
     "options": {
      "precision": 0
     },
     "id": "fld9JrMjoVLwSPy3C",
     "name": "Number"
    },
    {
     "type": "richText",
     "id": "fld044xLas7uBdddr",
     "name": "String"
    }
   ],
   "views": [
    {
     "id": "viwfJdwEI0dtqJMl6",
     "name": "Grid view",
     "type": "grid"
    }
   ]
  }
 ]
}