All Questions
8
questions
0
votes
0
answers
34
views
Unable to Parse the Json file using Open Json in SQL
I've a JSON file content and I want read the content using Open JSON and load it into the SQL.
need help in loading the content to SQl.
{
"Header": {
"Time": "2023-...
1
vote
1
answer
70
views
Parse JSON Column containing multiple arrays
I'm trying to get this result but I'm not getting it. I've searched the forum but I can't find a solution to my problem. Can you help me and explain what is wrong with my query?
thanks.
JSON
{
"...
- 39
2
votes
1
answer
384
views
sql-server OPENJSON ways to parse multiple array value elements as one element?
Is there is any other (more pretty) way to accomplish the following?
I am struggling with a way to display multiple elements of an array as one element.
I have a JSON-string, that looks like this:
...
- 23
0
votes
1
answer
695
views
OPENJSON SQL call to API with record pagination
I'm trying to consume an API, parse the data and then put it in a table. I've done several tests and I can't have all the records because the API has pagination.I've seen other posts and I can't find ...
- 39
0
votes
1
answer
249
views
Can't get access to data from nested json's array
How to retrieve values from employment_types (type, salary) and skills (name, level) arrays and show them in columns? I tried with employment_types and it doesn't work not to mention skills:
declare @...
- 135
0
votes
2
answers
221
views
Parsing with OPENJSON
I am trying to take the response from a GET call and load it into SQL Server via OPENJSON, but I'm having trouble parsing the response.
DECLARE @json NVARCHAR(MAX);
SET @json = N'{
"...
- 154
1
vote
1
answer
184
views
Parse JSON SQL with OPENJSON skipping OBJECTS
I'm trying to parse a json file using OPENJSON in Azure sql but I want to do a specific mapping in my new table.
I have a json file which looks like this with many y0_1, y0_2, ....y0_380.
{"...
- 23
70
votes
3
answers
102k
views
SQL Server OPENJSON read nested json
I have some json that I would like to parse in SQL Server 2016. There is a hierarchy structure of Projects->Structures->Properties. I would like to write a query that parses the whole hierarchy but ...
- 2,423