Upload CSV to SQL Server via Azure Function
Budget: $15 – $25 USD
This NuGet project provides sample source and instructions to enabled a .csv file to be added to Azure Blob container. An Azure function then takes the file and calls a SQL Stored procedure which updates two Azure SQL Tables (one with a record of the uploaded .csv file, and another with the contents from the .csv)
https://github.com/yorek/AzureFunctionUploadToSQL
The solution works fine if using the sample CSV.FMT file and Test.CSV - which only includes 3 NVARCHAR(100) / SQLCHAR columns.
I NEED TO GET THE SOLUTION TO WORK WITH THE ATTACHED CSV TEMPLATE which should be inserted to a table:
[DeliveryTime] DATETIME2 NOT NULL,
[Email] NVARCHAR(500) NOT NULL,
[FirstName] NVARCHAR(500) NULL,
[LastName] NVARCHAR(500) NULL,
[UserData] NVARCHAR(max) NULL,
[UserData2] NVARCHAR(max) NULL,
[UserData3] NVARCHAR(max) NULL,
[UserData4] NVARCHAR(max) NULL
Requirements:
-FREELANCER must use their own Azure Environment to dev and test
-Success Criteria is to provide the following
--Updated Format File (CSV.FMT)
--Updated SQL File (See Draft.sql)
Please reference the instructions https://github.com/yorek/AzureFunctionUploadToSQL and sample files for the basic working example
https://github.com/yorek/AzureFunctionUploadToSQL
The solution works fine if using the sample CSV.FMT file and Test.CSV - which only includes 3 NVARCHAR(100) / SQLCHAR columns.
I NEED TO GET THE SOLUTION TO WORK WITH THE ATTACHED CSV TEMPLATE which should be inserted to a table:
[DeliveryTime] DATETIME2 NOT NULL,
[Email] NVARCHAR(500) NOT NULL,
[FirstName] NVARCHAR(500) NULL,
[LastName] NVARCHAR(500) NULL,
[UserData] NVARCHAR(max) NULL,
[UserData2] NVARCHAR(max) NULL,
[UserData3] NVARCHAR(max) NULL,
[UserData4] NVARCHAR(max) NULL
Requirements:
-FREELANCER must use their own Azure Environment to dev and test
-Success Criteria is to provide the following
--Updated Format File (CSV.FMT)
--Updated SQL File (See Draft.sql)
Please reference the instructions https://github.com/yorek/AzureFunctionUploadToSQL and sample files for the basic working example