Unanswered

How to filter results of an HTTP request?

(1) Share

Report

Posted on by colonel_claypoo

161

Hi, I have an HTTP Graph request which gets all my Office 365 users. Now, I'd like to filter out those that don't have a specific email extension (.e.g. @contoso.onmicrosoft.com) since the HTTP request also returns users external to our tenant. So far I have used a Select action to select the display name and email address. But, how can I select only those objects which meet the email filter criteria? Thanks for your help.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @colonel_claypoo,

Please just take a try with the data operations –Filter array action.

Using this action could help reduce the number of objects in an array to a subset that matches the criteria you provide.

Here is the doc for your reference:

https://docs.microsoft.com/en-us/flow/data-operations#use-the-filter-array-action

Best regards,

Mabel

Was this reply helpful? Yes No
colonel_claypoo 161 on at

Like (1)

Report

Hi @v-yamao-msft,

thanks for your reply.
Unfortunately, the HTTP action returns an object and thus I can't get the filter action to work.

Doing:
gives the following error:

Changing the expression to @contains(body('HTTP')['value']['mail'], 'com')

I also tried putting the filter condition in the expression of the Select action but also to no avail:

There must be something I'm getting wrong that I'm not seeing.
Any ideas?

Thanks!

Was this reply helpful? Yes No
misterpower 34 on at

Like (0)

Report

I ran into this topic while trying to find out how to filter HTTP REST requests in combination with Business Central. You can filter the results of your HTTP request by conforming to the API guidelines specified in the following documentation: https://github.com/Microsoft/api-guidelines/blob/master/Guidelines.md#97-filtering.

Your filter will look as below. In the query, use $filter as parameter instead of the fields. Your value will contain the complete REST filter string.

When executed, it looks as following:

Was this reply helpful? Yes No