Update data using Update Data activity and Javascript code

Avatar

Avatar

tejashriw155148

Avatar

tejashriw155148

tejashriw155148

05-12-2019

Hi,

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

updateData_Query.PNG

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:

updateData_Query1.PNG

But email field from recipient is not getting updated.

Please let me know what should I do here.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

Jyoti_Y
MVP

05-12-2019

Hi,

If you have defined variable in javascript as:

vars.email=" ";

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

$(vars/@email)

Thanks.

Answers (1)

Answers (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

05-12-2019

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