Hello @VSN ,
You can do this using a single Data Source with two Transform Maps.
The 1st Transform Map would target the Group [sys_user_group] table, and would have field maps for the Name (coalesce enabled) and Manager columns.
To add the roles to the groups you need an "onAfter" Transform Script on the first Transform Map:
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
var roleNames = source.getValue('u_roles').split(',');
var groupId = target.getUniqueValue();
roleNames.forEach(roleName => {
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('group', groupId);
gr.addQuery('role.name', roleName);
gr.query();
if (gr.hasNext()) return;
gr.initialize();
gr.setValue('group', groupId);
gr.setDisplayValue('role', roleName);
gr.insert();
});
})(source, map, log, target);
The 2nd Transform Map would target the Group Member [sys_user_grmember] table, and would map the Name and User ID columns (both with coalesce enabled).
Regards,
Robert
