search

Azure / logicapps

Azure Logic Apps labs, samples, and tools
MIT License
361 stars 301 forks source link

HTTP connector fails MS Graph query with "Request_UnsupportedQuery" #283

Closed noendscripting closed 3 years ago

noendscripting commented 3 years ago

When sending following MS Graph query "https://graph.microsoft.com/beta/groups?$filter=onPremisesSyncEnabled%20ne%20true" HTTP connector gets following error: { "error": { "code": "Request_UnsupportedQuery", "message": "Unsupported property filter clause operator 'NotEqualsMatch'.", "innerError": { "date": "2021-05-13T14:10:40", "request-id": "0f32659a-5bfe-4a7a-a357-b3093816b9f9", "client-request-id": "0f32659a-5bfe-4a7a-a357-b3093816b9f9" } } }

The exact same query executed with Powershell Invoke-WebRequest or Invoke-RestMethod runs successfully

shailesh-agre commented 3 years ago

If you use the Graph Explorer to run the same query, you will get exact same error.

{ "error": { "code": "Request_UnsupportedQuery", "message": "Unsupported property filter clause operator 'NotEqualsMatch'.", "innerError": { "date": "2021-05-15T03:19:44", "request-id": "0bf5169a-c472-471b-bd6e-3d0eec6d681d", "client-request-id": "0bf5169a-c472-471b-bd6e-3d0eec6d681d" } } }

You can use Graph Explorer to create appropriate query and then use it in any other HTTP client. You may approach Graph forum for further assistance.

noendscripting commented 3 years ago

Could you help me understand how Graph Explorer impacts ability of LogicApps to run Graph queries? I'm don't want to run into scenario where Graph team will send me back to LogicApps space

shailesh-agre commented 3 years ago

As HTTP action is being used and error is coming from the end point called, the issue is on the server side. Graph Explorer is just a tool for doing quick tests - it is being used for isolation.