Hi, I want to read a date value from google sheets using UiPath.Gsuite.Activities.ReadCellConnections, connection ok, cell found:
When I run the process I have this error (System.Exception: Could not retrieve the result of the job execution. This might be because a message was too large to process.), its strange because its only one cell, one date value, it shouldnt be that large… The output variable has DateTime type.
When I tried to fill the cell with string and read it, it runs ok…
This does not mean the cell value is too large to process. It means there is an error message, and “the (error) message is too large to process”. Sometimes the error message will include the entire content of the file converted to thousands of lines of text, which UiPath integration will not handle.
I have found Google Sheets error messages are difficult to diagnose. This one could be related to the google account, the file / folder location, access permissions to the file, sheet name, basically anything.
Try some other simpler Google activities to make sure UiPath can access the file, like Get File or Create Sheet. If that works try reading a non-named range like A1. Hopefully something points you in the right direction, but again this message is very generic and difficult to diagnose.
Thanks. Its not related to any of the issues you have listed, as I wrote, when I enter a string to the target cell, it retrieves it. So it must be something with the DateTime value, still cant figure it out…
