User Custom Event Variables in Adobe Campaign Standard Workflow

We all are very much familiar with variables in Campaign Classic. But in Standard, it is not easy to declare or use variables inside workflow. There are activities like Load File, Transfer File and other which supports the variables like var.filename or other activities supporting var.reccount in the same way as Classic. But using custom variable is not as simple as ACC and here is one of the ways I tried



The first End Activity is calling the Signal activity and while calling, passing the variables and their values as below


Below  Signal activity is configured with the same set of variables as the End Activity above. Also you have the option to mention the data type of the variables (String and Number in this case).

In the Query Activity (which for no reason I choose the Sending Log as dimension), you can add the variables using the syntax $(var/@varName) format as was used in Classic. Also the $Int exists as well. I tried to check different outcomes as you can see in the screenshot which I will explain below

Here is the sample data from the transition coming out of the query activity.


Just to check that the value of the variable persists in the subsequent process boxes, I added the Enrichment next to the Query and added the same variable with different alias and as expected the value persits.

By default the Signal activity will keep on blinking and the workflow also will not stop. to mitigate that, check the "Stop all task in process" checkbox as shown below.


Observations:

  • The $(var/@varName) and $Int(var/@varName), both creates the temp columns as String, even if you configure the Signal activity with parameter data type as Integer.
  • To get Integer column, you have to convert it to Integer like ToInteger($(var/@varName)). Refer to the below SQL for more details
  • The wait activity between the start and end activity is to ensure that the Signal is fully active before the End calls the Signal. In my example, I gave 5 sec wait, but it may work with lower number as well. Without this workflow throws the same error as the one thrown when the workflow is not running.
INSERT INTO wkf5543860_49_1 (sAddress,sDeliveryLogID,sPropertyCode, iPostStayWaitConverted, sPostStayWaitDollarInt, sPostStayWait, biId) SELECT  DISTINCT  N0.sAddress, encode(digest(COALESCE(text(N0.biBroadLogId), '') || E'broadLogRcp', 'sha256'), 'hex'), E'ABC', CAST(E'2' AS INTEGER), E'2', E'2', N0.biBroadLogId FROM NmsBroadLogRcp N0 WHERE (encode(digest(COALESCE(text(N0.biBroadLogId), '') || E'broadLogRcp', 'sha256'), 'hex') IS NOT NULL) AND ((N0.biBroadLogId > 0 OR N0.biBroadLogId < 0))





Comments

Post a Comment

Popular posts from this blog

Avoid Proxy for HttpClientRequest - IOB-090007 Network error (send(), errno=10054: an existing connection was forcibly closed by the remote host

This is Friday night 8:10 PM and I was frustratingly stuck with an annoying issue on something that I have done so many times, but still unable to figure out what is wrong since last night. Finally it was a silly mistake and I found that. So wanted to capture it so that I don't need to spend another day and half just to figure out why the same thing is not working I was making a call to Silverpop XMLAPI to get the jessionid via the login method. And the code is something like below, very basic one var http = new HttpClientRequest ( "http://api2.ibmmarketingcloud.com/XMLAPI" ); try { http . method = 'POST' ; http . header [ "ClientId_Internal" ] = "XYZABCD" ; http . header [ "ClientSecret_Internal" ] = "DSFDSOFNJSDF" ; http . header [ "Content-Type" ] = "application/x-www-form-urlencoded" ; var reqestBody = "xml=" + encodeURIComponent ( "<
Read more

Adobe Campaign: Call Java Script from Input Form

I came across a scenario where I need to do some custom auditing when some fields are  changed via an input form. So for that I had to call javascript functions from an input form. I have custom schema as cus:Preference with 1:1 join with nms:Recipient. And audit was required to capture who is making change to the preference page if any. Step 1: Create an entry in the input form for the soapCall.  <form>   <container > <!--Enter the form fields here-->   </container>   <leave> <!--servi = "name of the schema where the method is declared"-->     <soapCall name=" auditPreference " service=" cus:Preference ">       <param exprIn="[@id]" type="int"/>       <param exprIn="[@recipientId]" type="int"/>       <param exprIn="[@prefAllCommunications]" type="boolean"/>       <param exprIn="[@prefAllCommunicationsModifiedDat
Read more

Call stored procedure from Adobe Campaign Classic

Image
One member of our team working on a different project asked me if there is a way to call Stored Procedure from Adobe Campaign Classic workflow. He was looking to get an option to receive an output parameter also. So I thought of trying a POC and here is the outcome. In my local instance I had Sql Server and thus thought about testing few other sql server specific features Step 1: Create a basic stored procedure ALTER PROCEDURE USP_GetRecipient     -- Add the parameters for the stored procedure here     @ageGreaterThan int = 0,     @state Varchar(20) = '',     @totalRows int OUTPUT AS BEGIN     SET NOCOUNT ON;        SELECT @totalRows = Count(1) from NmsRecipient r;     SELECT iRecipientId,sEmail from NmsRecipient r where [dbo].[YearsDiff](GETDATE(),r.tsBirth) > @ageGreaterThan and sStateCode = @state     Select top 10 iOfferId,sName from NmsOffer where iOfferId > 0 END  The Procedure  selects recipients filtered by age and state code. I tried to keep an integer and
Read more