Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Integration from Filemaker Pro to Airtable

Topic Labels: Integrations
561 0
Showing results for 
Search instead for 
Did you mean: 

I am trying to have Filemaker Pro send all records to a database in one of my Airtable bases, using a rest. Here is my filemaker script, with key/api blanked.

Send to Airtable

#Send a foundset of records to AirTable

Go to Record/Request/Page
[ First ]

#Walk through the records and create a data package of records
Set Variable [ $Names; Value:"$Names & Case( not IsEmpty($Names) ; “,”) & Airtable::cJson" ]
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop

#Put the required wrapper around the record data and URL endpoint
Set Variable [ $URL; Value:“” ]
Set Variable [ $Action; Value:"-X Post" ]
Set Variable [ $Authenticate; Value:" -H “Authorization: Bearer _______\”]
Set Variable [ $ContentType; Value:” -H “Content-Type: application/json”]
Set Variable [ $Names; Value:"{“records”: [ " & $Names & " ]}" ]
Set Variable [ $Data; Value:" -d @$Names" ]

#Send the records to AirTable
Insert from URL [ $Response; cURL options: $Action & $Authenticate & $ContentType & $Data ]
[ Select; Verify SSL Certificates ]
Exit Script [ Result: True ]

0 Replies 0