You’re offline. This is a read only version of the page.
19
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"
]
}
]
}
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
Share
Report
All responses (
Answers (
