RE: DATA-INTO & nested JSON

Have you tried using YAJLGEN over your JSON?

Save your JSON on the IFS, run the YAJLGEN command against it to create the DS in a source member.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Friday, June 05, 2020 12:55 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: DATA-INTO & nested JSON

I'm trying to parse nested JSON using DATA-INTO and YAJL/YAJLINTO.
The top level parses fine, but it's giving me an error on subsequent
levels (4. The document is missing information to match subfields).

Here's a simple example I created.

Dcl-ds jsonDs qualified inz ;
elementA varChar(255) ;
elementB varChar(255) ;
Dcl-ds nestedOne inz ;
elementD varChar(255) ;
End-ds ;
elementC varChar(255) ;
End-ds;

Data-into(e) jsonDs %data(json :'case=any allowextra=yes')
%parser('YAJL/YAJLINTO');

Using this JSON:
{
"elementA":"alpha",
"elementB":"bravo",
"nestedOne":"{\"elementD\":\"delta\",\"nestedTwo\":{\"elementE\":\"echo\",\"elementF\":\"foxtrot\"}",
"elementC":"charlie"
}

Can anyone shed some light on what I'm doing wrong?

TIA