Upload files from google drive to external api using google apps script

Question

I am using google form to upload files to google drive. Now I want to be able to upload these (uploaded)files from google drive to external api using google apps script. (This api of GoCD to be specific.)

I tried to upload the file this way which is probably wrong, but it doesn't work:

function main() {
  var url = "https://<my-server-url>/go/files/Pipeline1/1/Stage1/1/Job1/folder/";
  var form = {
    file : DriveApp.getFileById("<file-id>"),
  };
  uploadFile(url,form);
}

function uploadFile(url,form) {
  
  var options = {
    "method" : "POST",
    "header" : {
    "Confirm" : true
    },
    "muteHttpExceptions" : true,
    'zipFile' : form
  };
  
  var response = UrlFetchApp.fetch(url,options);
  Logger.log("Response body: " + response.getContentText());
}

Is there any other way to make POST api call to upload files from drive? Also, any help with resources for doPost() method of google apps script will be appreciated.

Chris · Accepted Answer · 2020-02-22 08:38:53Z

3

See my post and answer by @Tanaike, as I think the answer I found also answers your question, @Shivani-Shinde: How do you create and then insert an image file from Google Drive into a Google Apps Script UrlFetchApp.fetch call to an External API?.

var formData = {
  'upload': DriveApp.getFileById("###").getBlob()
};

answered Feb 22, 2020 at 8:38

Chris

5531 gold badge7 silver badges25 bronze badges

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

1 Comment

stackflow Over a year ago

I have tried this code and it's working fine, but the file is saving as PDF. Do you know how to save the blob data as .docx?

Tech Girl · Accepted Answer · 2019-12-09 12:41:13Z

0

Answering this question, if anyone needs it.

So, I tried all the ways to upload files, but it won't work. Turns out you cannot directly get a file from drive and upload it to external api. You have to have a middleware (here, node app) where the file will be stored first locally and then upload it to api. I have used node app and Drive API V3 to download the file and then made a post call to external api.

Thanks!

answered Dec 9, 2019 at 12:41

Tech Girl

1971 gold badge3 silver badges18 bronze badges

Collectives™ on Stack Overflow

Upload files from google drive to external api using google apps script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related