quicksoftwaresolutions/upload_blobs_sql_database repository overview

Please note this is still in test mode so use at your own risk.

Set the below-stated environment variables:

ENV database = "DB": Defined as a database to be pushed into

ENV username = "USR": SQL User name to access the database

ENV password = "PSW": SQL Password to access the database

ENV container_name = "CONT": Container Name of the Azure Blob Storage

ENV azure_conn_string = "ACS": Connection Access Key from the Storage Container

ENV schema_name= "WebSite" = Schema Name in SQL Server

ENV table_name = "DataUpload_Validate" = Table name in SQL Server

The /api/data/file_name is the Url to process the files where file_name is the name of the file.

I will change the name of this table later but this is for testing purposes.

The Script for creating the table is below:

CREATE TABLE [WebSite].[DataUpload_Validate]( [FileID] [bigint] NULL, [Field2] varchar⁠ NULL, [Field3] varchar⁠ NULL, [Field4] varchar⁠ NULL, [Field5] varchar⁠ NULL, [Field6] varchar⁠ NULL, [Field7] varchar⁠ NULL, [Field8] varchar⁠ NULL, [Field9] varchar⁠ NULL, [Field10] varchar⁠ NULL, [Field11] varchar⁠ NULL, [Field12] varchar⁠ NULL, [Field13] varchar⁠ NULL, [Field14] varchar⁠ NULL, [Field15] varchar⁠ NULL, [Field16] varchar⁠ NULL, [Field17] varchar⁠ NULL, [Field18] varchar⁠ NULL, [Field19] varchar⁠ NULL, [Field20] varchar⁠ NULL, [Field21] varchar⁠ NULL, [Field22] varchar⁠ NULL, [Field23] varchar⁠ NULL, [Field24] varchar⁠ NULL, [Field25] varchar⁠ NULL, [Field26] varchar⁠ NULL, [Field27] varchar⁠ NULL, [Field28] varchar⁠ NULL, [Field29] varchar⁠ NULL, [Field30] varchar⁠ NULL, [Field31] varchar⁠ NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO