All Questions
3
questions
-1
votes
1
answer
506
views
SQL JSON_VALUE query but without path names?
I have json data that I am trying to import in to a SQL Server database but it doesnt have path names to reference - how do I go by indentifying the different elements here:
Sample json: https://api....
1
vote
1
answer
266
views
SQL query OpenJson with deep nested arrays loop
I know there a lot of similar questions and answers here. I've read most of them but I'm unable to query nested arrays in a JSON structure. I'm lost in the CROSS APPLY's.
I'm actually querying a web ...
0
votes
1
answer
951
views
SSMS: OPENJSON works but not with direct REST call
Following this article I'm trying to implement a query that could retrieve data from a REST call and parse the JSON with OPENJSON.
I call this URL with Postman to check if the data are alright:
The ...