User Input Upload to Azure DB Table

Discussion
1

Hi All. I am building an app with the goal of having the user input / upload data (Excel, Google Sheets, Ctrl +C/V, or some other way). I will then load that data into an Azure table.

The number of rows can easily exceed 10K, so manual, hand-keying is not an option.

Is this possible? If so, how would you recommend I go about doing that? Thank you!

Feel free to point me in the direction of an existing topic if this has already been addressed.

2

Hey @jay_btg, you likely want to leverage a Bulk insert records Action in a GUI mode query to your MSSQL resource.

Screenshot 2024-01-09 at 10.49.06 AM
Screenshot 2024-01-09 at 10.49.06 AM1026×688 17.7 KB

You should be able to take the data uploaded into Retool and insert it into an Azure table with this query.

3

Thank you Joe. Appreciate the information. I am going to try that, and this option I found in the docs. Insert CSV data into a database | Retool Docs

1 Like