Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

AquaticAds
Community profile AquaticAds Level 1
Job title here
Location here
3 BADGES
Level 1

Level 1

Learn more
Joined the community 30-10-2020 3:55:33 AM
Online
Top badges earned by AquaticAds
Customize the badges you want to showcase on your profile
Adobe Campaign Classic API - Javascript sqlGetString function not working
Avatar
Give Back
Level 1
AquaticAds
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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

458

Likes

0

Replies

2
Re: Services and Subscription confirmation email not send...
Avatar
Give Back
Level 1
AquaticAds
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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

416

Likes

0

Replies

0
Services and Subscription confirmation email not sending when record is added via Javascript
Avatar
Give Back
Level 1
AquaticAds
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
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

467

Likes

0

Replies

3