My database table is created as :
declare @library table (dependencies varchar(max))
insert into @library values('{"jar":"azure.com","maven":"azure.com","maven":"azure.com","maven":"azurebook.com"}')
I am trying to have JSON as
{
"libraries":[
{
"jar" : { "coordinates":"azure.com"}
},
{
"maven" : {"coordinates":"azure.com" }
},
{
"maven" : {"coordinates":"azurebook.com" }
}
]
}
And my SQL code looks like
SELECT
(
select
j.jar as [jar.coordinates],
j.maven as [maven.coordinates]
FROM OPENJSON(l.dependencies)
WITH (
jar varchar(100),
maven varchar(100)
) j
FOR JSON PATH
) as libraries
FROM @library l
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER;
And my output which is not same as desired json
{
"libraries":[
{
"jar" : { "coordinates":"azure.com"}
},
{
"maven" : {"coordinates":"azure.com" }
}
]
}
As in my output, my other property or column maven does not including. Can somebody help me out?
Thank you