Azure Logic Apps Import csv from BLOB storage into Azure SQL VM

Jason Squires 1

I have a logic app process that downloads email attachments and moves them into blob storage. I am wanting to move from blob storage into Azure SQL VM and I get the following error: "error": {
"message": "A value must be provided for item."
},
I have created the gateway and have established appropriate connections. What would be the best process to move from blob into Azure SQL VM using logic apps. In the mean time, I have created a Posh script to do this in the mean time. I would prefer to use one universal solution.

Mike Urnun 9,766 Reputation points Microsoft Employee

2020-09-17T02:47:55.933+00:00

Hello @Jason Squires - Could you share a screenshot of your Logic Apps workflow and elaborate on the data type of the attachments that need to be inserted into your SQL DB?
Jason Squires 1 Reputation point

2020-09-23T17:10:14.49+00:00

Data types are all the same, varchar(max)
Mike Urnun 9,766 Reputation points Microsoft Employee

2020-09-26T02:26:54.147+00:00

Thanks @Jason Squires - If data types are all valid and correct for each item, could you check if all of the columns in your SQL table are being provided with proper values from the payload? If none of these work, I can send you a private message to request specific details about your Logic App and we can take a closer look with the help of our support engineers to troubleshoot the root case.
Jason Squires 1 Reputation point

2020-09-28T12:59:19.133+00:00

The data types in the SQL table are all the same. Go ahead and private message me at your convenience. Thank you! I feel I am not doing something right, but I cannot figure it out yet.

Share via

Azure Logic Apps Import csv from BLOB storage into Azure SQL VM