Create base

Creates a new database

Parameters

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

Advanced call ?

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...";
    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": "app86bmgLaVuoXh4T",
 "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"
    }
   ]
  }
 ]
}