Graph API - use variable in filter query

Question

I am calling the Microsoft Graph API's to import user details into an application (which uses REST based connector) from Azure AD.

The application provides a variable (xyz) to be used in order to do incremental user imports.

I need to pass the application variable as ${xyz}. The Graph query seems to be confused about the $ symbol and is throwing an illegal character exception for the $ sign.

Below is the GET query used :

"https://graph.microsoft.com/v1.0/users?$select=id,displayName,userPrincipalName,mail,accountEnabled,onPremisesLastSyncDateTime&$count=true&$filter=onPremisesLastSyncDateTime%20ge%20${xyz}"

Error : [22;39mjava.lang.IllegalArgumentException: Illegal character in query at index 182:

Have tried to use $$, single quotes,backslash,` etc. to fix the issue, but none worked. Any help would be much appreciated.

Doesn't look like an error coming from Graph - you have a Java error. Do you actually substitute real data for the placeholder? — Dmitry Streblechenko
– Dmitry Streblechenko, Commented Dec 20, 2021 at 17:27
Have tried with real data and it has worked for me. Below is an example : graph.microsoft.com/v1.0/… The application converts the Variable into a real value during the runtime — Jesvin
– Jesvin, Commented Dec 21, 2021 at 10:04

RamaraoAdapa · Accepted Answer · 2021-12-21 10:16:41Z

0

As @Dmitry Streblechenko suggested, the error indicates that the variable does not have any real data.

If the real data is passed to the variable, the Graph API call runs successfully

answered Dec 21, 2021 at 10:16

RamaraoAdapa

3,1772 gold badges9 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Graph API - use variable in filter query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related