pass display value instead of sys_id in sysparm_query of REST API GET method

siddharthakadiy · ‎02-25-2016

Hi all,

I am trying to retrieve incidents of a particular company from ServiceNow via REST API 'get' method. According to the wiki tutorial I have to pass the sys_id of company in sysparm_query parameter to filter out. But I want to pass the display value only; not the sys_id of it as i will not have the sys_id's of all companies in external clients/apps.

Please Help

Thanks

Sid

Brad Tilton · ‎02-25-2016

You should be able to dotwalk to the name field. This query should work to pull incidents where the company field on the incident is "Company Name".

sysparm_query=company.name=Company Name

View solution in original post

Brad Tilton · ‎01-24-2017

You would pass the assignee value as a sys_id typically.