Update data using Update Data activity and Javascript code

[#1]

Hi,

How to update schema using update data activity where input for update data activity should be result of javascript code?

In the above workflow, I have created an expression emailAddress = "" and in the JS code sets the value for emailAddress.

Used newly created field in update data activity as below:

But email field from recipient is not getting updated.

Please let me know what should I do here.

Thanks.

[#2 · Accepted solution]

Hi,

If you have defined variable in javascript as:

vars.email=" ";

Then, you have use this variable in update activity as:

$(vars/@email)

Thanks.

[#3]

Hi,

For vars.varname in js, source field is $(vars/@varname).

You can also cast as needed, $string(vars/@varname) and so on.

If you want rows to have different emails, alter the target table in the js and use that.

Thanks,

-Jon