Transform Map not working as expected

[sankon]

I am trying to update email, phone and location only if there is no existing value for the field. I see that existing value is being updated by new value. Please let me know if I am missing anything. 

I created a transform map as follow

I have the following in my onBefore transform scripts

[Allen Andreas]

Hello,

If you're trying to populate a reference field...you'd need to be supplying the "sys_id" for the related record. So in your source records, does it contain the instance location sys_id for the u_x_location field?

If not, you'd need to find it, possibly by using whatever information you DO have in the source to query against the location table, find the right record, then use that to set your target accordingly.

https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/no-namespace/c_GlideRecordSco...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[sankon]

Hi @Allen A 

Thanks for the response, I only have the display name of the location.

[Allen Andreas]

Ok, so you'd want to gliderecord query your location table using the source location name to find the match and then set the target to the sys_id you found. See documentation I linked above.

Please mark reply as Helpful/Correct, if applicable. Thanks!