Appsheet cannot access files in GCS that are added manually - Remote Server: File not found

[opontes]

Hi AppSheet Community,

I’m facing an issue where my AppSheet app cannot open PDF files that are generated by a Google Cloud Run Function. The app displays the error:

👉 “Remote Server: File not found.”

Setup:

1. User triggers automation bot a REST API call to my Google Cloud Run Function is called.
2. The function generates PDF file, stores it to GCS bucket and creates record in spreadsheet about that file with its URL. 
3. The spreadsheet is connected with a table in Appsheet.
4. AppSheet displays the stored URL as a file column type, but when I click to open the file, I get the error.

I tried manually creating a record with file.
✅ Generated file has the same URI structure as manualy created.
✅ Both of them are stored in GCS and has same properties.
❌ Only manually enetered file can by showed in Appsheet, genereted one is returning error message: 

Remote Server: File not found

Has anyone encountered a similar issue or has a recommended solution? Any help would be greatly appreciated!

Thanks in advance! 😊

[Aurelien]

Hi @opontes 

I had quite a similar situation a while ago.

You need to define in your AppSheet editor the relative path to your bucket, using a double-slash at first.

Solved: How to store in a specific folder of Google Cloud ... - Google Cloud Community

[opontes]

Hi @Aurelien,

I read your question before I opened this one and I am using the relative path to the bucket with double slash like this:

However, I am able to open just those, which are uploaded directly through Appsheet application. When I try to open those that I put manually to GCS it throws me an error message: 

Remote Server: File not found

[opontes · Accepted solution]

I now have a clear and final answer on this topic.
TL;DR: Unfortunately, it’s not possible.

For those interested in the details:

[Aurelien]

Thank you for the update!