How to update sys id from target source using Transform map

puneetgoels1
Tera Guru

I am getting data from external source using import API and transform map. External source is sending their sys id as well. I need to update same sys id in my target table. But as soon as the record is inserted, it generates it's own sys id and don't use the sys id sent by external source. Even though I have field mapped in transform map. I tried updating the sys id using glide record in business rule or transform map script. but it did not help

 

Can someone please advise how to achieve this?

1 ACCEPTED SOLUTION

Mark Stanger
Giga Sage

Check out 'setNewGuidValue' here.  It allows you to insert a new GlideRecord but override the sys_id with your own.

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/task/t_AddOnBeforeScriptToTransformMap.html

View solution in original post

1 REPLY 1

Mark Stanger
Giga Sage

Check out 'setNewGuidValue' here.  It allows you to insert a new GlideRecord but override the sys_id with your own.

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/task/t_AddOnBeforeScriptToTransformMap.html