since ‎08-09-2020
Online
Bowenaus
Level 1
Re: Loop through linked data in delivery/personalization...
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

27

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization...
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

28

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization...
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

47

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization...
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
--

Views

51

Likes

0

Replies

0
Re: Loop through linked data in delivery/personalization...
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

68

Likes

0

Replies

0
Loop through linked data in delivery/personalization block
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

122

Likes

0

Replies

8
Re: Using custom API calls in Delivery
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

55

Likes

0

Replies

0
Re: Using custom API calls in Delivery
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

77

Likes

0

Replies

0
Re: Using custom API calls in Delivery
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
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

86

Likes

0

Replies

0
Using custom API calls in Delivery
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Hello,We have a need to use a variable inside of a delivery which is being generated by using the .js API to query a data table containing advisors and their assigned wholesalers, then create an array of the advisors and include that in a delivery to each wholesaler. How can we include this array inside the delivery? Since it is dynamic & a different array of advisors for each wholesaler (the delivery recipients), I don't believe the built-in delivery variables can accommodate. We attempted to u...

Views

115

Likes

0

Replies

5
Re: How to use variable from Javascript code in delivery?
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Thanks Manoj. That is helpful and it does essentially answer my question but I think I oversimplified our use case. Is it possible to pass the variable from an API call in aseparate Javascript activity & use that variable later in the workflow inside the delivery activity?

Views

58

Likes

0

Replies

0
How to use variable from Javascript code in delivery?
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Hello,Is it possible to include a variable defined in the Javascript code inside of a delivery activity? We wrote some custom Javascript which allows us to loop through a schema of advisors & group them together by wholesaler territory so that we can send an email report to each wholesaler with their specific group of advisors who qualified for a trigger. We can use the JS API to send the deliveries in the Javascript but it is not a very maintainable solution and we would need to loop through th...

Views

75

Likes

0

Replies

2
Re: Grouping data into a comma-separated string
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Thanks David. I was able to add a function groupConcat() but struggling to put this into practice by leveraging the function inside of the .js. Is there an easier way to iterate through & group the records together using one of the built-in jsapi functions? In the end, I just need to send a single email to Manager Id1 listing each of their associate emails in some way. I'm probably overcomplicating it. Basically my table is something like this:Record Id | Manager Id | Associate Email1 | 1 | emai...

Views

77

Likes

0

Replies

0
Grouping data into a comma-separated string
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Hello, We have a need for a workflow which is capable of replicating the Group_CONCAT() function in SQL. All of the "Group By" options I've seen in Adobe Campaign are just capable of aggregating #s together but I can't find anything which can concatenate strings into a comma-separated string like this example: EMP_ID FNAME LNAME DEPT_ID STRENGTH 1mukeshgupta2Leadership3neelamsharma3Hard-working1mukeshgupta2Responsible2deveshtyagi2Punctuality3neelamsharma3Self-motivated1mukeshgupta2Quick-learner4...

Views

168

Likes

0

Replies

2
Re: Right Panel Not visible
Avatar

Bowenaus

Bowenaus
- Adobe Campaign Classic
Resolved the issue for me as well. Thanks Ishan.

Views

92

Likes

0

Replies

0
Likes given to