Create table

Creates a new table in the base

Function CreateTable(Val Token, Val Base, Val Name, Val FieldArray, Val Description = "") Export

Parameter	CLI option	Type	Required	Description
Token	--token	String	✔	Token
Base	--base	String	✔	Base identifier
Name	--title	String	✔	New table name
FieldArray	--fieldsdata	Array of Structure	✔	Array of field descriptions
Description	--description	String	✖	Table description

Returns: Map Of KeyAndValue - serialized JSON response from Airtable

1C:Enterprise/OneScript code example

    Token = "patNn4BXW66Yx3pdj.5b93c53cab554a8387de02d...";
    Base  = "appeMvjrOQPJciL7O";

    FieldArray = New Array;
    FieldArray.Add(OPI_Airtable.GetNumberField("Number"));
    FieldArray.Add(OPI_Airtable.GetStringField("String"));
    FieldArray.Add(OPI_Airtable.GetAttachmentField("Attachment"));
    FieldArray.Add(OPI_Airtable.GetCheckboxField("Checkbox"));
    FieldArray.Add(OPI_Airtable.GetDateField("Date"));
    FieldArray.Add(OPI_Airtable.GetPhoneField("Phone"));
    FieldArray.Add(OPI_Airtable.GetEmailField("Email"));
    FieldArray.Add(OPI_Airtable.GetLinkField("Link"));

    Name        = "TestTable2";
    Description = "NewTable";

    Result = OPI_Airtable.CreateTable(Token, Base, Name, FieldArray, Description);

Bash

    oint airtable CreateTable \
     --token "***" \
     --base "appk3Fw5gwni4SWYj" \
     --title "TestTable2" \
     --fieldsdata "[{'name':'Number','type':'number','options':{'precision':0}},{'name':'String','type':'richText'},{'name':'Attachment','type':'multipleAttachments'},{'name':'Checkbox','type':'checkbox','options':{'icon':'check','color':'yellowBright'}},{'name':'Date','type':'date','options':{'dateFormat':{'format':'YYYY-MM-DD','name':'iso'}}},{'name':'Phone','type':'phoneNumber'},{'name':'Email','type':'email'},{'name':'Link','type':'url'}]" \
     --description "NewTable"

CMD/Bat

    oint airtable CreateTable ^
     --token "***" ^
     --base "appk3Fw5gwni4SWYj" ^
     --title "TestTable2" ^
     --fieldsdata "[{'name':'Number','type':'number','options':{'precision':0}},{'name':'String','type':'richText'},{'name':'Attachment','type':'multipleAttachments'},{'name':'Checkbox','type':'checkbox','options':{'icon':'check','color':'yellowBright'}},{'name':'Date','type':'date','options':{'dateFormat':{'format':'YYYY-MM-DD','name':'iso'}}},{'name':'Phone','type':'phoneNumber'},{'name':'Email','type':'email'},{'name':'Link','type':'url'}]" ^
     --description "NewTable"

Result

{
 "id": "tbl1ECxOLd4V6OM9T",
 "name": "TestTable2",
 "description": "NewTable",
 "primaryFieldId": "fldhWwOjg9UhvJ6A2",
 "fields": [
  {
   "type": "number",
   "options": {
    "precision": 0
   },
   "id": "fldhWwOjg9UhvJ6A2",
   "name": "Number"
  },
  {
   "type": "richText",
   "id": "fld8KaCe62SjwSYAk",
   "name": "String"
  },
  {
   "type": "multipleAttachments",
   "options": {
    "isReversed": false
   },
   "id": "fldSWB4hUUyP5Hx30",
   "name": "Attachment"
  },
  {
   "type": "checkbox",
   "options": {
    "icon": "check",
    "color": "yellowBright"
   },
   "id": "fld7UipYF2w9FsoRm",
   "name": "Checkbox"
  },
  {
   "type": "date",
   "options": {
    "dateFormat": {
     "name": "iso",
     "format": "YYYY-MM-DD"
    }
   },
   "id": "fldHVbDsv6ndNp2XZ",
   "name": "Date"
  },
  {
   "type": "phoneNumber",
   "id": "fldYL0IFRMVQCO7gW",
   "name": "Phone"
  },
  {
   "type": "email",
   "id": "fldzsmOGCGjThDsUp",
   "name": "Email"
  },
  {
   "type": "url",
   "id": "fldMWVcVuR9CmKBcD",
   "name": "Link"
  }
 ],
 "views": [
  {
   "id": "viwMlZ7T3KyjEufmW",
   "name": "Grid view",
   "type": "grid"
  }
 ]
}