RE: DATA-INTO & nested JSON

Your json has two nested levels and your DS has only one.

Have you tried to generate the DS using the YAJLGEN command?

El 05-06-2020 14:40, Greg Wilburn escribió:

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
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l [1]
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l [2].

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com [3]

Links:
------
[1] https://lists.midrange.com/mailman/listinfo/rpg400-l
[2] https://archive.midrange.com/rpg400-l
[3] https://amazon.midrange.com

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --