google-api-python-client icon indicating copy to clipboard operation
google-api-python-client copied to clipboard
verified publisher icon googleapis

Google Drive API v3: .export_media() doesn't work for big sheets

Open anelyubin opened this issue 2 years ago • 0 comments

Hi Team

I couldn't fetch Google Sheet over export call.

Environment details

  • OS type and version: Ubuntu 20.04.6
  • Python version: 3.8.10
  • pip version: pip 23.2.1
  • google-api-python-client version: 2.98.0

Steps to reproduce

  1. Select big Google Sheet: more than 5MB and less then 10MB.
  2. Call drive.export_media(file_id, mimeType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") for this file. Result - timeout exception after 60 seconds waiting.
  3. Set request timeout to 300s (for example), call export_media() again. Result: HTTP 503 ("Transient failure") or HTTP 500 ("Internal Error"), after 90 seconds waiting.

anelyubin avatar Sep 20 '23 23:09 anelyubin