topic RE: Configure Google Drive in Product Forum

Configure Google Drive

DishaKulkarni — Sun, 17 Apr 2022 15:52:00 GMT

Hello,

I am trying to upload a file to Google Drive via BluePrism
To test the Connector for Google Drive, I downloaded he asset from digital exchange
The process worked fine for files.create method and gave HTTP Status Code: 200

The configurations were as follows

Data 2 field has location of a random pdf from my pc

I have Google OAuth enabled and valid

My question is, which Google drive did the file get created in and How to check the result of action
Since I have not given any location of drive anywhere.

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

shashank.kumar280 — Sun, 17 Apr 2022 16:26:00 GMT

Hi Disha,

The file gets created in the root directory by default. You can add additional parameters based on this https://developers.google.com/drive/api/v3/reference/files/create

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Configure Google Drive

DishaKulkarni — Sun, 17 Apr 2022 17:15:00 GMT

There is no Drive account linked to the Google service account. I cannot find the file in existing drive account. Is there any error in configuration and settings?

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

shashank.kumar280 — Sun, 17 Apr 2022 17:26:00 GMT

When you navigate to the user interface at https://drive.google.com/ , do you see any file?

Alternatively, have you tried the drives.files.list action to see what files you have?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Configure Google Drive

DishaKulkarni — Mon, 18 Apr 2022 06:58:00 GMT

Yes, files.list method is listing the created files.

Alternatively I've given editor access to my service account for a drive folder.
So when I use files.list method, it's listing files both from root directory as well as shared folder.
But when I create files, it automatically creates in root directory.

What is the syntax or procedure for adding parameters like Parents Id in my input, so that file gets uploaded at the desired location?

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

ewilson — Mon, 18 Apr 2022 14:52:00 GMT

@DishaKulkarni,

Since you're using a service account to upload the file I believe you'll need to make use of sharing to have multiple parents. That means there's a query parameter you'll need to add to your request in addition to the list of parents. The query parameter is supportsAllDrives and it needs to be set to true. So the request would look something like this:

files?fields=[fields]&supportsAllDrives=true

For the parents list, I believe the request body template will need to look something like this:

{
  ...
  "parents": [ [Parents] ] 
}

In this case, [Parents] is a Blue Prism Text data item that should contain a list of the parent ID's (ex. "root","jdoe","bobsmith"). When the data item is replaced in the actual request you're left with a JSON array of strings which are the ID's of the other users that should be parents.

Hope that helps.

Cheers,

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

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 02:08:00 GMT

Thank you.
The request parameter should be added in fields section of the inputs in action stage?
If yes, how to set supportsAllDrives and parents together as a text data item to be included as Fields in the inputs

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

devneetmohanty07 — Tue, 19 Apr 2022 03:25:00 GMT

Hi Disha,

Going through this thread, I think that Eric is trying to say that you can add these additional input parameters in your Web Service setting as show below:

Step I: Add the additional parameters under the 'Parameters' section of the action 'drives.files.create':

Step II: Make the changes in your request definition under the 'Request' section of the action 'drives.files.create':

Step III : Once you save the changes, access the same action from Process Studio and pass all the parameters in your action:

NOTE: I haven't tested the same as I do not have Google service account but you can check once if it works for you.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 06:44:00 GMT

Hello,
I configured everything you stated above

Let's say I have one parent and my parent id is xyz

This is my action stage configuration

And the error I am getting is

Which configuration is the mistake?

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

devneetmohanty07 — Tue, 19 Apr 2022 07:22:00 GMT

Hello Disha,

Can you check once for each of the parameter, if the syntax is correct or not. You can do this by clicking on the Calculator symbol beside each parameter one by one and the when the Expression wizard opens up, click on the 'Validate' button. That will help you to isolate the issue like at which parameter you have any issue.

You can show us the exact parameter value where you are getting this error that way.

If there is an error with the expression, then upon clicking on the 'Validate' button, you will get the same exception message:

My guess is your issue lies with the 'Parents' field although I cannot tell for sure as the entire text is not completely visible in your screenshot.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 07:41:00 GMT

The mistake was in true which was supposed to be True.
Parent id(only 1 in this case) is a long string within double quotes

All the expressions are valid and I am getting an error like this

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

devneetmohanty07 — Tue, 19 Apr 2022 08:03:00 GMT

Hi Disha,

Here I suspect the issue is mainly with the body content of the request that is being sent. From the prior screenshot, I can see you are directly passing the parent without any double quotation mark as a part of the text. So what I mean is, let say if the name of the parent is 'abc'. You are sending the value in the action parameter as: "abc" Here, what happens is when it is sent to your request, the body template would be:

"parents": [abc]

This won't be recognized as a proper string value in the JSON format. Instead, try sending the value of the parent in your action stage as """" & "abc" & """" This will ideally append your double quotation marks to the parent and hence the template will look like:

"parents": [ "abc"]

Try this and let us know if you get the same error or not.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 08:52:00 GMT

Did the changes, I am getting the same error as stated earlier

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 09:18:00 GMT

The problem seems to be in the body of the request (the particular code). Could you please suggest changes if any and how to write the code?

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

shashank.kumar280 — Tue, 19 Apr 2022 11:01:00 GMT

Hi Disha,

Can you post a screenshot or copy here the text that you currently have in the Body Template?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Configure Google Drive

DishaKulkarni — Tue, 19 Apr 2022 11:51:00 GMT

--foo_bar_baz
Content-Type: application/json; charset=UTF-8
{
"name": "[name]",
"parents": "[ [parents] ]"
}
--foo_bar_baz
Content-Type: [mime_type]; boundary=foo_bar_baz

[data]
--foo_bar_baz--

------------------------------
Disha Kulkarni
------------------------------

RE: Configure Google Drive

DishaKulkarni — Thu, 21 Apr 2022 01:44:00 GMT

Hello,
Are there any changes to be made here in the template?

------------------------------
Disha Kulkarni
------------------------------