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

How to fetch the possible values from the table through an airtable api

1111 6
Showing results for 
Search instead for 
Did you mean: 

Hi Team
While working on the airtable api and fetching the data from the table.
We have a column named as Type which is a single select . We have set some possible values inside it like [
“Blog Post”,

Please let me know if there is any way through which we can access these values via the api’s. I have not found any way so far.
I have also attached a image with this.
Screenshot from 2020-05-01 18-54-55

Looking forward to hear from you.
Best Regards,
Gaganjot Kaur

6 Replies 6

Hi Team.
I am still waiting for your reply.

Gaganjot Kaur

Hey there! I don’t think that specific endpoint is available. What is the use case here, as it seems as though there could be a simpler way to get what you need

Thanks for the updates @andywingrave . The use case here is we want to display these values to the front end. Currently, we have to use these values manually. And each time if there is any change in the values. We have to make changes manually. So, I was looking for some way in which we can fetch these values dynamically via the API .

I have the same problem. Did you find a solution to this?

I also would like to have the option to return all “possible values” as an array for a given field. The only way something similar I think can be done is by retrieving all values and then reducing them down so you get an array of all “used values”.

This is only available through the metadata API (form signup was here), but apparently they’ve shut that down for now (unless you’re grandfathered in because you got in during the few months that it was offered).

Maybe it’s available for everyone now, but I don’t know. You may want to email to ask them about when more people will have access to the metadata API, and then post back here with their answer so other people know as well.