How to update dot walk field in Transform map

Nisha30 · ‎01-23-2025

Hi Community,

Need help here.

we have in our table 'cmdb_ci_wap_network' brought the field on the form by dot walk i.e "vendor.website"

How do I map the value from the source (u_website) to update in cmdb_ci_wap_network table to the above field vendor.website

Thanks

Ankur Bawiskar · ‎01-23-2025

@Nisha30

you cannot have dot walked field in field map.

In your existing transform map which is on Target table "cmdb_ci_wap_network" create an onAfter transform script & you can handle this

something like this in onAfter transform script.

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here
    var sourceValue = source.u_website;
    if (target.vendor) {
        var vendorRec = target.vendor.getRefRecord(); // give the correct field name for vendor
        vendorRec.website = sourceValue; // give the correct website field
        vendorRec.update();
    }

})(source, map, log, target);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Nisha30 · ‎01-23-2025

yes company is a field in the form

Ankur Bawiskar · ‎01-23-2025

@Nisha30

Correct.

So either company should be populated via transform map if it's an insert happening

OR

if update is happening on target record then company should be present or created fresh

If both the above cases the transform script I shared will work fine as it will find the company in onAfter transform script and update the website field on Company

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ankur Bawiskar · ‎01-27-2025

@Nisha30

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Nisha30 · ‎01-27-2025

hi @Ankur Bawiskar

Thanks for responding. Tried below but if you can see nothing has been updated in this table

Thanks

Ankur Bawiskar · ‎01-27-2025

@Nisha30

did company/vendor field get populated? if yes then onAfter will work fine.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader