How to store strings longer than 10,000 characters in Workato Data Table column?

[Haritha]

Hello Workato Chefs,

I’m trying to store a string in a column that exceeds 10,000 characters, but it gets rejected due to the limit.
Is there a workaround or best practice to handle such large text data in Workato Data Tables (or alternative storage options)?
Any suggestions on how to split/store/retrieve long string content efficiently would be appreciated.

Thanks in Advance!!!

[rajeshjanapati]

Hi @Haritha,

I think we can work around some solutions like

1. Storing whole string into a file and upload that file into data table row

2. Create a file in file storage and append data to file, update the file path in data table row.

3. May be possible by Splitting the string into chunks.

[dineshtirumani]

Hello @Haritha 

In Data Tables 

if you use datatype as Short text it Supports a maximum of 756 characters.

if uses Long text it Supports a maximum of 10,000 (ten thousand) characters.

If your string has more than 10,000 characters, consider splitting it into smaller chunks to store them safely.
Alternatively, if you’re okay storing a non-human-readable version, please use the formula as specified below

 It will be stored in the Data Table column, and you can use the data again in subsequent recipes.
You can also convert it back to a human-readable form using decoding and decompression when needed.