Getting an error while Download Files using Drive API

Question

I am trying to pass the Google Spreadsheet ID (Where the file is in Google Drive with Every one view option) to the Google Drive Export API and download the file to local directory. As I need to download the file as xls or xlsx. If I use mimeType as "application/vnd.google-apps.spreadsheet" and getting an error as "The requested conversion is not supported". Same error message would be return to execute the same API using Google's API Explorer window as well. If I change the mimeType as "text/csv" then its working fine. Please help me whats the wrong with the mimeType which I used in the below code.

  const drive = google.drive({version: 'v3', auth});
  const res =  drive.files.export({
     fileId: '1YHO6KuXuUdTQmUgPTJkYNiLrkQBWejDREZLEK62ZT_Q',
     mimeType: 'application/vnd.google-apps.spreadsheet',
     responseType: 'stream' });

if i use mimeType as 'application/vnd.ms-excel' then getting The requested conversion is not supported — Sumathi
– Sumathi, Commented Oct 13, 2018 at 12:30
try application/vnd.openxmlformats-officedocument.spreadsheetml.sheet — pinoyyid
– pinoyyid, Commented Oct 13, 2018 at 17:10
@pinoyyid, i have tried this mimeType "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" but response.data is corrupted so i can not able to export the google spreadsheet content to other xls/x;sx file. Below are the code snippets which i have tried: fs.writeFileSync('./testfolder/test.xlsx', res); — Sumathi
– Sumathi, Commented Oct 15, 2018 at 4:00
It's probably not corrupt, but you are not writing it to file correctly. Check what is being downloaded and also what is in your "corrupted" file. — pinoyyid
– pinoyyid, Commented Oct 15, 2018 at 9:04

Vidura Dantanarayana · Accepted Answer · 2019-03-21 10:23:30Z

3

Replace application/vnd.google-apps.spreadsheet with application/vnd.openxmlformats-officedocument.spreadsheetml.sheet. Works like a dream.

answered Mar 21, 2019 at 10:23

Vidura Dantanarayana

5816 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting an error while Download Files using Drive API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related