I have been testing using GTL in SFMC to build an email from a JSON payload stored in an email. The reason for this is that there is often multiple products the customer can purchase, and they want to stop storing/sending over the whole HTML table.
The testing has gone well so far however I've been notified that the payloads can swell in size to over 4000 characters which is the field limit in SFMC.
I have tried the solution mentioned below to circumvent this however after creating the extension, the UI limits me to 255 characters.
data extension: maximum characters of text field
Is there any other potential solutions to receive nested JSON in marketing cloud for parsing, that is over 4000 characters?
Found Solution: The original data extension I created was created using email studio. However I made the mistake of trying to insert JSON via the UI, which is limited! However importing via API/file import works just fine. Appreciate the support