Hi guys,
I need your with a specific requirement.
I have in place a web service that pulls in some data. It works, all good.
I need to insert one of this data (Employee Number) in a custom table referenced field (referenced to the sys_user table).
My goal is to pass the employee number obtained by the Web Service (and that is actually already present in the sys_user table) and then automatically fill in the reference field in the sitcom table, matching the related User Name from the sys_user table.
I'd like to basically script what already happens in the transform map, selecting the Reference value field name.
Thank you,
Jacopo
