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

Bowenaus
Bowenaus
Online

Badges

Badges
7

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
16

Discussions

Discussions
0

Questions

Questions
4

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Bowenaus
Customize the badges you want to showcase on your profile
Re: Grouping data into a comma-separated string - Adobe Campaign 01-12-2021
Hi @reddyx0133 - instead of the comma-separated string, we were able to find an approach that iterated through all of the records belonging to a user in a data table & create a list of their specific associates that were active on the website in the past 24 hours &send in an email to the user. See:https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/loop-through-linked-data-in-delivery-personalization-block/m-p/388178#M1936

Views

399

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization... - Adobe Campaign 18-11-2020
We were able to implement this solution & it worked great. We have other use cases where this would be really helpful as well, just weren't familiar that you could loop through values using that dot notation approach. Thanks a lot!

Views

1.1K

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization... - Adobe Campaign 18-11-2020
We were able to resolve the issue by updating the link element on our custom schema to have a revLink attribute (we used the Broadlog schema as a reference and made sure our link was structured similarly since that table was working).

Views

1.1K

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization... - Adobe Campaign 17-11-2020
Hi @Sukrity_Wadhwa, Thank you for checking. I am able to get David's code below to work fine. However, when I use the custom table which "recipient" links to, I keep getting an error. I've tried using different variations of the table name (it actually gets generated as recipient.Consumers_contact.fieldName when I choose a field from the dropdown list of available fields). Similar error each time: "Error while evaluating document JST-310000 Error while compiling script 'content htmlContent' line...

Views

1.1K

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization... - Adobe Campaign 13-11-2020
Thanks David. Just to confirm, you're able to just use this kind of dot notation for any tables linked to the recipient table without needing a query? We will give it a shot today to see if it will be possible with our scenario where we have a foreign key on the recipient record which links to a foreign key on the 2nd custom table. Thank you for your suggestion!

Views

1.1K

Likes

0

Replies

0
Loop through linked data in delivery/personalization block - Adobe Campaign 12-11-2020
Hello, We have table which links to the recipients table with a 1 to many relationship (1 recipient may have many records in the 2nd table). We are trying to list data from all linked records in the 2nd table for each recipient. For example, in an email to John Doe we would like a bulleted list of ID1, ID2, ID3, etc. where ID1, ID2, ID3 are the linked records from the 2nd table.We are wondering:a) if personalization blocks are capable of handling queries & making API calls or if this is only pos...

Views

1.2K

Likes

0

Replies

8
Re: Using custom API calls in Delivery - Adobe Campaign 05-11-2020
I ended up doing the same. Tried using the memo field, but later found out since that is an XML type & not a SQL field it can't be used in deliveries. So, I ended up using a string with length="1000" to allow the advisor HTML data to fit. Seems to be working now, thanks again!

Views

544

Likes

0

Replies

0
Re: Using custom API calls in Delivery - Adobe Campaign 04-11-2020
Were you able to find a solution for displaying the contents of the memo/text field in the email? I can see the values in the schema but in the delivery <%= targetData.advisors %> is just rendering blank.

Views

566

Likes

0

Replies

0
Re: Using custom API calls in Delivery - Adobe Campaign 04-11-2020
Thanks Darren. That's a great suggestion. I will give this a shot today & see if I can get those arrays added to the temp schema in the form of text fields.

Views

575

Likes

0

Replies

0
Likes given to