Which role is required to run Field Map script of Transform Map.

Ishan4 · ‎07-13-2022

I am running a transform map which has script for field map, sys_id is being targeted, which role does it require ?

I suspect, it could be security_admin or agent_security_admin but can any lower role do the job ?

Harneet Sital · ‎07-13-2022

Hi Ishan,

A couple of things -

Transform map transformation based on filed mapping or script will not be impacted by the user you are running it with. Ideally, a user with an import_set_loader role has the right access to transform data if that's what you are looking for.

If the transforms are failing then do check if the user who is running the imports has the right access to the target table.

If the above information is not what you were looking for, please elaborate on your issue and if possible include a screenshot of the error/TMap.

If the answer has helped you, please mark the answer correct/helpful. Thank you.
-Harneet
ServiceNow Certified Technical Architect

View solution in original post

Ishan4 · ‎07-14-2022

Hi Harneet,

I again checked my data, and deleted my previous comment as my script was correct but in my excel the class fields had class' display name/label than its name, that was causing problem.

Thanks for bearing with me.