Filtering JSON to retrieve specific key/values

Patrick Steil

I am calling an API which retrieves a list of servers and the apps within those servers.  Here is the pertinent json:

```
[
    {
        "id": "257115",
        "label": "SERVER1",
        "apps": [
            {
                "id": "800662",
                "label": "www.site1.com"
            },
            {
                "id": "812522",
                "label": "www.site2.com"
            }
        ]
    },
    {
        "id": "268339",
        "label": "SERVER2",
        "apps": [
            {
                "id": "832438",
                "label": "www.site3.com"
            },
            {
                "id": "832441",
                "label": "www.site4.com"
            }
        ]
    }
]
```

What I want to do is - based on in input variable, return all the "apps" for one server id at a time, say "257115" - so it would only return:
```
"apps": [
            {
                "id": "800662",
                "label": "www.site1.com"
            },
            {
                "id": "812522",
                "label": "www.site2.com"
            }
        ]
```

Any docs or videos showing how to do this?
Thanks!

Michael Udinski

I'd probably use Array: Find First Element - or Array: Find All Matched Elements (if there's more than of that ID)

https://docs.xano.com/working-with-data/functions/data-manipulation/arrays

Patrick Steil

Thanks for the answer!  I'll try it out!