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

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

Haritha — Fri, 01 Aug 2025 15:27:51 GMT

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

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

rajeshjanapati — Fri, 01 Aug 2025 17:58:47 GMT

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.

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

dineshtirumani — Sun, 03 Aug 2025 15:26:51 GMT

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.