Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Insert mirror link into a database table via workflow javascript

Avatar

Level 2

Hello,

 

I am using Adobe Campaign Classic v7 build 8936. My objective is to insert the mirror link of a message into a table in the database.

 

I have built a workflow which queries broadlogid and deliveryid from the nmsbroadlogrcp table and then I have written the following javascript:

 

var deliveryData = xtk.queryDef.create(
<queryDef schema="temp:query" operation="select">
<select>
<node expr="@id"/>
<node expr="@id1"/>
</select>
</queryDef>);
try {
var data = deliveryData.ExecuteQuery();

} catch(e) {

}

for each(var value in data)
{
    var mirrorPageURL = nms.delivery.GetMirrorURL(value.@id1,value.@id);

    var queryXML = <campmirrorlinkinfo _operation="insert" xtkschema="ybl:campmirrorlinkinfo"/>;

    /*var queryXML = <campmirrorlinkinfo _operation="insert" xtkschema="ybl:campmirrorlinkinfo" broadLogId={value.@id} deliveryId={value.@id1} mirrorurl={mirrorPageURL}/>;*/

    queryXML.@broadLogId = value.@id;
    queryXML.@deliveryid = value.@id1;
    queryXML.@mirrorurl = mirrorPageURL;
    try{
        xtk.session.Write(queryXML);
    } catch(e) {
    }

}

 

I am able to fetch the mirror link but I am not able to insert it in the table. I am getting the below error:

 

 

error.JPG

 

Can anyone please help me as to how can I achieve this objective and get rid of this error?

 

Thanks in Advance,

Rahul

0 Replies

Avatar

Level 4

Hi @rahuladwani,

 

You need to uncomment the second statement, and comment the first one here. You also need to add a key field to the statement, only then an insert will be successful.

 

/*var queryXML = <campmirrorlinkinfo _operation="insert" xtkschema="ybl:campmirrorlinkinfo"/>; */

var queryXML = <campmirrorlinkinfo _operation="insert" xtkschema="ybl:campmirrorlinkinfo" key="@broadLogId" broadLogId={value.@id} deliveryId={value.@id1} mirrorurl={mirrorPageURL}/>;

// I assume that broadLogId is the primary key of the schema you want to write to.

 

Regards,

Ishan

Avatar

Administrator

Hi @rahuladwani,

Were you able to resolve this query with the given solution or do you need more help? Do let us know.

Thanks!

Avatar

Level 2
Hello Ms Sukrity, I am still looking for the solution to this query.