Five Number tools
Five Number tools › Graph OData Query Builder

Microsoft Graph OData Query Builder

Build a Microsoft Graph GET query with $filter, $select, $expand, $orderby, $top and $count, pick a resource and its properties, and the tool writes the request URL for you. It adds the ConsistencyLevel header and $count=true when a directory-object query needs advanced query parameters, then hands you the URL, a Graph Explorer link, PowerShell and cURL.

Nothing is sent to Graph from here. The query is built in your browser.
Start from an example
$filter rows suggested values appear for enum and boolean fields
Join rows with
$select properties comma separated, or tap a property below
Request URL
PowerShell (Microsoft Graph)
cURL

How it builds the query

  • System query options are GET only and always carry the $ prefix. The order in the URL does not matter to Graph; this tool writes them as $search, $filter, $orderby, $select, $expand, $top, $count.
  • Values are typed. Strings are wrapped in single quotes with internal quotes doubled, while numbers, booleans, GUIDs and date-time values are left unquoted, the way Graph expects.
  • Advanced queries. On directory objects (users, groups, applications, servicePrincipals, devices and the like) the tool adds the ConsistencyLevel: eventual header and $count=true when you use ne or endsWith, turn on $count, use $search, or combine $filter with $orderby. $search needs the header but not $count.
  • Collections and lambda. Properties that are collections, such as groupTypes or proxyAddresses, are filtered in Graph with a lambda like groupTypes/any(c:c eq 'Unified'). This builder does not write lambda expressions yet, so add those by hand.
  • Preview, not a request. The URL, PowerShell and cURL are generated for you to run with your own token. Nothing here calls Graph or needs a sign-in.

Disclaimer

These tools are provided free and as-is, with no warranty of any kind. The query is built from the OData rules documented by Microsoft, but whether a specific property is filterable or a resource supports a parameter depends on the API. Always test the request against Graph before you rely on it.

fivenumber tools is an independent project and is not affiliated with, sponsored by, or endorsed by Microsoft. Microsoft, Microsoft 365, Microsoft Graph, Entra and SharePoint are trademarks of the Microsoft group of companies.

Send feedback

Found this useful, or hit a snag? Tell me what worked and what would make it better. Your note comes straight to me.

Thanks, your feedback was sent.

I read every note. If you left your email, I may follow up.