Tim – thanks for posting back with your solution to the issue in the initial post.
The message ‘Limit Exceeded: URLFetch URL Length.’ is a Google Services error (https://developers.google.com/apps-script/guides/services/quotas). According to the page, there’s a 2kB limit (about 2,000 characters).
Some things to try:
- restructure the query to eliminate any unnecessary filters/screens and/or fields returned (maybe there’s a more efficient way to call for the data you need)
- try a URL shortener (bit.ly is one such service) – I don’t have any experience with this, but it may be worthwhile if it works