Unable to use fields parameter for Airtable API in Shortcuts app

Other Questions Airtable
1

I’m facing an issue while trying to filter specific fields from Airtable’s API in the Shortcuts app. Although I can retrieve records without any problems using the maxRecords parameter, I encounter errors when attempting to use the fields parameter.

The successful request I made to list records looks like this:

https://api.airtable.com/v0/<BaseID>/<TableName>?maxRecords=3

However, when I switch the URL to include the fields parameter like so:

https://api.airtable.com/v0/<BaseID>/<TableName>?fields=['Name']

I get the following error message:

{
  "error": {
    "type": "INVALID_REQUEST_UNKNOWN",
    "message": "Invalid request: parameter validation failed. Check your request data."
  }
}

I’ve been looking at the API documentation, but I can’t seem to resolve the issue. Has anyone else encountered this problem when working with field filtering on Airtable’s API using Shortcuts?

2

Drop the square brackets and quotes. The fields parameter doesn’t need array syntax in the URL.

Try this:

https://api.airtable.com/v0/<BaseID>/<TableName>?fields=Name

For multiple fields, use commas:

https://api.airtable.com/v0/<BaseID>/<TableName>?fields=Name,Email,Status

I hit this exact issue building an automation for our project tracking base. Wasted way too much time trying to format it like a JSON array before realizing Airtable wants plain URL parameters.

Field names with spaces need URL encoding or quotes like fields="Project Name",Status.

Should work in Shortcuts once you fix the parameter format.

3

yeah, brackets are def the issue. airtable wants plain query params, not array syntax. just use fields=Name and ur good. hit the same prob last week pulling data for a client dashboard - kept getting validation errors until i figured out shortcuts was literally passing the brackets in the url.

4

This is a URL encoding issue with the fields parameter. When you use fields=['Name'], those array brackets get mangled in the HTTP request. Drop the brackets and use fields=Name for single fields or fields=Name,Email for multiple fields. I’ve hit this same problem building client reports in Shortcuts. The key is getting the URL encoding right, especially with field names that have spaces or special characters. For spaced field names, wrap them in quotes like fields="Project Name",Status or use percent-encoding. Shortcuts also loves to mess with URL encoding sometimes. Build your URL step by step and test each parameter separately to figure out where it’s breaking.

5

Your parameter formatting is wrong. You’re using fields=['Name'] like JavaScript array syntax, but Airtable’s REST API just wants standard query parameters. Use fields=Name - no brackets or quotes. For multiple fields, separate with commas: fields=Name,Email,Phone. I hit this exact issue building a contact sync workflow. The Shortcuts app gets weird with URL construction too. Build your URL with the ‘Add to Variable’ action instead of text concatenation - it handles encoding better. Field names with spaces need URL encoding or use the exact name from Airtable. Test simple field names first before trying anything with spaces or special characters.