I’m playing with using Storage Buckets in an unattended process.
Here’s the issue I’m facing. I have an excel file in a storage bucket that I need to read. Apparently, it there’s no way to “read” an excel file in a storage bucket directly, you must first download it.
So I use the “Download Storage File” activity. I can see that it did download to a local path.
But when my bot tries to “read” that file, I get an error:
User does not have Connections.View permissions…".
This is so confusing. A bot can write to a file, but then not read the exact same file?
How to accomplish this? Is using excel in Storage Bucket not the way to go? Alternatives?
Anyway, just control where it puts the file. Give it a full path and filename in the “file name and location” property. Also, always use Path.Combine when building paths, so something like…
I put this in the File and Location property:
Path.Combine(“C:\Users”,System.Environment.Username,“Downloads”,“okToDelete.xlsx”)
But I got this error:
Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.
That’s because you copied and pasted from the forum, so the double quotes are the wrong characters. Just fix them, so they are the normal double quotes:
Paul how in the world did you know this error? I would have wasted days figuring that one out. Seriously, VisualBasicValue ‘1’ requires compilation? WTH?