


I have to update the data which is already available in custom schema using API. For that I am using Below java script snippet.
Workflow is Running without any error. But The data is not updated in tables. Please help me to solve this.
var query = xtk.queryDef.create(
<queryDef schema= "temp:fileImport" operation="select">
<select>
<node expr="firstName"/>
<node expr="lastName"/>
<node expr="email"/>
<node expr="city"/>
</select>
</queryDef>)
var results = query.ExecuteQuery();
for each ( var record in results.fileImport) {
logInfo("record --"+record.firstName);
xtk.session.Write(<query xtkschema="ram:customer" _operation="update" _key="@firstName" city = {record.city} firstName={record.firstName} />);
}
Regards,
Ramprakash.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi Ramprakash,
It can be that your query doesn't return anything so there is no update.
You may fetch temp schema like this:
var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1);
logInfo(schemaName);
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="firstName"/>
<node expr="lastName"/>
<node expr="email"/>
<node expr="city"/>
</select>
</queryDef>);
If you are sure in this above, you may try this for writing:
var some_variable= <customer
xtkschema="ram:customer"
_key="@firstName"
_operation="Update"
city = {record.city}
firstName={record.firstName}
/>;
xtk.session.Write(some_variable);
Views
Replies
Total Likes
Hi Ramprakash,
It can be that your query doesn't return anything so there is no update.
You may fetch temp schema like this:
var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1);
logInfo(schemaName);
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="firstName"/>
<node expr="lastName"/>
<node expr="email"/>
<node expr="city"/>
</select>
</queryDef>);
If you are sure in this above, you may try this for writing:
var some_variable= <customer
xtkschema="ram:customer"
_key="@firstName"
_operation="Update"
city = {record.city}
firstName={record.firstName}
/>;
xtk.session.Write(some_variable);
Views
Replies
Total Likes