Queries in a HTTP action

(0) Share

Report

Posted on by memorablename

I have an API endpoint: https://api.test.com/people which returns hundreds of people in the below format (each person is a separate object in an array named data. I'm wondering how I can set up my HTTP request in Power Automate to pull only John's record, by just using his name (or email).

I tried putting name in the key field and John Doe in the value field, but it didn't work. I'm assuming because it's inside the data array. Any suggestions on how I can pull John's record by using his name or email?

Here is a sample of data returned when I make a HTTP get request (I apologize in advance for not formatting this code but my last couple of posts got marked as spam, so I'm going to try it this way)

{
"data": [
{
"id": "123456-abcd-98765",
"name": "John Doe",
"emails": [
"johndoe@gmail.com"
]
},
{
"id": "654321-dcba-56789",
"name": "Jane Doe",
"emails": [
"janedoe@gmail.com"
]
}
]
}

All responses (1)

Answers (0)

Kaif_Siddique 2,104 Super User 2024 Season 1 on at

Like (2)

Report

Re: Queries in a HTTP action

Here is one possible solution.
Using the shared json data to Compose then filter data based on email(you can use name as well).
outputs('Compose')['data'] @contains(item()['emails'], 'johndoe@gmail.com')

Let me know if any queries.

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif