Re: DATA-INTO & nested JSON

JSON objects consist of Name/Value pairs. In order to work with DATA-INTO,
Parsers are supposed to call procedure QrnDiReportName() when a Name is
encountered in a JSON document. Since your JSON uses an Escape sequence
(/") in a Name node, I suspect that YAJLINTO is passing a quoted name to
QrnDiReportName(). I suspect that the code behind DATA-INTO is comparing:

Data-structure subfield elementD to "elementD" and not coming up with a
match because of the quotes.

At any rate, this is probably a good reason to not use Escape sequences in
JSON Names. Escape sequences in Names may pass a validator. But I would
suggest only using them in Values; not Names.





On Fri, Jun 5, 2020 at 11:19 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

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
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

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