Insert mirror link into a database table via workflow...

[#1]

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:

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

Thanks in Advance,

Rahul

[#2]

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