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

@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

Thank You so much it worked

Hi,

Are you using scripted Rest API here? If yes and RIT Number is getting passed to you then do a Glide Record on RITM Table and you can find the number as shown below:

var getNumber = request.pathParam.YOUR Parameter Name;

var gr = new GlideRecord('sc_req_item');

gr.addQuery('number',getNumber);

gr.query();

if(gr.next()){

var id = gr.sys_id;

gs.info('sys ID is'  + id);

}

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke