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

SOLVED

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

santhoshsrg
Level 4
Level 4

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

1 Accepted Solution
craigthonis
Correct answer by
Employee
Employee

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

View solution in original post

6 Replies
raj_mandalapu
Community Advisor
Community Advisor

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

santhoshsrg
Level 4
Level 4

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

chan2111
Level 4
Level 4
If it is a DB field pls choose longText as data type , if it is a field in Transactional email then choose the length to be > 255
santhoshsrg
Level 4
Level 4
It is actually a temp field created in Enrichment activity. I am not able to change the length of this temp field
raj_mandalapu
Community Advisor
Community Advisor

Yes, the temp table field length is 255 characters, so because of this, it is trimming additional characters, but I dont see JS step to create temp tables in Adobe Campaign Standard

 

Please check this link, there are multiple options to create the temp table

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/controlling-wkf-ta...

craigthonis
Correct answer by
Employee
Employee

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

View solution in original post