Query "Caller" Using email ID

[thayanc]

I am trying to query the "caller" table using caller's email ID instead of sys_ID.

Query using sys_id - working

https://company.service-now.com/nav_to.do?uri=%2Fsys_user.do%3Fsys_id%{{sys_id}}%26sysparm_view%3Des...

Query using email - not working

https://company.service-now.com/nav_to.do?uri=%2Fsys_user.do%3Femail%{{email_id}}%26sysparm_view%3De...

Please let me know if I could query the Caller table using caller's email.

[Anurag Tripathi · Accepted solution]

This will work

https://<instance name>.service-now.com/sys_user.do?sysparm_query=email=<email>

[Faiz Ahmed Moha · Accepted solution]

Hi @thayanc, 

Please try the below sample query.

https://company.service-now.com/sys_user_list.do?sysparm_query=email%3Dabel.tuter@example.com&syspar...

Please mark 'helpful' and 'Accept solution' if this works for you.

Regards

Faiz Ahmed.

[Dr Atul G- LNG]

Hi @thayanc 

Might be helpful

https://servicenowguru.com/scripting/client-scripts-scripting/parse-url-parameters-client-script/

@Anurag Tripathi Whats your thoughts.

[Anurag Tripathi · Accepted solution]

This will work

https://<instance name>.service-now.com/sys_user.do?sysparm_query=email=<email>

[thayanc]

Hi Anurag,

Thank you for the quick response. My request was very simple, and your answer was what I was looking for. 

Regards,

Thaya

[Dr Atul G- LNG · Accepted solution]

You got answer from expert. 

[thayanc]

Hi,

Thank you for the response. My request is very simple, I am not using any scripting or program to pop-up the ServiceNow page... I am just looking to see if I could pop-up a ServiceNow Caller info page just by using the email ID, looking for a simple url, just like:

https://company.service-now.com/nav_to.do?uri=sys_user.do?sys_id=1a2b333f377bd110d365dd98436d43f4%26...