Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

Callback using JSSP

Avatar

Level 4

Hi Team,

 

We have integrated a custom communication channel in Adobe Campaign Classic V8, the vendor is looking for a call back url to share the delivery status back to Campaign, can anyone help on how to implement call back in Adobe Campaign Classic? Thanks much in advance.

 

Thanks,

Shine v.v

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Community Advisor

Hello @ShineVv0823 

 

I am assuming you are working with SMS/WA integration and want to store the delivery status in AC.

 

You can create a JSSP which will accept the query parameters like boardlogId and status

the URL would look like this https://YOUR_INSATNCE_URL/cus/page.jssp?id=DYNAMIC_BOARDLOG_ID&status=DELIVERY

 

In your jssp page you can retrieve this value and update the status with xtk.session write method

 

How to retrieve broadlogId and status 

var boardlog_id= request.getParameter('id'); 
var status= request.getParameter('status'); 

 

 


     Manoj
     Find me on LinkedIn

Avatar

Administrator

Hi @ShineVv0823,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!



Sukrity Wadhwa

Avatar

Level 4

Hi @Manoj_Kumar_ , @Sukrity_Wadhwa ,

 

Thanks for the help,

 

We are working it out. we are getting the below error when trying to load and update Rcp delivery logs. Though the delivery log id (17819000) exists. Could you please help debug the issue. Thanks in advance.

 

var deliveryLogs = NLWS.nmsBroadLogRcp.load(record.$id);

 

Error : 

WDB-200001 SQL statement 'SELECT   B0.iBroadLogId, B0.sAddress, GetEmailDomain(B0.sAddress), B0.iStatus, B0.iFlags, IsBitSet(B0.iFlags , 1), case when IsBitSet(B0.iFlags , 2) = 2 then 1 else 0 end, case when IsBitSet(B0.iFlags , 4) = 4 then 1 else 0 end, case when IsBitSet(B0.iFlags ,  = 8 then 1 else 0 end, B0.iMsgId, B0.tsEvent, B0.tsLastModified, B0.iDeliveryId, B0.iRecipientId, B0.iServiceId, B0.sSmsExternalId, B0.sWapExternalId, B1.sMd5, COALESCE(D2.sLabel, '') || E' (' || COALESCE(D2.sInternalName, '') || E')', W3.iWebEventId, COALESCE(R4.sLastName, '') || E' ' || COALESCE(R4.sFirstName, '') || E' (' || COALESCE(R4.sEmail, '') || E')', COALESCE(S5.sLabel, '') || E' (' || COALESCE(S5.sName, '') || E')', COALESCE(S7.sLabel, '') || E' / ' || COALESCE(R8.sLastName, '') || E' ' || COALESCE(R8.sFirstName, '') || E' (' || COALESCE(R8.sEmail, '') || E')' FROM NmsBroadLogRcp B0 JOIN NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) JOIN NmsDelivery D2 ON (D2.iDeliveryId = B0.iDeliveryId) JOIN NmsWebEvent W3 ON (W3.iBroadLogRemktId = B0.iBroadLogId) JOIN NmsRecipient R4 ON (R4.iRecipientId = B0.iRecipientId) JOIN NmsService S5 ON (S5.iServiceId = B0.iServiceId) JOIN NmsSubscription S6 ON (S6.iRecipientId = B0.iRecipientId AND S6.iServiceId = B0.iServiceId) JOIN NmsService S7 ON (S7.iServiceId = S6.iServiceId) JOIN NmsRecipient R8 ON (R8.iRecipientId = S6.iRecipientId) WHERE (B0.iBroadLogId = :#(1)#)' could not be executed.
WDB-200011 The requested database record does not exist.
Unable to load document of type 'Recipient delivery logs (nms:broadLogRcp)' because link 'triggeringWebEvent' with condition '[@broadLogRemkt-id] = 17819000' not found in the database.
Unable to load document of type 'Recipient delivery logs (nms:broadLogRcp)' because link 'subscription' with condition '[@recipient-id] = 951370 AND [@service-id] = 0' not found in the database.

 Thanks,

Shine v.v