Ahh thats why:) I will go ahead and change the source JSON, thanks for your input and help:)

That is the desired results - however, I would love a solution where I didnt have to change the JSON - is that possible?

And if I do like this


SELECT *
FROM OPENJSON(@json,'$.api.names."1"')
WITH(
firstname nvarchar(255),
lastname nvarchar(255)
) a

I can get the first "row" just like...

Not a test file, just cleaned up the scripts from company related stuff;)

And so will i do with the json file, cant upload a json file. But the...