Currently, when you retrieve records through the API and specify a view, only those records that are visible through the view are returned, and they are returned in the order in which they are displayed. This is a noce feature, and I use it often.
It would also help if the API returned only the columns that are visible through the specified view. In other words, any hidden columns would be excluded from the result. I believe that this would help both in terms of security and performance.
Yes, please! I was quite surprised by how much unnecessary data was returned by the API - seems like thatâs very much the point of having the views in the first place!
It looks like youâre printing the record object directly. To get the field values use the get method on the record object. e.g. to get the notes for a record: record.get('Notes').
We donât currently have a way of automatically getting all the field values as an object, but will consider adding it in the future.
Having the API parameters is a great way to restrict information in the consumer side, but I think Timâs suggestion is more focused on the creator side, so only one view (and the columns/rows we decide) are exposed to the API queries keeping other information private
I also agree with Timâs suggestion. Limiting fields via the API is a nice addition. However, it seems it would be easier to allow users to create (simplified) views containing hidden fields, and by default returning only those fields that are visible.
Perhaps an âincludeHiddenâ boolean parameter can be provided that allows a developer to choose their desired behavior.
Totally agree with this - would be great and it should be driven from the user end - particularly since there doesnât seem to be a way to get a list of hidden fields via API either, so you canât just query the view for visible fields and ask to only return those.