how to Get sys_id by using RITM number

[pankaj39]

HI Buddy,

Any idea how to get sys_id of a record using RITM number

medium is REST API

can you please forward me the REST api url

[Ankur Bawiskar]

Hi,

you can use this endpoint which is OOB for Table API

Method: GET

Sysparm_query -> number=RITM0010066

https://instanceName.service-now.com/api/now/table/sc_req_item?sysparm_display_value=number%3DRITM0010066&sysparm_fields=sys_id&sysparm_limit=1

Output:

Regards
Ankur

[Ankur Bawiskar]

@pankaj 

Glad that you got the approach.

Did you accidentally marked other response as correct?

I believe I covered that above pretty well with the screenshots.

Kindly mark the answer correct based on response given quickly and accurately..

Regards
Ankur

[Tony Chatfield1 · Accepted solution]

Hi, I would use the RESDT table API
https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_TableAPI

You can build\test a solution in a PDI using the Rest API explorer
https://yourInstance.service-now.com/nav_to.do?uri=%2F$restapi.do

it would look something like this using OOB example

https://yourInstance.service-now.com/api/now/table/sc_req_item?sysparm_query=number%3DRITM0000001&sysparm_fields=sys_id

[pankaj39]

Thank You so much it worked