how to get the RITM sys_id from req sys_id ? which table to look up from ?

chercm
Mega Sage

how to get the RITM sys_id from req sys_id ? which table to look up from ? 

the goal is to get the sctask number from req number 

1 ACCEPTED SOLUTION

Hi,

If you have Request Number then you can use it like below:

Screenshot 2023-12-26 at 5.19.16 PM.png

 

use sysparm_query :

request_item.request.number=REQ0000xxx

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

12 REPLIES 12

@Anil Lande i used api call to open the catalog item and now i need to know the sctask number using api 

please advice on which table can or api command to get that ?

@Anil Lande i tried to use RITM number with request_item as sysparm_query from sc_task table on the rest api explorer. but the issue is that when i use the api to submit the catalog form , it is only giving me the req number. 

Can you please share screenshots how you are passing parameters? Are you using OOB API's?

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

@Anil Lande  Yes I am using now and table api and using get command 

@Anil Lande  @Shruti Khaire here is what i am using 

 

chercm_0-1703591036513.png