since ‎30-10-2020
‎05-12-2020
AquaticAds
Level 1
Adobe Campaign Classic API - Javascript sqlGetString function not working
Avatar

AquaticAds

AquaticAds
- Adobe Campaign Classic
Hi Adobe Community, I've have been attempting to use the 'sqlGetString' function available within the Adobe Campaign Classic API to test whether a value exists (and return it) within the recipient table. Unfortunately I seem unable to get it to work. Below is the Javascript function as it stands: function checkIfValueExists(str){ try { var val = sqlGetString("SELECT sText2 From NmsRecipient WHERE sText2 = $(sz) LIMIT 1", str); return val.toString(); } catch (e){ return e.toString(); } } If I cha...

Views

161

Likes

0

Replies

2
Re: Services and Subscription confirmation email not send...
Avatar

AquaticAds

AquaticAds
- Adobe Campaign Classic
Thanks Manoj, I used the following JS and that did the trick:var recipient = {recipient: {"_key": "email", "email": email, "recipient-id":iRecipientId, "service-id":iServiceId}} nms.subscription.Subscribe("name_of_service", recipient, false) Thanks for your help,Adam

Views

130

Likes

0

Replies

0
Services and Subscription confirmation email not sending when record is added via Javascript
Avatar

AquaticAds

AquaticAds
- Adobe Campaign Classic
Hi there, Wondered if you might be able to help? We have the below bit of JS that is supposed to add a record to the Recipient table, save it, extract the id, then in turn add the record to a Subscription list within Adobe Campaign Classic. The code works as expected, however for whatever reason, no Confirmation (Subscribed) email is being triggered and sent out. We have attached a 'Subscribed' email template (with Target Mapping set to nms:subscription ) however no email is still being sent. If...

Views

154

Likes

0

Replies

2