Jun 04, 2016 04:59 PM
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
Jun 04, 2016 05:39 PM
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"]})
.
Jun 04, 2016 06:03 PM
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[]=…
Mar 25, 2019 07:44 AM
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.