Re: RPG and XML or JSON

I completely agree with this, while the XML and JSON SQL functions are a bit daunting to learn at first, they are incredibly powerful and easy to use when you're familiar with them. For what it's worth, I knocked up a few examples of using them a couple of years back for Booth (RIP), they can be found here https://github.com/fathert/json-rpg-example

Tim.




________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
Sent: 20 May 2021 06:39
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: RPG and XML or JSON

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