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.
... View more