How to create JSON for Airtable API

1

Here is an example that uses the “Construct JSON” action to construct a JSON for the Airtable API.

airtable-json.morph (3.3 KB)
data.csv (172 Bytes)

image
image.png997×226 9.3 KB

The result JSON:

{ 
   "records":[ 
      { 
         "fields":{ 
            "Name":"Erich Nixon",
            "Address":"P.O. Box 702, 9474 Sed Rd.",
            "Amount":56.59
         }
      },
      { 
         "fields":{ 
            "Name":"Tate Acosta",
            "Address":"P.O. Box 354, 6740 Augue St.",
            "Amount":2.66
         }
      },
      { 
         "fields":{ 
            "Name":"Rajah Vasquez",
            "Address":"P.O. Box 278, 6627 Iaculis, Road",
            "Amount":66.44
         }
      }
   ]
}
2

UPDATE
Native actions for export to Airtable and updating/deleting tables in Airtable bases have been added in version 4.7.

Nevertheless, the example above is still good for demonstrating how to use the “Construct JSON” action.