How to extract array values into datatable from Json data

Help Studio
, ,
1

Hi, I’m unable to extract array values into DT format from Json data (JObject). Can someone please help ??

JObject -

Input -

JObject(4)
{
JProperty(1)
{
[553]
},
JProperty(1)
{

},
JProperty(1)
{
[2]
},
JProperty(1)
{
JArray(553)
{
JObject(8)
{
JProperty(1)
{
[Mindshare]
},
JProperty(1)
{
[LIVERPOOL VICTORIA GEN INS. (A1LR5)]
},
JProperty(1)
{
[BRAND (A1LR53)]
},
JProperty(1)
{
[MOTION CONTENT GROUP]
},
JProperty(1)
{
[ITVSALES]
},
JProperty(1)
{
[ITVDIG]
},
JProperty(1)
{
[ITVBE]
},
JProperty(1)
{
[18816718]
}
},
JObject(8)
{
JProperty(1)
{
[Mindshare]
},
JProperty(1)
{
[LIVERPOOL VICTORIA GEN INS. (A1LR5)]
},
JProperty(1)
{
[BRAND (A1LR53)]
},
JProperty(1)
{
[MOTION CONTENT GROUP]
},
JProperty(1)
{
[ITVSALES]
},
JProperty(1)
{
[ITVDIG]
},
JProperty(1)
{
[ITV4]
},
JProperty(1)
{
[22208766]
}
},
JObject(8)

Output -

image
image801×122 5.85 KB

2

Hi @arpitsharma1.sharma

This will help