Upload Attachment via Public API

[ecxs]

Is it possible to upload an attachment via the public API? And if so, how?

[thomaskamalakis]

Hi ecxs

What might work is exposing port 9000 of the minio container in the docker-compose.yaml and using the MINIO API to upload the file. This takes care of putting the file in the storage though, if you need to create a table entry with an attachment column pointing to this attachment you need to use the Budibase API to create the row, taking care to come up with the correct attachment column information.

[ecxs]

Hi @thomaskamalakis thanks for the tip! I was actually already looking at this, and having been playing around with the build in CouchDB and MinIO services. I managed to get an insight in how BudiBase organises their data with the help of Fauxton, for example:

I can also upload files into the prod-budi-app-assets bucket, but can not see (yet) how/where to get the right path/url. This is what I get back from the S3 node in n8n when I search the prod-budi-app-assets bucket:

I'm now going to try to find out how things are structured in MinIO ...

And to the guys and girls behind BudiBase: why are the attachments not stored in CouchDB ?

[thomaskamalakis]

Dear @ecxs
I think the url has a part that depends on the bucket and app-id and another part which seems to be generated randomly together with the file extension. This must be in order to avoid conflicts of the type: two users upload the filename "image.png" to the same table, etc.

It looks like Budibase organizes uploaded files to something like

app_id + '/attachments/' + filename

and the url is something like

'/' + bucket + '/' + app_id + '/attachments/' + filename

where filename is generated randomly plus the original file extension. This is my intuition though not exactly glanced at the source code.

Also not sure exactly how MINIO works, but I think one should upload the file using its API - maybe just putting the file in the container volume in the right path is not enough...

[ecxs]

Hi @thomaskamalakis , I think you might be right. I haven't figured out the used logic yet, and I think that instead of going down this road, I'm going to do a little write up of what I'm trying to achieve. Perhaps somebody has a better idea ;-)

[ArchonMegalon]

I can't believe, this is still not solved. I mean, storing something as binary is really a very common use case... :(

[NicolasFabre81]

Related to my question here #14645