Set Filter on Send HTTP Request

(0) Share

Report

Posted on by BS10

658

Hi,

I have a send an http request function in a flow and I would like to filter the results to equal a piece of text which is set on

extensionAttribute4. Please see below which is the output from my send http request, I am unsure on how to filter the attribute to match an object.

Please see URI below

graph.microsoft.com/v1.0/users?$count=true&$select=mail,department,displayName,companyName,onPremisesExtensionAttributes&$filter=accountEnabled eq true and companyName eq 'Test' and department eq 'Test'

Please see outputs below from the send http request property.

"value": [
{
"mail": "test@co.uk",
"department": "Department",
"displayName": "Test",
"companyName": "Test",
"onPremisesExtensionAttributes": {
"extensionAttribute1": null,
"extensionAttribute2": null,
"extensionAttribute3": null,
"extensionAttribute4": Test,
"extensionAttribute5": null,
"extensionAttribute6": null,
"extensionAttribute7": null,
"extensionAttribute8": null,
"extensionAttribute9": null,
"extensionAttribute10": null,
"extensionAttribute11": null,
"extensionAttribute12": null,
"extensionAttribute13": null,
"extensionAttribute14": null,
"extensionAttribute15": null
}

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (3)

Report
Hi @BS10,

Try the below

URI

https://graph.microsoft.com/v1.0/users?$select=mail,department,companyName,onPremisesExtensionAttributes&$filter=companyName eq 'Test' and department eq 'Test' and onPremisesExtensionAttributes/extensionAttribute4 eq 'Test'&$count=true

And don't forget to add the ConsistencyLevel key with the eventual value as a custom header as well (like the count that is required for the filtering).

https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http#optional-query-parameters

Was this reply helpful? Yes No
BS10 658 on at

Like (0)

Report

Hi @Expiscornovus,

Thank you for your reply, will this only return the first 999 items? If so, is there a way around this please?

Thanks!

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @BS10,

Do you see a paging link in your response (i.e. @odata.nextLink)?

https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http#response

It should be possible to step through the pages of your results as well via the Graph API:

https://learn.microsoft.com/en-us/graph/paging?tabs=http

Was this reply helpful? Yes No
BS10 658 on at

Like (0)

Report

Thank you @Expiscornovus. This works perfect, I can see my odata.count is 1426 and I can see a odata.nextLink, could you please advise on the next step to get the items after 999? I also think the outputs is only giving me the first 100 at the moment, can I alter that using $top=999?

Was this reply helpful? Yes No