JSON Blob into SQL Server

Question

I have data from a web API that I want to store in a SQL database. Each record in the web API looks like this:

>>> inci[1]
>>> Out[47]: 
{'@odata.etag': 'W/"97914784"',
 x

JSON should probably be nvarchar(max). If the property names are fixed you can read into proper column using OPENJSON — Charlieface
– Charlieface, Commented Dec 9, 2021 at 1:03

David Browne - Microsoft · Accepted Answer · 2021-12-08 23:26:21Z

1

That query is invalid. Should be of the form INSERT INTO TableName(Column1, Column2) VALUES (?,?), so something like:

 cur.execute("""INSERT INTO IncidentBLOB(IncidentBLOB) VALUES (?)""", json.dumps(incident))

answered Dec 8, 2021 at 23:26

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Your result wans't working at first, but then I changed the column type to nvarchar instead of varBinary and it now works. Thank you for your help!