Want RITM number on email notification...

[tarun43]

Hi 

I am trigerring a notification through sys_import_set_run table., i want RITM number on this email.

please help

i already tried ${request_item.URI_REF}

it is not working

thanks in advance

[Tony Chatfield1]

Hi, sys_import_set_run is the transform history table, which has no direct relationship to sc_req_item table
Unfortunately your post does not make your configuration clear., perhaps you could share details of your requirement, what exactly are you doing, why you are doing it and the expected outcome?

[tarun43]

after the data is loaded through a catalog item, i want to push a notification to sam admins stating the number of records inserted, updated along with the RITM from which the update or insert is made..

[SeanPT]

Hi,

You might want to make use of Email Scripts to embed custom data/values to your email notification content. Since Email Scripts are server scripts, you can query for the RITM records you needed and then extract any data you want from there.

Notification Email Scripts | ServiceNow Developers

[Tony Chatfield1]

Hi, as @SeanPT suggested a notification email script would be the best way to lookup and populate your ritm data. I would consider an onComplete() transform script to trigger a sysevent (to trigger the notification) and in 1 of the event parameters I would pass in the  transform object,

Map with transformation event scripts (servicenow.com)

Then in the notification email script use this to get the transform start time, then lookup your ritim records using created after the transform start time, but this will only work if you do not run multiple transforms on ritm table at same time, otherwise you should be able to lookup the individual transform rows and utilize the 'target' record in order to find\map the ritm record.