Jan-20-2019, 06:41 PM
Hello guys,
I implemented a flask REST api. I want to insert JSON data into MSSQL 2016. I wonder if I can use OPENJSON in my python.I installed pyodbc and connect to MSSQL. How can I use insert statment like below in my python code?
I implemented a flask REST api. I want to insert JSON data into MSSQL 2016. I wonder if I can use OPENJSON in my python.I installed pyodbc and connect to MSSQL. How can I use insert statment like below in my python code?
INSERT INTO SalesReport SELECT SalesOrderJsonData.* FROM OPENJSON (@jsonVariable, N'$.Orders.OrdersArray') WITH ( Number varchar(200) N'$.Order.Number', Date datetime N'$.Order.Date', Customer varchar(200) N'$.AccountNumber', Quantity int N'$.Item.Quantity' ) AS SalesOrderJsonData;Best Regards.