Re: RPG and XML or JSON

On May 20, 2021, at 3:22 PM, Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx> wrote:

Jon,
The OP is on IBMi 7.1, so although DATA-GEN existed in 7.1, I do not thing DATA-INTO was introduced until IBMi 7.2 ...? :-o
Hence, the need for other tooling like NOXDB ...
Just saying ...
Mark S. Waterbury
On Thursday, May 20, 2021, 03:13:14 PM EDT, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

YAJLINTO for DATA-INTO and YAJLGEN for DATA-GEN both shipped with Scott's YAJL library.

Both work beautifully and are very fast.


Jon Paris

On May 20, 2021, at 2:22 PM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

Jon,
Then please show me a handler that is already written for consuming any JSON data.
I haven't found any.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser


"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Donnerstag, 20. Mai 2021 17:40
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: RPG and XML or JSON

You don't have to "write any programs" Birgitta - they are already written.


Jon Paris

On May 20, 2021, at 1:39 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:

I'd have a look at the SQL Functions that are available (for
generating and consuming XML and JSON).
IMHO it is much easier to use this functions in composition with
embeeded SQL than writing any handler programs in composition with
DATA-GEN and DATA-INTO and/or using YAJL.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser


"Shoot for the moon, even if you miss, you'll land among the stars."
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training
them and keeping them!"
„Train people well enough so they can leave, treat them well enough so
they don't want to.“ (Richard Branson)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dave
Sent: Mittwoch, 19. Mai 2021 22:52
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: RPG and XML or JSON

Hi,

I need help to decide if the YAJL Open Source JSON Tool is the right
choice for us.

I'm working on a new application that will accept and return data in
JSON format.
The company that will be sending the data already receives it in XML
format from their client and converts it to JSON that it sends to us.
Then, on receiving our JSON response, it will convert it back to XML for the client.
We are currently only used to dealing with XML formatted data only and
have no JSON experience. We have a couple of possibilities that would
enable us to convert the data from JSON to XML and back which would be
a shame to have to do.

We need to weigh up the cost between implementing a solution that we
know how to do and one that we don't but looks better.
How can I go about estimating the time to install and deploy the YAJL
solution? Is it an easy solution to implement?
Is there any way of estimating the effect on the response times if we
were to convert the JSON to XML? That would mean 4 conversions of the
data from XML to JSON and back.

Thanks!
--
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

--
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

--
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

--
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

--
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

--
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