I am trying to make a REST API GET call to Service-Now to see if any user is found based on a variable of Calling Party ANI. I am only looking for a record and will make a decision if one exists or does not exist.
I can make a successful REST GET using a "static" number entry but I am unable to craft the REST URL using a variable "sANI" that changes on every inbound call.
This works
"https://xxxxxxxxxxxxdev.service-now.com/api/now/table/sys_user?sysparm_query=mobile_phoneENDSWITH4959&sysparm_fields=user_name&sysparm_limit=1"
This fails, I have tried "sANI" [sANI] 'sANI' +sANI+ =sANI
"https://xxxxxxxxxxxdev.service-now.com/api/now/table/sys_user?sysparm_query=mobile_phoneENDSWITH'sANI'&sysparm_fields=user_name&sysparm_limit=1"
Any assistance would be greatly appreciated.