Download the output file from GCS

[Julienec]

I attempted to download the output file from the GCS bucket but encountered the following error: "Remote Server: File not found", even though the file is present in the folder.

Below is the file path I am trying to access from the data source:
CheckDigit/output/partition_date=/CheckDigit_CDGT_250121_17273_6ff3058b.bulk_upload.090240.csv


Here's the bucket in GCS :

Here's the Default app folder:

Could you advise on how to resolve this issue and download the file successfully? What should I need to put here in File folder path.

This is the action where I trigger the download button : 

[WillowMobileSys]

In short - AppSheet looks for files for columns in the path.... "root" + Default app folder + column folder path   

-   "root" is the root in the the cloud provider service
-  Default app folder is the folder(s) defined in the app settings
-  column folder path is the folder(s) define in the column settings

The key is knowing what AppSheet identifies as the "root" folder in the cloud service.

FIRST...
           Is the CSV file being generated from within AppSheet?

If not, then you either need to:
     1)  place the files within the Appsheet folder structure to access them from a File type column (then follow below so Appsheet can find them). 

OR...     

2)  need a URL type column and will need provide the FULL path to the CSV file.


If the files are generated from AppSheet then...
...well, I have not used this side of Google's cloud storage, BUT....you need to understand where the "root" folder is from AppSheets perspective.  You can probably easily identify this by searching for the "appsheet" folder - unless it's been deleted.   

When an app is first created, the App default path is set to "/appsheet/data/NameOfApp-123456"  where NameOfApp=123456 is your app identifier.  Try searching for this "appsheet" folder.  It will be inside the "root" folder.

From this root folder, you need to decide how you want your app folder structure to be defined.  You could stick with the default of "/appsheet/data/NameOfApp-123456"  or maybe use just "/NameOfApp-123456".   

Once you have the App default path identified, then this is where you would want your CSV files to live.  For example, maybe you name it "CSV Files" and insert all your CSV files into it.  Then back in your app, for the "action" File type column, you would simply list the folder "CSV Files" (slash is not needed).

However, you also will need to make sure that the automation that is generating the files (whether AppSheet or something else) is ALSO inserting the files into the expected folder.

I hope this helps!!