Help

Re: API Token access to table with limited colmuns view

5109 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Valdemar_T
6 - Interface Innovator
6 - Interface Innovator

Hello,

Is there a possibility to grant/create API token for a read-only mode and for a limited number, of selected columns only? E.g. I don't want to give access to API for viewing some specific confidential information, but only specific fields, is that possible? And how to do it then? As now it seems if you give reading rights, it gives full access.

2 Replies 2
Cameron_Kaiser
6 - Interface Innovator
6 - Interface Innovator

Create a view with just the fields you want and sync it to a new base. Create an API Token that has read access to that new base. Now anyone with the token will have access to just those fields.

There is a severe drawback to this method, however, which arises due to a lapse of judgement on Airtable's part. Airtable doesn't sync bases that aren't in use, which is fine, but if when you make an API call to this base, it will serve you old data rather than syncing and then delivering you the data. So if the synced database has a "5" in Field X, but you change that value to "7" in your original base, the next API call to the synced database will receive "5" unless someone was active in that base in a web browser. Because of this, any time your clients want to grab data from the synced base, they should first wake the database by sending a simple retrieval, wait 1 minute, and then request again. By now Airtable will have finished its sync, and the database will now provide present data.

Valdemar_T
6 - Interface Innovator
6 - Interface Innovator

@Cameron_Kaiser thanks for the tips. 

Creating view and syncing to new base, can it be automatic, or this should be manual? As we are looking to make it automated, so we can share the newest data with analytics person, to do the works (Hiding some confidential fields)

Changing value later is not an issue for us, although as mentioned we want it automated, at regular itnervals e.g. 1 a day