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
BedrockMission!

Learn More

View all

Sign in to view all badges

Enrichment - Not able to create collection which item length is greater than 255

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

25-05-2020

Hi All,

 

Use Case:

I have to send an email to customers who have purchased items. I have to send email with item image links which customers have purchased.

 

Approach followed:

I have created two schemas for this Order, OrderLineItem. I have followed the below steps in workflow.

  1. I have queried recent Order records using Query activity.
  2. Then I have used Enrichment activity to create collection(Size: 3) "itemNameImage" of Order line item and add it to temporary schema. The collection variable itemNameImage holds HTML content like <a href="@productLink"><img src="@productImage"/></a>
  3. Then I will just add the collection variable "itemNameImage" to the email as dynamic variable.

 

Issue:

The above approach works fine when each variable itemNameImage in collection holds value whose size is less than 255. When it exceeds size 255, campaign throws error as in screenshot below.

Screenshot 2020-05-25 at 8.12.01 PM.png

 

Any help would be great !!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

155 likes

Total Posts

241 posts

Correct Reply

141 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

155 likes

Total Posts

241 posts

Correct Reply

141 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

05-06-2020

Hi Santhosh,

 

I'd suggest reviewing the following thread which goes through numerous solutions for this.  It's for Campaign Classic but the premise is the same.  Standard string fields will only allow a max of 255 characters and there isn't a way to change that.  So the only option would be to change the field at the schema level to a data type that allows for more than 255 characters.

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/using-instance-var...

 

You'll need to update the field at the schema level to something like a LongValue.

 

Regards,

Craig

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

26-05-2020

Thanks for the reply @raj_mandalapu 

 

Yes, The length of itemNameImage is getting restricted by default to 255. But i want to store more than 255 characters. The problem is i am not able to change the itemNameImage field length in Enrichment activity. Please share your input if this collection field "itemNameImage" length can be changed.

 

Screenshot 2020-05-26 at 3.14.22 PM.png

Avatar

Avatar
Validate 1
MVP
raj_mandalapu
MVP

Likes

124 likes

Total Posts

203 posts

Correct Reply

72 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
raj_mandalapu
MVP

Likes

124 likes

Total Posts

203 posts

Correct Reply

72 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 5
Give Back 3
View profile
raj_mandalapu
MVP

26-05-2020

Please check the length of the itemNameImage field, I think the length is restricting.