topic Re: How do I upload long json text to Open AI connector for analysis? in Workato Pros Discussion Board

How do I upload long json text to Open AI connector for analysis?

jiyu269 — Sat, 03 May 2025 07:29:31 GMT

What best way to get GPT AI to read long json? File upload? How do I configure that?

Re: How do I upload long json text to Open AI connector for analysis?

Prudvi — Sun, 04 May 2025 08:02:55 GMT

Hi @jiyu269,
If you have tried OpenAI Analyze Text action and what was the limitation of the characters you were facing.
Regards,
Prudvi

Re: How do I upload long json text to Open AI connector for analysis?

jiyu269 — Wed, 07 May 2025 13:36:10 GMT

The text I'm sending is too long. I haven't had a chance to tried file attachment method yet.

Re: How do I upload long json text to Open AI connector for analysis?

Obugari — Thu, 31 Jul 2025 13:18:36 GMT

Hi @jiyu269 ,
Generally if we have large set of data and we can't upload the entire file at once . In this case we can use pagination concept ,In workato using while loop we can do that . Below are the steps to follow
1. Create a list of items/Contents
2.Apply while loop
3. Call GPT AI or any system to upload
4. Output GPT AI can be add to Add list of items / Append to file contents if you are storing file storage
5.loop Condition (if row size = 41560 ) based on your condition need to this condition
If we follow this approach we can send the all contents to any target system
Let me know this approach is working or not

Thankyou