I use the Google python gdata client library in order to do batch updates to a Google Spreadsheet. However, Google Spreadsheet, by default, has 1000 rows. When my batch update exceeds that limit, then I get the following error message:
"Server responded with: 400, Invalid query parameter value for range." The stack trace is: " Traceback: File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 112. response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view 22. return view_func(request, *args, **kwargs) File "/Users/mkhan/dev/tola/htdocs/feed/views.py" in google_export 278. cells = gd_client.GetCells(sprd_key, wrksht_key, q=cellq) File "/usr/local/lib/python2.7/site-packages/gdata/spreadsheets/client.py" in get_cells 376. **kwargs) File "/usr/local/lib/python2.7/site-packages/gdata/client.py" in get_feed 640. **kwargs) File "/usr/local/lib/python2.7/site-packages/gdata/client.py" in request 319. RequestError) Exception Type: RequestError at /google_export/ Exception Value: Server responded with: 400, Invalid query parameter value for range. " I searched through StackOverflow as well as this Google Group but have not found an answer. I'd appreciate any help you provide. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
