Trying to use a curl GET from excel VBA 2011 Mac to grab some records. Took me a while to figure out how to get authentication to work, did that, but have hit another bump.
I am copying the GET syntax directly from Paw which returns the correct results. In excel the same syntax does not return the same results. It seems I can only manage to pass a single filter to Airtable.
This code will return ALL records in the Stunning view of BestTableEver.
“curl -X GET --header ‘Authorization: Bearer keyYour_Bearer_Key’ https://api.airtable.com/v0/appYour_Fabs_App/BestTableEver?view=Stunning&maxRecords=1”
This code will return a single record from BestTableEver that is actually filtered out of the Stunning view, but is the first record you get from Paw without naming the view.
“curl -X GET --header ‘Authorization: Bearer keyYour_Bearer_Key’ https://api.airtable.com/v0/appYour_Fabs_App/BestTableEver?maxRecords=1&view=Stunning”
I should note I am using the execShell() function courtesy of Robert Knight via StackOverflow to make the actual call.
And after a little digging here… https://curl.haxx.se/docs/manpage.html I am thinking the problem may be with the “&” after the first filter.