How to pass a reference to variable in Update query | Community
Skip to main content
Level 2
February 1, 2023
Solved

How to pass a reference to variable in Update query

  • February 1, 2023
  • 1 reply
  • 2182 views

Hi,

 

I have to insert/update data to Campaign classic DB from a JS activity. I receive the info in a webservice call, so i read the date and loop and have to pass the details in an update query. But the query is only accepting values not a reference to variable which I read from the call. please advice how an I pass a reference to var?

 

I have the below script,

 

workEmail is the variable with value I read from the webservice call data.

 

var updateEmp = <recipient xtkschema="nms:recipient"
operation="_update" _key="@email"

email= workEmail
futRetNot="true" />

xtk.session.Write(updateEmp);

 

I get this error,

 

 js JST-310000 Error while compiling script 'tWKF945/js' line 79: invalid XML attribute value (line=' email= workEmail' token='workEmail').

 

How can I pass the workEmail?

 

Thanks,

Sirisha

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Manoj_Kumar

Hello @sirikambampati 

 

You can pass it like this.

email= {workEmail}

 

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
February 1, 2023

Hello @sirikambampati 

 

You can pass it like this.

email= {workEmail}

 

Manoj     Find me on LinkedIn
Level 2
February 2, 2023

Thank you @_manoj_kumar_