Why am I receiving a "Bad Request" error when trying to create a new file in Google Drive?

Help
21 
import { axios } from "@pipedream/platform";
import FormData from "form-data";
import fs from "fs";

export default defineComponent({
  props: {
    google_drive: {
      type: "app",
      app: "google_drive",
    },
  },
  async run({ steps, $ }) {
    const fileMetadata = {
      name: steps.python.$return_value.file_name,
      mimeType: 'application/vnd.google-apps.spreadsheet',
    };

    const media = {
      mimeType: 'text/csv',
      body: fs.createReadStream('/tmp/items.csv'),
    };

    const formData = new FormData();
    formData.append('metadata', JSON.stringify(fileMetadata), {
      contentType: 'application/json',
    });
    formData.append('file', media.body, {
      filename: 'items.csv',
      contentType: media.mimeType,
    });

    const headers = formData.getHeaders();
    headers.Authorization = `Bearer ${this.google_drive.$auth.oauth_access_token}`;

    return await axios($, {
      method: "post",
      url: "https://www.googleapis.com/upload/drive/v3/files",
      params: {
        uploadType: "multipart",
      },
      headers: headers,
      data: formData,
    });
  },
});

In this code, how can i choose a specifiec directory in google drive to upload the file to?

22

To upload a file to a specific directory in Google Drive using the Google Drive API, you need to specify the parents property in the fileMetadata object. The parents property is an array of folder IDs where the file should be uploaded. Here’s how you can modify your fileMetadata to include a specific folder ID: const fileMetadata = { name: steps.python.$return_value.file_name, mimeType: 'application/vnd.google-apps.spreadsheet', parents: ['your-folder-id'] // Replace 'your-folder-id' with the actual ID of the folder }; Here’s the updated code snippet with the parents property included: import { axios } from "@pipedream/platform"; import FormData from "form-data"; import fs from "fs"; export default defineComponent({ props: { google_drive: { type: "app", app: "google_drive", }, }, async run({ steps, $ }) { const fileMetadata = { name: steps.python.$return_value.file_name, mimeType: 'application/vnd.google-apps.spreadsheet', parents: ['your-folder-id'] // Replace 'your-folder-id' with the actual ID of the folder }; const media = { mimeType: 'text/csv', body: fs.createReadStream('/tmp/items.csv'), }; const formData = new FormData(); formData.append('metadata', JSON.stringify(fileMetadata), { contentType: 'application/json', }); formData.append('file', media.body, { filename: 'items.csv', contentType: media.mimeType, }); const headers = formData.getHeaders(); headers.Authorization = `Bearer ${this.google_drive.$auth.oauth_access_token}`; return await axios($, { method: "post", url: "https://www.googleapis.com/upload/drive/v3/files", params: { uploadType: "multipart", }, headers: headers, data: formData, }); }, }); Make sure to replace 'your-folder-id' with the actual ID of the Google Drive folder you want to upload the file to. You can find the folder ID by navigating to the folder in Google Drive and copying the ID from the URL. The URL will look something like https://drive.google.com/drive/folders/your-folder-id.