How can I update manager field on the user table using LDAP transform map

reddy8055
Tera Contributor

Hi,

We have user data being synced from Oracle HCM and few user records do not have manager field updated and want this to be updated from AD. How can I filter user records with no manager and want to update only those records using transform map?

 

Thanks,

Chandra

4 REPLIES 4

Yousaf
Giga Sage

Hi Reddy,
Can you please try onBefore transform script

 

 if (!target.manager) {
       ldapUtils.setManager(source, target);
   }

OR

 if (!target.manager) {
       source.manager = target.manager;
   }

 

Please note that these are untested scripts.

Mark Correct and Helpful if it helps.


***Mark Correct or Helpful if it helps.***

reddy8055
Tera Contributor

Hi Yousuf,

 

I tried this, its still inserting new records. Is there any way i could only update only manager field if empty?

Colease field is also set and it still creating new records.

 

Thanks

Can you please share the screenshots of your configuration.


***Mark Correct or Helpful if it helps.***

reddy8055
Tera Contributor

Hi,

 

reddy8055_0-1683831523158.png

reddy8055_1-1683831563426.png