Can someone please post an example of a working ServiceNow URL that obtains sc_cat_item data using data from sc_req_item, like the RITM number?

[Noob_who_needs_]

1) I start by obtaining an SC Task number that I read from the task table.

2) I use that SC Task number to obtain the corresponding RITM number from the sc_task table.

3) I use the RITM number to obtain the sys_id (? maybe this isn't the correct field) from the sc_req_item table.

4) I am wanting to obtain sc_cat_item table data that corresponds to the RITM number so that I can see all the details and fields on the RITM.....would someone please post an example of a URL that does this when all I have is an RITM number?  

Thank you for any guidance you would provide.....

[Noob_who_needs_ · Accepted solution]

Hi Everyone - Here is the solution.  It took an architect in my company to know how to go after this custom field:

https://mycompany.service-now.com/api/now/table/sc_req_item?sysparm_query=number%3DRITM2365756&sysparm_display_value=true&sysparm_fields=variables.my_custom_field

The "&sysparm_fields=variables.my_custom_field" was apparently the key.  

Thank you very much to everyone who helped.