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.

All responses (3)

Answers (0)

misterpower 34 on at

Like (0)

Report

Re: How to filter results of an HTTP request?

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:
colonel_claypoo 161 on at

Like (1)

Report

Re: How to filter results of an HTTP request?

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!
v-yamao-msft on at

Like (0)

Report

Re: How to filter results of an HTTP request?

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