How to store file URLs in DB using App Connect S3 Upload

[miu]

Hello All,

I am considering using S3 for managing file uploads for my project. I have read multiple tutorial & have a fair understanding of implementing S3.
Using the file uploads component, I know how to store file URLs in the DB.

I want to understand, can I use the App Connect S3 Upload component to store file URL's for multiple uploads. And if yes, then how to create SA for storing multiple URLs of the file uploads in the DB.

Using App Connect S3 Upload

Intro App Connect S3 Upload component allows you to do client side uploads to S3 cloud storage. Unlike the Server Connect S3 Upload workflow, where it’s required to first upload the files on your server, with App Connect S3 Upload you upload your files directly to the S3 cloud storage. Make sure to properly setup S3 Full Access on AWS before following this tutorial: Set up CORS In order to be able to upload files from your site, you need to setup the CORS configuration for your S3 cloud sto…

[GraybeardCoder]

@Teodor You never touched on how to retrieve the file’s object storage URL so it can be loaded into a database. There seem to be several issues with the multi component as well.

When using the S3 Sign Upload Template in Server Connect, the Set Value “url = {{sign}}” step is not capturing any data. It is “undefined”, shown from my server logs:

server-connect:output url: undefined +4ms

The correct variable reference would be signedUrl, which is the Name given to the S3 Sign Upload URL step. I’m currently using the following to just get the file’s URL:

{{signedUrl.split('?').top(1)}}

Also, it should be said that when using the Multi template, the signed URL API will be called once for each file submitted. This requires an approach in the App Connect or separate Server Connect API to be ready to handle each file’s URL so they can be stored in the application’s DB.