Write Range GSuite Issue

[ajgb]

Hello everyone, Im getting this error when I use a write range activitie of the GSuite:

20.4.1

Source: Write Range

Message: Invalid JSON payload received. Unknown name “Data”: Cannot find field.
Invalid JSON payload received. Unknown name “ValueInputOption”: Cannot find field. [400]

Exception Type: Google.GoogleApiException

RemoteException wrapping Google.GoogleApiException: Invalid JSON payload received. Unknown name “Data”: Cannot find field.
Invalid JSON payload received. Unknown name “ValueInputOption”: Cannot find field. [400]
at Google.Apis.Requests.ClientServiceRequest1.<ParseResponse>d__35.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Google.Apis.Requests.ClientServiceRequest1.d__31.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Sheets.Extensions.SheetsServiceExtensions.d__6.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.<>c__DisplayClass29_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Shared.TelemetryService.NullTelemetryService.d__11.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.d__29.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Activities.WriteRange.d__32.MoveNext()
— End of stack trace from previous location where exception was thrown —
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.ContinuableAsyncCodeActivity.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 don’t know what am I doing incorrectly.
This is the sequence i have developed:

Could you help me?

[Rahul_Unnikrishnan]

Hello @ajgb

As per the error the issue is with the data which you are trying to Write using write range activity.

Can you try to Write a normal datatable to the activity and check?

Also you can debug and check the dtAux datatable.

[ajgb]

Thanks for your answer. This is the dtAux datatable before de write range activity:

[Ishan_Shelke1 (Ishan Shelke)]

Is your arrRow variable set to as string or are you treating it as a dictionary variable ?

[ajgb]

It is an array of String:

[Rahul_Unnikrishnan]

can you remove the from the data and check once.

[ajgb]

I update the package of the GSuite and it works propperly. No changes in the sequence was needed.

Thank you.