Nodejs - Unable to fetch data of files from google drive

Question

I am trying to fetch data of a file from google drive. For which I have done all the steps mentioned in https://developers.google.com/drive/api/v3/quickstart/nodejs

Also I am able to get the list of files in the drive. But I am not understanding how to get the data inside the files. I have tried the below code which I found in google, but I am getting the response as undefined.

Here is my code

    const fs = require('fs');
const readline = require('readline');
const {google} = require('googleapis');
const zlib = require("zlib");
const creds = require("../../../credentials.json")
const getfilelist = require("google-drive-getfilelist");
module.exports = async (req, res) => {
    try {
// If modifying these scopes, delete token.json.
const SCOPES = ['https://www.googleapis.com/auth/drive'];
// The file token.json stores the user's access and refresh tokens, and is
// created automatically when the authorization flow completes for the first
// time.
const TOKEN_PATH = 'token.json';

// Load client secrets from a local file.

  authorize(creds, listFiles);

/**
 * Create an OAuth2 client with the given credentials, and then execute the
 * given callback function.
 * @param {Object} credentials The authorization client credentials.
 * @param {function} callback The callback to call with the authorized client.
 */
function authorize(credentials, callback) {
  const oAuth2Client = new google.auth.OAuth2(
    credentials.client_id, credentials.client_secret, credentials.redirect_uris[0]);

  // Check if we have previously stored a token.
  fs.readFile(TOKEN_PATH, (err, token) => {
    if (err) return getAccessToken(oAuth2Client, callback);
    oAuth2Client.setCredentials(JSON.parse(token));
    callback(oAuth2Client);
  });
}

/**
 * Get and store new token after prompting for user authorization, and then
 * execute the given callback with the authorized OAuth2 client.
 * @param {google.auth.OAuth2} oAuth2Client The OAuth2 client to get token for.
 * @param {getEventsCallback} callback The callback for the authorized client.
 */
function getAccessToken(oAuth2Client, callback) {
  const authUrl = oAuth2Client.generateAuthUrl({
    access_type: 'offline',
    scope: SCOPES,
  });
  console.log('Authorize this app by visiting this url:', authUrl);
  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
  });
  rl.question('Enter the code from that page here: ', (code) => {
    rl.close();
    oAuth2Client.getToken(code, (err, token) => {
      if (err) return console.error('Error retrieving access token', err);
      oAuth2Client.setCredentials(token);
      // Store the token to disk for later program executions
      fs.writeFile(TOKEN_PATH, JSON.stringify(token), (err) => {
        if (err) return console.error(err);
        console.log('Token stored to', TOKEN_PATH);
      });
      callback(oAuth2Client);
    });
  });
}

/**
 * Lists the names and IDs of up to 10 files.
 * @param {google.auth.OAuth2} auth An authorized OAuth2 client.
 */
function listFiles(auth) {
  const topFolderId = "1MTER3d8AVkpw0-_32xpxzZtyuP8iMH66"; // Please set the top folder ID.
getfilelist.GetFileList(
  {
    auth: auth,
    fields: "files(*)",
    id: topFolderId,
  },
  (err, res) => {
    if (err) {
      console.log(err);
      return;
    }
    const fileList = res.fileList.flatMap(({ files }) => files);
    fileList.map((file) => {
      console.log('iiiiii',file)
      downloadFile(auth, file.id)
    });
  }
);
}

function downloadFile(auth, fileId) {const drive = google.drive({version: 'v3', auth});
console.log('fileIdfileId',fileId)
let progress = 0;
drive.files.get({
  fileId: fileId,
  alt: 'media'
},
function(err, { data }) {
  console.log('actual data', data);
  var bdata = Buffer.from(data, 'utf8')
  console.log('buffered data', bdata)
})




}
} catch (error) {
    console.log(error);
}
};

Near the code console.log('actual data',bdata) I am getting the output something like PK"♠�S↕word/numbering.xml��MN�0►�O�↔"��$§ ¶5� 6�♥���X�=��I��q��R$��U��������Kɠ�h♣��ˈ♦\3Ȅ.R���x"�uTgT��)9rK���u��J�9�}�Gh�(���9���e%W�.�p�9���/§�Ce▬♀��N�¶�↑���t↑HI�:�►♂%↑��ܝ$ ���� ���Jv�*ŵ;;�ȥ�☺�-��=Mͥ�b�C�♫Q+��k�¶�♀i��dk�f♠�qk��][∟�q4a�'Ġ���OϾ‼E�▲0�t\�♠���vF�↓ga�F�қ�#���.�y^ꍘ��+�W� PI‼C⌂h☺=♣PK"♠�S◄word/settings.xml���n�0♀ǟ�►���I6↑uzX�����=#ɶ►}A����'ǖդ@�f�H⌂�?�♀M?>�§|q��2%K��R��↕+�d]�?�?����:�♦���Dgj����cWX���♂O��►�D�s�H↕�����♦8⌂5u"�∟[��Jhp��8s�$O�-→1�D��ňX

and near the console.log('buffered data', bdata) I am getting the output as <Buffer 50 4b 03 04 14 00 08 08 08 00 22 06 ef bf bd 53 00 00 00 00 00 00 00 00 00 00 00 00 12 00 00 00 77 6f 72 64 2f 6e 75 6d 62 65 72 69 6e 67 2e 78 6d 6c ... 15880 more bytes>

How do I get the actual text from the file.

Can some one please help

Answer 1

Issue:

You are authorizing the application with drive.metadata.readonly scope, which does not give you access to the file content and doesn't let you download it.

Solution:

Remove the token.json that you generated, modify the SCOPES in your code with an appropriate scope like drive and go through authorization again:

const SCOPES = ['https://www.googleapis.com/auth/drive'];

Reference:

• Authorizing requests with OAuth 2.0