Reference value field name

[jacopo_pulici]

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

[Ankur Bawiskar]

Hi Jacopo,

Why not use reference field name if you are already getting the employee number from third party and that column exists on user table?

Do you want to go with source script for this field map instead of direct mapping?

Regards

Ankur

[jacopo_pulici]

Hi Ankur,

I can't use the transform map since I'm using a Web Service to pull in the data.

Therefore I need to script this in order to run it at scheduled time (every night I need to pull in new data, if any).

Thank you,

Jacopo

[taylor21]

Did you ever find a solution for this? I am trying to do the same thing...

[Swati44]

Even I have the same question, did you get the answer?