Building URL dynamically to view a RITM in 'Workspace mode

[peterengel]

I am trying to build an URL to open a RITM  in ServiceNow (Workspace mode)

When opening the RITM directly from servicenow,the following URL is presented: 

RITM0086545 | Service Operations Workspace | ServiceNow

How can I create this URL dynamically for opening the desired RITM (RITM0086545)? 

I do know how to open the RITM in 'classic mode'. But that is a very inefficient user-interface for us; 

start msedge "https://<server>/now/nav/ui/classic/params/target/sc_req_item.do?sys_id=<RITM-number>"

I need a similar script to open the RITM in 'workspace-mode'

[Vaibhav Chouhan]

In Workspace, records are opened using the now workspace URL pattern, not the classic nav_to.do pattern. The URL is based on the workspace, the table, and the record's sys_id.

The format to open a record in workspace is

https://<instance>/now/sow/record/sc_req_item/<sys_id>

You just need to fetch the sys_id and construct the URL accordingly.

[peterengel]

This is NOT functioning. I get the result "Record not found".

Also tried the following:

' https://smurfitkappa.service-now.com/now/sow/record/sc_req_item.do?sys_id=RITM0086545 '

Now a different page "Page not found" will be loaded.

I am very certain that the RITM0086545 exists in our ServiceNow .

But scripting something to open the same page is not functioning. I am looking for a script to open an RITM from a different application. That application should Start ServiceNow and open the correct RITM.

Of course, in our other application we store the RITM-numbers, not the 'sys_id'. That is something completely NOT understandable for users. So maybe the question should be how to convert RITMnumber into a <sys_id>?

[Vaibhav Chouhan]

No, you cannot directly use the RITM number in the workspace URL. Workspace URLs are strictly based on the sys_id of the record, not the display number like RITM0086545.

So even in Service Operations Workspace, the URL format will always require the sys_id like

/now/sow/record/sc_req_item/<sys_id>

If you only have the RITM number, you must first query the record to get its sys_id and then construct the URL. There is no supported way to open a workspace record directly using the number in the URL.

[peterengel]

Thank you.
Can you show me the way how to 'query the record to get its sys_id'. 

I maybe then can modify my script so that I first get the sys_id and after that, use the response to build the actual script for opening the ticket using SOW.