Error: The request is not as expected by Google API

Help Studio
1

Hi All, Getting the following error on Orchestrator for a G-Sheet Read Range in sheet called ADM and specifically columns AE to AK.

The error: UiPath.GSuite.Exceptions.GSuiteException: The request is not as expected by Google API.

Full error message: —> UiPath.GSuite.Exceptions.GSuiteInternalException: The request is not as expected by Google API. —> The service sheets has thrown an exception. HttpStatusCode is BadRequest. Unable to parse range: ADM!“AE:AK” [400] Google.GoogleApiException: The service sheets has thrown an exception. HttpStatusCode is BadRequest. Unable to parse range: ADM!AE:AK at Google.Apis.Requests.ClientServiceRequest1.ParseResponse(HttpResponseMessage response) in C:\Apiary\2023-06-26.09-20-33\Src\Support\Google.Apis\Requests\ClientServiceRequest.cs:line 256 at Google.Apis.Requests.ClientServiceRequest1.ExecuteAsync(CancellationToken cancellationToken) in C:\Apiary\2023-06-26.09-20-33\Src\Support\Google.Apis\Requests\ClientServiceRequest.cs:line 217 at UiPath.GSuite.Sheets.Services.SheetsServiceWrapper.ExecuteAsync[TResponse](SheetsBaseServiceRequest1 request, CancellationToken cancellationToken) at UiPath.GSuite.Sheets.Extensions.SheetsServiceExtensions.A1NotationToGridRangeAsync(ISheetsServiceWrapper service, String spreadsheetId, String a1RangeNotation, CancellationToken cancellationToken) at UiPath.GSuite.Sheets.Extensions.SheetsServiceExtensions.GetRangeMetadataInformationAsync(ISheetsServiceWrapper service, String spreadsheetId, String range, ISpreadsheetFile spreadsheetFile, RangeType rangeType, CancellationToken ct) at UiPath.GSuite.Sheets.Extensions.SheetsServiceExtensions.GetRangeMetadataInformationAsync(ISheetsServiceWrapper service, String spreadsheetId, String range, RangeType rangeType, CancellationToken ct) at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.<>c__DisplayClass33_01.<b__0>d.MoveNext() — End of stack trace from previous location — at UiPath.Shared.TelemetryService.NullTelemetryService.OperationContextAsync(Func2 method) at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.ReadRangeAsync[T](ReadRangeRequest readRangeRequest, CancellationToken cancellationToken) at UiPath.GSuite.Activities.ReadRangeConnections1.SafeExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken) at UiPath.GSuite.Activities.BaseLeafConnectionServiceActivityWithoutBindings.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken) — End of inner exception stack trace — — End of inner exception stack trace — at UiPath.GSuite.Activities.BaseLeafConnectionServiceActivityWithoutBindings.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken) at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at UiPath.Shared.Activities.ContinuableAsyncCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at UiPath.GSuite.Activities.GoogleBaseClientActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

I’ve tried multiple manipulations of the Range using ", ', shortening the range, etc. The ‘Read Range’ Activity is also between 2 log messages. The previous step is executing.

Global handler is in use and the above activity is being triggered by the handler before it goes into error. Below is a screenshot of the issues.

The image shows a log or dashboard with error messages related to Google API requests and UiPath exceptions, as well as an informational message about license status. (Captioned by AI)
The image shows a log or dashboard with error messages related to Google API requests and UiPath exceptions, as well as an informational message about license status. (Captioned by AI)1610×313 58 KB

When running the workflow locally, it runs smoothly without running into any errors. This problem is only faced when published on the orchestrator.

I’ve also tested the activity on its own in a separate test workflow, and it worked.

2

Hi!

Are you using the classic activities or the new ones with integration service?

3

I’m using the new ones

4

The error makes it seem (at least to me) as if the range gets sent as ‘ADM!AE:AK’, and not ‘AE:AK’, that’s why it says ‘Unable to parse…’
I have no idea why that happens when run from the orchestrator and not when you run it locally.

5

I might be wrong though, and the range is correct…

6

yes range is correct. Locally it works too