This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Download file from GCS

Posted on 12-08-2024 10:26 PM
Julienec
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have an app where I upload a file, which is then saved to the input folder in Google Cloud Storage (GCS). I also need to download the corresponding output file from the output folder in GCS. When I use the file path for the input folder, the file downloads correctly(but the downloadable file is incorrect since its a input file). However, when I use the file path for the output folder, I get an error stating that the file is not found. What formula should I use to correctly access the file in the output folder?

Please help with the expression

0 2 174
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM
@Julienec wrote:

I also need to download the corresponding output file from the output folder in GCS

You'll need to elaborate on this.  What is this output file, what path is it in and how does it get there?

To explain a little...I'll assume you are using Google sheets as the datasource?   

When using File columns, the path constructed to put or find files uses a "root" folder.  That folder is determined by the location of the Google sheet.  Any path info you supply will start with this "root" folder and then attempt to apply your path info to search from there.

If your output files are being generated by some external process, you'll either need to have the process places the field into a folder under the "root".   Or you will need to use a URL based column, specifying the FULL path to find the file.

I hope this helps!  

 

Posted on --/--/---- --:-- AM
Julienec
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I am encountering an intermittent issue when attempting to download an output file from the GCS output folder. At times, the file downloads successfully, but occasionally, I receive the following error:

Error retrieving file 'Module/OutPut/2024_12_10_10_41_10/243dfe45.bulk_upload.024110.csv': Value cannot be null. (Parameter 'input')
By the way, the filepath is being saved to a [file] column. 
The folder and file do exist in GCS, and we do not have a parameter named 'input' in AppSheet, GCS, or the file itself.


Could you please assist in identifying the root cause of this issue and advise on how to resolve it?

Thank you for your support.

0 Likes