Anyone been able to get the file url from the appery.io databse tutorial I noticed that it's not even a column in the da

[Jason Carmen]

So when following the tutorial for uploading files to the appery.io database there is no fileurl column in the database for the response to return.

[Alena Prykhodko]

Hi Jason.

The file url can be created next:

prehttps://api.appery.io/rest/1/db/files/data_base_id/file_name/pre

For example:

prehttps://api.appery.io/rest/1/db/files/33fd3d06e4b0a25c11c89917/2203612d-4134-4b16-8caa-716e7beddc09.1.png/pre

33fd3d06e4b0a25c11c89917 - is database id.

2203612d-4134-4b16-8caa-716e7beddc09.1.png - file name for "_files" collection.

[Jason Carmen]

So the tutorial does not cover this being the case. So am I to understand that if I want that field to be a column in the database as you have pictured in your Tutorial I will need to modify the schema and the mechanism that updates it?

[Alena Prykhodko]

Jason.

You don't need to modify collection rows.
Unfortunatly this can't be do on the "Files" build-in collection.

You can generate URL based on fileName using a workaround above.