Examples of JavaScript code in workflows javascript-in-workflows

These examples show how you can use JavaScript code in a workflow:

Learn more about static and non-static SOAP methods.

In these examples, the ECMAScript for XML (E4X) extension is used. With this extension, you can combine JavaScript calls and XML primitives in the same script.

To try out these examples, follow these steps:

Example 1: write to the database write-example

To write to the database, you can use the static Write method on the xtk:session schema:

Step 1: compose a write request

You can add, update, and delete records.

Insert a record

Because the insert operation is the default operation, you do not need to specify it.

Specify this information as XML attributes:

Example:

var myXML = <recipient xtkschema="nms:recipient"
    firstName="Isabel"
    lastName="Garcia"
    email="isabel.garcia@mycompany.com"/>

Update a record

Use the _update operation. Learn more.

Specify this information as XML attributes:

Example:

var myXML = <recipient xtkschema="nms:recipient"
    status="Client"
    email="isabel.garcia@mycompany.com"
    operation="_update"
    _key="@email"/>

Delete a record

Use the DeleteCollection method. Learn more.

Specify this information:

Example:

xtk.session.DeleteCollection(
    "nms:recipient",
    <where>
        <condition expr="[@email] = 'isabel.garcia@mycompany.com'"/>
    </where>,
    false
    )

Step 2: write the record

Call the non-static Write method on the xtk:session schema:

xtk.session.Write(myXML)

No value is returned for this method.

Add the complete code to a JavaScript code activity in the workflow:

var myXML = <recipient xtkschema="nms:recipient"
    firstName="Isabel"
    lastName="Garcia"
    email="isabel.garcia@mycompany.com"/>

xtk.session.Write(myXML)

This video shows how to write to the database:

Example 2: query the database read-example

To query the database, you can use the non-static xtk:queryDef instance method:

Step 1: compose a query

Specify the XML code for a queryDef entity.

Syntax:

<queryDef schema="nms:recipient" operation="">
    <!-- select, where, and orderBy clauses as XML elements -->
</queryDef>

Specify this information:

You can use these operations:

Write the select, where, and orderBy clauses as XML elements:

Step 2: create a query object

To create an entity from the XML code, use the create(content) method:

var query = xtk.queryDef.create(
    <queryDef schema="nms:recipient" operation="select">
    …
    </queryDef>)

Prefix the create(content) method with the schema of the entity to be created.

The content argument is a string argument and is optional. This argument contains the XML code that describes the entity.

Step 3: run the query

Follow these steps:

Results of a select operation

All the matches are returned as a collection:

<recipient-collection>
    <recipient email="jane.smith@mycompany.com">
    <recipient email="john.harris@mycompany.com">
</recipient-collection>

To iterate over the results, use the for each loop:

for each (var rcp in res:recipient)
    logInfo(rcp.@email)

The loop includes a local recipient variable. For each recipient that is returned in the collection of recipients, the recipient’s email is printed out. Learn more about the logInfo function.

Results of a getIfExists operation

Each match is returned as an element:

<recipient id="52,378,079">

If there is no match, then an empty element is returned:

<recipient/>

You can refer to the primary key node—for example, the @id attribute:

if (res.@id !=undefined)
    { // match was found
    …
    }

Result of a get operation

One match is returned as an element:

<recipient id="52,378,079">

If there is no match, then an error is returned.

Result of a count operation

An element with the count attribute is returned:

<recipient count="200">

To use the result, refer to the @count attribute:

if (res.@count > 0)
    { // matches were found
    …
    }

For the select operation, add this code to a JavaScript code activity in the workflow:

var myXML =
<queryDef schema="nms:recipient" operation="select">
    <select>
        <node expr="@firstName"/>
        <node expr="@lastName"/>
    </select>
</queryDef>

var query = xtk.queryDef.create(myXML)

var res = query.ExecuteQuery()

for each (var rcp in res.recipient)
    logInfo(rcp.@firstName + " " + rcp.@lastName)

Because the select operation is the default operation, you do not need to specify it.

This video shows how to read from the database:

Trigger a workflow trigger-example

You can trigger workflows programmatically, for example, in technical workflows or to process information that a user has entered on a web application page.

Workflow triggering works through the use of events. You can use these features for events:

You can trigger workflows in different ways:

Syntax of the PostEvent method:

PostEvent(
    String     //ID of the target workflow
    String     //Name of the target activity
    String     //Name of the transition to be activated in case of multiple transitions
    XML        //Event parameters, in the <variables/> element
    Boolean    //To trigger the target workflow only once, set this parameter to true.
)

In this example, upon completion of the workflow, a short text is passed to the signal activity of the wkfExampleReceiver workflow:

var strLabel = "Adobe Campaign, Marketing that delivers"
xtk.workflow.PostEvent(
    "wkfExampleReceiver",
    "signal",
    "",
    <variables strLine={strLabel}/>,
    false)

Because the last parameter is set to false, the wkfExampleReceiver workflow is triggered every time the initial workflow is completed.

When you trigger workflows, bear these principles in mind:

This video shows how to use static API methods:

This video shows how to trigger workflows:

Interact with the database interact-example

These examples show how to perform these actions:

Follow these steps:

Syntax of the queryDef method with a select clause

<queryDef schema="schema_key" operation="operation_type">
    <select>
        <node expr="expression1">
        <node sql="expression2">
    </select>
    <where>
        <condition expr="expression1"/>
        <condition sql="expression2"/>
    </where>
    <orderBy>
        <node expr="expression1">
        <node sql="expression2">
    </orderBy>
    <groupBy>
        <node expr="expression1">
        <node sql="expression2">
    </groupBy>
    <having>
        <condition expr="expression1"/>
        <condition sql="expression2"/>
    </having>
</queryDef>

Create method

Example 1: select records and write to the journal

The internal names of the workflows that are located in the wfExamples folder are selected. The results are sorted by internal name, in ascending order, and written to the journal.

var query = xtk.queryDef.create(
    <queryDef schema="xtk:workflow" operation="select">
        <select>
            <node expr="@internalName"/>
        </select>
        <where>
            <condition expr="[folder/@name]='wfExamples'"/>
        </where>
        <orderBy>
            <node expr="@internalName" sortDesc="false"/>
        </orderBy>
    </queryDef>
    )

var res = query.ExecuteQuery()
for each (var w in res.workflow)
    logInfo(w.@internalName)

Example 2: delete records

The first name, the last name, the email and the ID of all the recipients who are named Chris Smith are selected. The results are sorted by email, in ascending order, and written to the journal. A delete operation is used to delete the selected records.

// Build the query, create a query object and hold the object in a variable
var query = xtk.queryDef.create(
        <queryDef schema="nms:recipient" operation="select">
            <select>
                <node expr="@firstName"/>
                <node expr="@lastName"/>
                <node expr="@email"/>
                <node expr="@id"/>
            </select>
            <where>
                <condition expr="[folder/@label]='Recipients'"/>
                <condition expr="[@lastName]='Smith'"/>
                <condition expr="[@firstName]='Chris'"/>
            </where>
            <orderBy>
                <node expr="@email" sortDesc="false"/>
            </orderBy>
        </queryDef>
)

//Run the query using the ExecuteQuery method against the created object
var res = query.ExecuteQuery()

//Loop through the results, print out the person's name and email, then delete the records
for each (var rec in res.recipient)
    {
     logInfo("Delete record = Email: " + rec.@email + ', ' + rec.@firstName + ' ' + rec.@lastName)
     xtk.session.Write(<recipient xtkschema="nms:recipient" _operation="delete" id={rec.@id}/>)
    }

Example 3: select records and write to the journal

In this example, a non-static method is used. The email and birth year of all the recipients whose information is stored in the 1234 folder and whose email domain name starts with “adobe” are selected. The results are sorted by birth date in descending order. The recipients’ email is written to the journal.

var query = xtk.queryDef.create(
<queryDef schema="nms:recipient" operation="select">
    <select>
        <node expr="@email"/>
        <node sql="sEmail"/>
        <node expr="Year(@birthDate)"/>
    </select>
    <where>
        <condition expr="[@folder-id] = 1234 and @domain like 'adobe%'"/>
        <condition sql="iFolderId = 1234 and sDomain like 'adobe%'"/>
    </where>
    <orderBy>
        <node expr="@birthDate" sortDesc="true"/>
    </orderBy>
</queryDef>
)

var res = query.ExecuteQuery()
for each (var w in res.recipient)
    logInfo(w.@email)

Write method

You can insert, update, and delete records. You can use the Write method on any schema in Adobe Campaign. Because this method is static, you do not need to create an object. You can use these operations:

Example 1: insert or update a record

xtk.session.Write(
<recipient
    xtkschema="nms:recipient"
    _operation="insertOrUpdate" _key="@email"
    lastName="Lennon"
    firstName="John"
    email="johnlennon@thebeatles.com"
/>
)

Example 2: delete records

This example combines a static method and a non-static method.

var query=xtk.queryDef.create(
<queryDef schema="nms:recipient" operation="select">
    <select>
        <node expr="@Id"/>
    </select>
    <where>
        <condition expr="[@email]='johnlennon@thebeatles.com'"/>
    </where>
</queryDef>
);

var res = query.ExecuteQuery()
for each (var w in res.recipient) {
xtk.session.Write(
    <recipient xtkschema="nms:recipient" _operation="delete" id={w.@id}/>
);
}

This video shows how to use non-static API methods:

This video shows an example of use of a non-static API method in a workflow:

Related topics

API documentation