Trying to understand Storage Buckets

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?

How are you trying to read the file?

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…

Path.Combine("C:\Users",Environment.Username,"Downloads","YourFilename.xlsx")

Thanks for your help!

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:

Path.Combine("C:\Users",System.Environment.Username,"Downloads","okToDelete.xlsx")

2 Likes

Hi there,

Can you share a screenshot of the activity showing the properties?

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?

It’s a common thing that a lot of people have run into since Windows compatibility mode was released, and there are tons of posts on it already.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.