Load specific json data to qlik

[Winter255]

Hello Gents,

Having issues trying to implement the following solution for json file load:

https://community.qlik.com/t5/QlikView-App-Development/Qlikview-and-Json-api/m-p/798923#M282134

I have json file structure such as:

{
"SoldItems": [
{
"ItemId": 1137722,
"exRate": 0.1788,
"exRate2": 0.5541,
"snp": 0.014
},
{
"ItemId": 1137723,
"exRate": 0.1388,
"exRate2": 0.5341,
"snp": 0.013
},
{
"ItemId": 1137724,
"exRate": 0.1668,
"exRate2": 0.5555,
"snp": 0.015
}

............
]
}

Could you please suggest the right solution to get the following outcome:

table with 4 columns  ItemId, exRate, exRate2, snp

[Winter255 · Accepted solution]

Best solution for such json structure located here:

https://community.qlik.com/t5/QlikView-Documents/Extracting-data-from-non-nested-Json-arrays/ta-p/14...