topic Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection in Digital Exchange

Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Mon, 08 Feb 2021 16:34:00 GMT

Hi Team,

On a high priority basis, I am working on a project involving Google drive automation using the API method in Blu prism. I have created the Project, Application credentials, like Client Id, Client secret in the GCP console to get the primary resources to automate the same.

Upon configuring the same credentials in BP-Credentials Manager and calling the "Drive API v3" object from the process studio, I am getting the below error

"Internal: Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection."

Blue Prism version number: V 6.10
Summary of issue: Getting Error as " Internal: Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection."
Severity: Very High (S1)
Steps to Reproduce: Create credentials on GCP Console, "https://console.cloud.google.com/apis/credentials/oauthclient" Get Client ID and Client secret code.
Install/Import the "https://digitalexchange.blueprism.com/dx/entry/9648/solution/drive-api-v3-2" asset and Configure the GCP Client ID and Client secret in credential manager. ( Pass Client Secret as "-----BEGIN PRIVATE KEY-----Client Secret-----END PRIVATE KEY-----")
Call action stage for creating a file in drive or Getting the list of files, pass the inputs and execute the same.
Logs and Screenshot: Please refer to the attachments.

Kindly help us by providing the documentation for automating the G Drive, and resolutions for the same.

Thanks and Regards

Pradeep Padashetty

------------------------------
Pradeep Padashetty
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

SergioBentim — Tue, 09 Feb 2021 14:51:00 GMT

Hello, Pradeep.
There is already a ticket open in Support, and the support team will reply to you shortly.
Is this issue affecting production?

------------------------------
Sergio Bentim
Customer Engineer
Technical Support
America/Mexico_City
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Thu, 11 Feb 2021 14:52:00 GMT

Hi Sergio,

We haven't got any response from the support ticket. It's been 4 days, we are anticipating the response as it is urgent and affecting the delivery date. Kindly help and guide us on automating the Google Drive using G-Drive Skills (V3) or any effective API invocation method.

Thanks and Regards
Pradeep Padashetty

------------------------------
Pradeep Padashetty
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

ewilson — Thu, 11 Feb 2021 15:03:00 GMT

Hi Pradeep,

Couple questions.

1) What kind of credential did you create in Credential Manager? Is it a OAuth JWT Bearer or OAuth Client Credential? It should be a OAuth JWT Bearer as shown below.

2) Does the Common Authentication section of your Web API Service definition for the Drive API look like this?

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Thu, 11 Feb 2021 15:41:00 GMT

Hi Eric,

Please find the response below,

a) Is it an OAuth JWT Bearer in Cred manager. ( I have passed the client ID and Client Secret as mentioned in the attached screenshot)
Note: Assigned the Client Secret as "-----BEGIN PRIVATE KEY-----Client Secret-----END PRIVATE KEY-----"
b) Common Authentication exactly looks like, as mentioned by you.

Kindly let me know if you need further information.

Thanks and Regards
Pradeep Padashetty

------------------------------
Pradeep Padashetty
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

ewilson — Thu, 11 Feb 2021 16:36:00 GMT

Pradeep,

According to your screenshot you've defined your credential in the Google Console as being for a Web App. I'm not sure if this makes a difference, but the only options I've used are Service Account, as mentioned in the documentation for the integration, and Desktop App.

Did you manually add the "-----BEGIN PRIVATE KEY-----" and "-----END PRIVATE KEY-----" portions when you set the value?

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Fri, 12 Feb 2021 17:09:00 GMT

Hi Eric,

I have also tried with the service account but not succeeded and achieved the expected.

Did you manually add the "-----BEGIN PRIVATE KEY-----" and "-----END PRIVATE KEY-----" portions when you set the value?- Yes

Kindly share the complete document to simulate google drive Automation and as well google sheet automation.

Thanks and Regards
Pradeep Padashetty

------------------------------
Pradeep Padashetty
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

ewilson — Fri, 12 Feb 2021 18:32:00 GMT

Pradeep,

I'm not sure what's going on with your implementation, but I've attached a doc I just put together that's as close to a step-by-step configuration as I can get at the moment. It starts with the actual enablement of the API. Please go through and verify every step even if you know you've already performed them.

Once you've verified every step, try the skill again, but start with the most basic action which is drive.about.get.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Tue, 16 Feb 2021 16:47:00 GMT

Hi Eric,

Thanks for the feed, I was able to configure and get the result from the drive.about.get. action. But the major intention to automate the file upload/download and find/search for files from the drive. Please share the knowledge base and steps by step details to reproduce.

Most of the parameters which we need to pass are not in an understandable format. I have taken the reference from G drive official API reference but didn't get much feed as I am new to the GCP platform.

https://developers.google.com/drive/api/v3/reference

Kindly share the documentation to follow the google drive file upload and Download procedure, either with Google Drive API V3 (Skills) or Using HTTP methods.

Thanks and regards
Pradeep padashetty

------------------------------
Pradeep Padashetty
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

acatalano — Wed, 16 Mar 2022 21:55:00 GMT

Hi @PradeepPadashet did you solve this problem uploading files?

------------------------------
Agustin Rodolfo Catalano
Computing Engineering
Santander Argentina
America/Argentina/Buenos_Aires
------------------------------

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

shashank.kumar280 — Thu, 17 Mar 2022 05:06:00 GMT

Hi @Agustin Rodolfo,

I have just uploaded version 2.0 of the Google Drive API asset on DX with some simplifications in terms of the number of parameters to make it easier to use. However feel free to customize it or add more relevant parameters based on the official documentation from Google https://developers.google.com/drive/api/v3/reference

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

For uploading a new file to drive there are three parameters required. Description included in the BPrelease.

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

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

PradeepPadashet — Thu, 17 Mar 2022 13:55:00 GMT

Hi Team,

We didn't get a solid way to fix the issue, need your help on fixing this as soon as possible.

Best Regards
Pradeep Padashetty

RE: Google Drive API automation using Drive API V3 skills, Getting error as Internal : Unexpected error Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection

ewilson — Mon, 21 Mar 2022 01:51:00 GMT

Hi @PradeepPadashet,

Have you had a chance to take a look at the revised Drive implementation that @shashank.kumar280 posted about above?

Cheers,

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