Smartsheet Integration with Custom GPT via API: Persistent 'ResponseTooLargeError'

snowxwang

Has anyone encountered a persistent "ResponseTooLargeError" when embedding Smartsheets in a custom ChatGPT via API?

I’ve successfully integrated several sheets where GPT actions work well, but a few always return this error. I’ve already implemented pagination and filtered a subset of columns as suggested by ChatGPT, yet the issue persists. My sheets aren't particularly large—the biggest one has only 21 columns and 600+ rows.

Curious if others have faced this and would appreciate any insights or solutions!

schema.txt

Isaac A.

Hi @snowxwang!

I don’t have experience with custom code, but after researching, I’ve seen similar error messages related to requests being too long or too large. In these cases, other members recommend processing data in smaller chunks (200 rows or less at a time) to avoid hitting API limits.

Also, please note that Smartsheet Support does not handle SDK-related inquiries. If you’ve tested and found an issue with the SDK, you can report it on the relevant GitHub page. You can find links to these pages in our API documentation here: Smartsheet API Documentation.

Should you not get a response from the Community, consider checking out Stack Overflow, where other developers may be able to assist.

Hope this helps!

Cheers,
Isaac.

Serhii

Doing same thing, got same exception (ResponseTooLargeError)
Sheet isnt really large (54 columns, about 213 rows), but I constistently hit TooLarge error
It looks like all dancing around pagination/limiting columns to fetch/limiting rows happens after this error is hit, thus does not affect it.

In other words, I try to fetch either 1 row or 1 column and still fail.