Help

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

List all options of single select from api

Topic Labels: API
1220 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,
I would to retrieve an array of all single select options from the api. but i dont know if its stored anywhere…
Is it possible?

2 Replies 2

Did this ever get resolved? I am also curious how to accomplish this.

Yes!
This is possible.
Visit the Meta API documentation.
Through this (see image below) GET request you can iterate over the tables (a list), check for your specific name (table name), and once you hit the desired name, iterate over the fields, until you reach the field name / id you desire. If the field type is either singleSelect or multipleSelects then you’ll have an additional options key, and inside it you’ll have choices key, which includes a list of the options to choose from. Inside every choice object, the name key is what you’re asking for.

An Image from the API documentation to illustrate the kind of payload you expect to receive (no singleSelect / multiSelect examples there, these are from my own experience)

image

Enjoy :slightly_smiling_face: