python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - open-json

OPENJSON() optimization for poorly structured API response

I'm trying to use the TSheets API to pull data into my internal database, but the responses come back in a way that I can't figure out how to efficiently get it into table structure. I've simplified t...
test-img

Peter

sql-server

tsql

open-json

Votes: 0

Answers: 1

Latest Answer

Like this: select u.* from openjson(@user_response, '$.results.users') d cross apply openjson(d.value) with ( id int '$.id', first_name varchar(200) '$.first_name', last_nam...
test-img

David Browne - Microsoft

Json to table without explicit key names

I have a table with an VARCHAR(MAX) column which stores JSON key value pairs. The JSON document schema is simply a different number of key value pairs, no nesting, nor arrays in there. I wish to build...
test-img

Avi

json

sql-server-2017

open-json

Votes: 0

Answers: 1

Latest Answer

Perhaps something like this will work for you. This uses a CTE to get the DISTINCT key's from your JSON. Then string aggregation to create a dynamic statement, which you can see from the PRINT stateme...
test-img

Thom A

pyodbc azure sql server error in saving json using openjson

i want to save a json array into azure sql server, but i am getting this error: \serverCalls\sqlManager.py", line 95, in populateNewsLatest curse.execute(f""" pyodbc.Error: ('07002...
test-img

utkarsh choudhary

azure

azure-sql-database

pyodbc

azure-sql-server

open-json

Votes: 0

Answers: 1

Latest Answer

Below are the few things which needs to be checked: As Gord suggested check for the json strings. We can use executemany to run the command if we have more data, as execute might lead to count issue...
test-img

SaiKarri-MT

Posts

Questions

Blogs

Jobs