Re: Writing JSON objects from one JSON structure to another -- MIDRANGE-L

I should ask.. Is there a way to not have to name the node? In my case, I
have multiple JSON files, each with array entries..like this:

{
"orders": [{
"ID": 106706,
"Total": 640.00
}, {
"ID": 106707,
"Total": 240.00
}
]
}

{
"orders": [{
"ID": 106708,
"Total": 610.00
}, {
"ID": 106709,
"Total": 20.00
}
]
}

Into:

{
"orders": [{
"ID": 106706,
"Total": 640.00
}, {
"ID": 106707,
"Total": 240.00
}, {
"ID": 106708,
"Total": 610.00
}, {
"ID": 106709,
"Total": 20.00
}
]
}

When I'm done, I want all the array entries (and any subnodes) in the array
in one json structure. Then I can just write that out to a stream file
like I would any other JSON that I've created with YAJL.

If you look at the original post I did, I was reading through and array and
trying to use yajl_addChar(yajl_stringify(node)) to add it, but of course
that didn't work mainly because it was escaping everything in the string.

I will download and take a look. It's probably something that can be
modified if need be.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #15 <https://www.bvstools.com/mailtool.html>: The ability
to add a Footer to each email sent using an IFS stream file.

On Fri, Mar 9, 2018 at 4:32 PM, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
wrote:

Hi Brad,

This turned out to be extremely easy, so I went ahead and added it. If you
download the current version of YAJL from my web site, it now contains a
routine named "YAJL_genFromNode". The idea is that if you have a pointer
to a node, you can call this routine to generate it into the JSON document
you are currently generating. (including any sub-elements)

So you'd do something like this:

node = yajl_object_find(parent: 'myNode');
yajl_genFromNode('myNode': node);

Hope that helps!

-SK

On 3/8/2018 5:11 PM, Scott Klement wrote:

Hi Brad,

In YAJL, the reader and generator are two completely different things,
it's just the way it was designed.

So what you'd need to do is write a routine that basically loops through
the data in a given element, and calls the generator routines to add it to
the current document. That's actually very similar to what the stringify
routine does internally, except that stringify creates a separate document
and then returns the output as a string rather than adding it to the
existing open document that the RPG caller is generating.

So this would not be hard to create. If I can find the time, I'll try to
add the feature. But, it's bad timing because my spring conferences all
start next week, so I have a lot of extra work on my plate right now.

-SK

On 3/8/2018 8:30 AM, Bradley Stone wrote:

Because the end result was going to be a stream file anyhow, I just
updated
the application to read the JSON, stringify it, then write it out using
IFS
APIs.

Pretty simple but it would be nice to have something to add to a json
buffer using a node from another json buffer.

The reason for doing this is a web service I am working with for a
customer
returns a max of 20 records at a time. So I needed to join all the
information in each set of records into one JSON file.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #4 <https://www.bvstools.com/mailtool.html>: Easily add
attachments of any type from the IFS to outgoing emails.

On Wed, Mar 7, 2018 at 5:03 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

Yep. Pouring through the source too. Can't find anything. I don't want

to modify the C source either.. been a while for that.. lol.

If there was a way to parse through a tree without knowing the names and
values/types I could probably do it that way,. But I'd like to say
"take
this node, and insert it in the json I'm generating".

Right now it "almost" works with yajl_addChar(yajl_stringifyStr(node))
except that it of course escapes quotes and slashes, etc. And that
seems
to be a setting in the C source.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #13 <https://www.bvstools.com/mailtool.html>: The
ability to use an IFS stream file as the body of the email (either text
or
html).

On Wed, Mar 7, 2018 at 11:38 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Have you looked at the base YAJL docs Brad? I'm in a hurry or I'd check

- but I found a couple fo useful "bits" when I went through them.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 7, 2018, at 11:12 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

I am looking into trying to read through one set of JSON data and
write
certain objects/trees to a new JSON file.

Example:
yajl_genOpen(*OFF);
yajl_beginObj(); //main JSON object
yajl_beginArray('newList');

// load the old JSON data from a stream file
docNode = yajl_stmf_load_tree(jsonFile);

//find the array "list"
myList = YAJL_object_find(docNode: 'list');

i = 0;

dow YAJL_ARRAY_LOOP(myList:i:node );
yajl_beginObj();

//****write the contents of the "node" array object to the new JSON
buffer*****
yajl_endObj();
enddo;

yajl_tree_free(docNode);

yajl_endArray(); //newList
yajl_endObj(); //main JSON object
yajl_genClose();

I have tried:

yajl_addChar(yajl_stringifyStr(node));

But that stringifies and "escapes" the old JSON data. So what I'm

looking

for is something like:

yajl_addNode(node);

Where it will take a node loaded from another JSON object and add it
directly to the new JSON buffer. Not sure if that's possible. Just

want

to make sure there isn't something already out there that may do this
before I try digging into making a solution.

Thanks!

Bradley V. Stone
www.bvstools.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our
affiliate

link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD