# What is the best way to get the ID of drop down options?

**URL:** <https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719>\
**Category:** Get Help\
**Created:** [April 18, 2022, 4:39pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719 "2022-04-18T16:39:12Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [April 18, 2022, 4:39pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/1 "2022-04-18T16:39:12Z")

</div>

I’m looking to create a program that updates many records at once in my contacts database. I currently have three single-select fields that I’d like to map responses to.  
When I get the schema via api, it does not appear to include the drop-down “sub-types.” I’d like to expedite finding the associated IDs for each of the options in all three drop downs.  
Any recommendations of best practice here?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 18, 2022, 6:47pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/2 "2022-04-18T18:47:07Z")

</div>

The options for a single select are in effect entities of the single select database (a.k.a. type) so querying the schema will not get you them. You need to do an entity query to find out the ids of each option.

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [April 18, 2022, 11:18pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/3 "2022-04-18T23:18:43Z")

</div>

Thanks @Chr1sG  
I was having trouble querying for the dropdowns but tried the Fibery type instead of the fibery/name value and was successful. Example below for people in the future:

```auto
{
      "command": "fibery.entity/query",
      "args": {
        "query": {
          "q/from": "${app}/${dropdownName}_${app}/{$typeName}",
          "q/select": ["fibery/rank","enum/name","fibery/id"],
          "q/limit": 10
        }
      }
}

```

---

<div class="post-metadata">

**Author:** ![Haslien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haslien/32/493_2.png) [@Haslien](https://community.fibery.io/u/Haslien)\
**Post date:** [April 20, 2022, 1:10pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/5 "2022-04-20T13:10:42Z")

</div>

I’ve struggled with this before too. I had to look at the incoming HTTP requests from Fibery to find the UUID’s of options in various dropdowns/selects.

It would be handy if there was some `[Item UUID]` argument for formulas. That way we could easily just create a temporary field to copy the ID when opening the field. That or some keyboard shortcut to hold while clicking on an option to copy its UUID to clipboard—or perhaps some hidden field for when you hold ALT and click “New Field or Relation”

 ![](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/822003a65a97c8b524d165c5da5df19a3fc2ca8d.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [April 20, 2022, 1:24pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/6 "2022-04-20T13:24:15Z")

</div>

I guess you’ve probably have thought of it, but you could make text field (called UUID) and define a scheduled automation to get the ID. Then just ‘Run now’ to populate all of them at once:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ea21167505922bde449229258c75e3557654ca59.png)

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [April 21, 2022, 2:21pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/7 "2022-04-21T14:21:29Z")

</div>

This is quite creative. I think it’s a great way for people who are not using the API to extract the information.

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [July 31, 2024, 4:10pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/8 "2024-07-31T16:10:54Z")

</div>

Hey Chris, has a method for listing all available UUIDs for select fields/state fields been added to the official documentation?  
I’m having some trouble navigating it so it’s possible they have and I couldn’t find the documentation.

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [July 31, 2024, 4:37pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/9 "2024-07-31T16:37:43Z")

</div>

Adding in case someone is googling how to get the Fibery ID of all options for a State field:

```auto
{
      "command": "fibery.entity/query",
      "args": {
        "query": {
          "q/from": "${fibery/Type}",
          "q/select": ["fibery/rank","enum/name","fibery/id"],
          "q/limit": 10
        }
      }
}

```

Fibery’s Type name for state fields follows the schema workflow/state\_{$app}/{type}

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 31, 2024, 4:37pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/10 "2024-07-31T16:37:56Z")

</div>

> [@helloitse](#):
>
> Hey Chris, has a method for listing all available UUIDs for select fields/state fields been added to the official documentation.

Not sure what you’re looking for - the explanation about select fields (enums) is on this page:  
[https://the.fibery.io/@public/User\_Guide/Guide/Field-API-263](https://the.fibery.io/@public/User_Guide/Guide/Field-API-263)

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [July 31, 2024, 4:40pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/11 "2024-07-31T16:40:26Z")

</div>

Thanks for the link. Unfortunately It’s not there.  
As this post suggests sometimes it is necessary to get the ID’s of all the options for a collection field. It’s possible to find this information by querying the API but there is no mention of how to do so in the documentation.  
Seems like a bit of an oversight. Can this be added?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 31, 2024, 4:48pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/12 "2024-07-31T16:48:33Z")

</div>

So, the options are entities, and getting their uuids (or any property for that matter) is just a case of using the standard [entity query](https://the.fibery.io/@public/User_Guide/Guide/Entity-API-264) (as you showed in your example post above).  
The only thing that differs from ‘normal’ entities are the things that are specific to enums (how the type is named, and what its field titles are) which is what is covered in the link I just shared.

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [July 31, 2024, 5:45pm UTC](https://community.fibery.io/t/what-is-the-best-way-to-get-the-id-of-drop-down-options/2719/13 "2024-07-31T17:45:31Z")

</div>

So can the documentation be update to be clear and to include the examples above?