how to Get sys_id by using RITM number

pankaj39
Kilo Explorer

‎12-06-2021 11:45 PM

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

 

 

 

Labels:
0 Helpfuls

Ankur Bawiskar
Tera Patron

‎12-06-2021 11:58 PM

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

find_real_file.png

Output:

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
Preview file
13 KB
Preview file
57 KB

Ankur Bawiskar
Tera Patron
In response to Ankur Bawiskar

‎12-07-2021 12:28 AM

@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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Tony Chatfield1
Kilo Patron

‎12-06-2021 11:58 PM

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

 

View solution in original post

0 Helpfuls

pankaj39
Kilo Explorer
In response to Tony Chatfield1

‎12-07-2021 12:17 AM

Thank You so much it worked

0 Helpfuls