Skip to main content

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


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 [
“Video”,
“Article”,
“Blog Post”,
“Webinar”
]

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.

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

6 replies

  • Author
  • Participating Frequently
  • 6 replies
  • May 4, 2020

Hi Team.
I am still waiting for your reply.

Regards,
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


  • Author
  • Participating Frequently
  • 6 replies
  • May 4, 2020

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 .


Hello,
I have the same problem. Did you find a solution to this?
Thanks!


  • New Participant
  • 1 reply
  • May 9, 2022

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”.


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8745 replies
  • May 9, 2022

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 support@airtable.com 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.


Reply