topic RE: Upload file to Google Drive via API in Product Forum

Upload file to Google Drive via API

PABLOPEREZ-ENCI — Mon, 20 Jan 2020 17:26:00 GMT

We are using BP version 6.3

I want to know how is the best way to upload file to Google Drive without using browser or other app to syncrohnize the folders.

Thanks

RE: Upload file to Google Drive via API

james.roberts.bp — Thu, 30 Jan 2020 13:26:00 GMT

Hi Pablo,

There is a community supported Skill available on the Digital Exchange which is available to manage Google Drive (including uploading files), although unfortunately this is only supported from version 6.5 onwards:

https://digitalexchange.blueprism.com/dx/entry/9648/solution/drive-api-v3-2

On version 6.3 there are a number of VBOs which may help you develop similar functionality, although they are not as fully featured as the Web API Services feature (introduced in 6.4) which the above skill is based on:

Where can I find the Utility - HTTP Communication VBO?
Where can I find the Webservices - REST VBO?
Where can I find the Webservices - OAuth 2.0 VBO?

The documentation for the Google Drive API is available here:

https://developers.google.com/drive/

Kind Regards,

------------------------------
James Roberts
------------------------------

RE: Upload file to Google Drive via API

IshanMahajan — Fri, 20 Mar 2020 11:52:00 GMT

HI James,

i have question on similar lines, we are using Veeva APIs to upload a file to veeva, we are able to do that using Postman application, since we have an option there to change the parameter type to 'File' and enter the file path to achieve this =, do you have any info how we can upload a file using Blueprism HTTP utility ? i am looking into this but want to share this on portal to resolve it quickly.

------------------------------
Ishan Mahajan
India
------------------------------

RE: Upload file to Google Drive via API

GopalBhaire — Fri, 20 Mar 2020 15:02:00 GMT

In Body content you can select Single File and then send the file as Binary.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Upload file to Google Drive via API

IshanMahajan — Mon, 23 Mar 2020 09:11:00 GMT

Can you please elaborate ? as per the parameters available, Body needs to go as 'Text' and content type needs to go in header, i need to send some more parameter along with the file in order to complete the reqiurement.

------------------------------
Ishan Mahajan
India
------------------------------

RE: Upload file to Google Drive via API

GopalBhaire — Tue, 24 Mar 2020 13:13:00 GMT

Can you try this in Body

and then specify content-type in header of that action.

If you have more parameters then you can define body template in Image 1.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Upload file to Google Drive via API

james.roberts.bp — Tue, 24 Mar 2020 13:47:00 GMT

Hi Ishan,

There are a couple of different ways to achieve this that I'm aware of, although it depends on the version of Blue Prism you are using and the type of request that your Web Service is expecting to receive:

1 - Using the 'Web API Services' feature introduced in version 6.4.

- This feature provides two built-in ways to send files via the 'Body Content' option which is detailed on page 27 of the following guide:

v6.4 User Guide - Web API Services

It's worth noting that if you use one of these options then the Content-Type header is automatically set and doesn't need to be set anywhere else:

"Single File" - in this case, the Content-Type will be set to application/octet-stream, and you can send no more than one file.

"Multiple Files" - for this option, the Content-Type will be set to multipart/form-data, and you can send either one or multiple files.

- The option you will want to choose will depend on what Content-Type will be accepted by the web service, so you may want to consult the documentation for the API you are using - although if you're using the 'form-data' option in POSTMAN I think that maps to the 'Multiple Files' option.

2 - Using the Utility - HTTP VBO

- You may be able to send files within the Body of your request via this VBO, there is an example of how to do this for a multipart/form-data request in the following knowledgebase article:

How can I use the 'HTTP Communication VBO' to send a file using a "multipart/form-data" type request?

- This is one example of many different potential configurations, so may require quite a bit of extra configuration.

Overall I'd recommend using the 'Web API Feature' if you can as the configuration is generally much simpler.

------------------------------
James Roberts
------------------------------

RE: Upload file to Google Drive via API

TracySchultz — Fri, 31 Jul 2020 23:14:00 GMT

@james.roberts.bp James, for the 'Multiple Files' can you elaborate on setting up the collection?

I am trying to upload a file and have it working through Postman, when looking at the log I see this and I'm using the file option for the form-data in the body.

Content-Type: multipart/form-data; boundary=--------------------------574639511453299179934016
Content-Length: 1179190
----------------------------574639511453299179934016
Content-Disposition: form-data; name="file"; filename="1718367-2019-1231-MID; 1040.pdf"
Content-Type: application/pdf

<1718367-2019-1231-MID; 1040.pdf>
----------------------------574639511453299179934016--

I have tried setting up the following fields in a collection I am piping into the multiple files API request action.
Boundary with a value of ------------------------
name with a value of file
and filename with a value of the file path to the file I want to upload. When I try to run this I get the following output (I'm currently not sending the data so I can validate what is being sent).

POST api end point url
Content-Type: multipart/form-data; boundary=

------------------------------
Tracy Schultz
------------------------------

RE: Upload file to Google Drive via API

james.roberts.bp — Mon, 03 Aug 2020 16:09:00 GMT

Hi Tracy,

The required fields for a collection can often be populated using the 'Import' option available here:

For your example you will likely need to set the fields up in your collection as follows:

File (Binary) - The binary of the file you are uploading.
File Name (Text) - "1718367-2019-1231-MID; 1040.pdf"
Field Name (Text) - "file"
Content-Type (Text) - "application/pdf"

I hope this helps!

------------------------------
James Roberts
------------------------------

RE: Upload file to Google Drive via API

SireeshaJaggems — Fri, 23 Apr 2021 11:03:00 GMT

Hi James Robert,

I have followed the steps that you have mentioned in How can I use the 'HTTP Communication VBO' to send a file using a "multipart/form-data" type request?. I am able to upload only text files,other file types like like pdf are getting corrupted after uploading. Could you please let me know how to upload other files as well, including images.(I need to upload files to sharepoint via web api built by mulesoft using multipart/form-data) I tried inbuilt web api from blueprism as well, it didnt worked as I have to send meta data like filename and content type along with File value.

------------------------------
Sireesha
------------------------------

RE: Upload file to Google Drive via API

ArunkumarManoha — Thu, 29 Sep 2022 16:21:00 GMT

Hello!

Actually I have tried BP Web API Services to upload a file to AWS S3 and getting "403 Missing Authentication Token" error in response.
Attached the screenshot of the Web API definition so can someone help me to get resolve the issue?

------------------------------
Arunkumar Manoharan
------------------------------

RE: Upload file to Google Drive via API

ewilson — Tue, 04 Oct 2022 13:57:00 GMT

Hello @Arunkumar Manoharan,

AWS requires the creation of a JWT in order to get a valid access token. There are a few steps involved for that. From the looks of it, you're trying to build your own connector for this instead of using the free connector already available on the DX.

I would suggest you download the following two connectors as they should make your life easier.

AWS S3 Connector
AWS REST API Utility (this covers the JWT generation stuff)

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------