Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using Fields filter in List of records

Topic Labels: API
5520 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I have been trying for several hours to get the fields parameter for the list records request to work. I am sending an HTTP Get request with python, I have the filterByFormula field working but cannot get the fields parameter to work. Could someone please post an example of the fields tag and an example field in a working query string format?

Thanks

3 Replies 3

The fields parameter should be a URL-encoded array. For example, if you want to include two fields called “Notes” and “Attachments”, the fields array would be:

["Notes", "Attachments"]

When URL-encoded, this ends up looking like:

fields[]=Notes&fields[]=Attachments

So the full URL would be:

https://api.airtable.com/v0/appId/TableName?fields[]=Notes&fields[]=Attachments

You can check out http://api.jquery.com/jquery.param/ as a reference implementation of URL-encoding objects and arrays. e.g. jQuery.param({fields: ["Notes", "Attachments"]}).

I’ve always has issue with the length of the fields parameter, especially when you require only 20 out of 30 fields, you end up with a ridiculously long string. Does anyone know of a way to reduce the size so that you don’t end up with a string of endless &fields[] =blah&fields[]=blahblah&fields[]=…

I am confused as to why this isn’t yet a feature… seems really odd to have to declare multiple values for ‘fields’ … especially in a program like Alteryx, this will not be an accepted protocol.