API call to find records based on enum values

API & Programming
1

In the code below, I’m trying to find records that have “Confirmed” selected in the “Endorsement” single-select field. It’s not working and the AI is sending me on a wild goose chase of different variation, none of which work. Anyone have any idea how this is done?

{
“command”: “fibery.entity/query”,
“args”: {
“query”: {
“q/from”: “Campaign Template/People”,
“q/select”: [
“fibery/id”,
“Campaign Template/Name”
],
“q/where”: [
[“Campaign Template/Endorsement”, “=”, “Confirmed”]
],
“q/limit”: 3
}
}
}

2

Please check out the API documentation on how to Filter entities

curl -X POST https://YOUR_ACCOUNT.fibery.io/api/commands \
     -H 'Authorization: Token YOUR_TOKEN' \
     -H 'Content-Type: application/json' \
     -d \
      '
         {
           "command": "fibery.entity/query",
           "args": {
             "query": {
               "q/from": "Cricket/Player",
               "q/select": ["Cricket/name", { "Cricket/Batting Hand": ["enum/name"] } ],
               "q/where": ["=", ["Cricket/Batting Hand", "enum/name"], "$hand" ],
               "q/limit": 2
             },
             "params": {
               "$hand": "Right"
             }
           }
         }
       '
3

Thank you! I started there, but I had a typo that I couldn’t see at the time. (One set too many brackets.) When I asked the AI what I was doing wrong, I went way far off base! But it’s working now. Thank you!