Skip to main content
December 27, 2019
Answered

How to create and remove a temporary schema in Campaign

  • December 27, 2019
  • 1 reply
  • 857 views

Hello!

 

We have a requirement to create a temporary schema (maybe through a Javascript activity in the Workflow), use it and at the end of the execution remove this schema since it is only used there. 

 

I have this script:

var res = xtk.queryDef.create(
  <queryDef schema="mcc:SiteBrand" operation="select">
       <select>
         <node expr="@siteName"/>
       </select>
       <where>
         <condition expr={"@IsBounceX='Yes'"}/>
       </where>
</queryDef>).ExecuteQuery();

for each(var result in res) {
  xtk.session.Write(<TempMarkets xtkschema="temp:TempMarkets" 
    _operation="insert" siteName={result.@siteName} />);
}

So I want to use this "TempMarkets" in the following activities and then remove it. This is to pass some information that is going to be completed in some other activities and used at the end of the workflow.

 

I haven't found any documentation on how to do this (especially removing it after been used). Would somebody help me know how to do this?

 

Thanks

This topic has been closed for replies.
Correct answer Bani Verma

Hi there,

Please post your query in the following community: https://forums.adobe.com/community/experience-cloud/marketing-cloud/campaign.

Experts here will be able to assist you better. Thanks!

1 reply

Bani Verma
Bani VermaCorrect answer
Legend
January 2, 2020

Hi there,

Please post your query in the following community: https://forums.adobe.com/community/experience-cloud/marketing-cloud/campaign.

Experts here will be able to assist you better. Thanks!