JSON functions in embedded SQL are very easy to use, once you have the syntax figured out. I used some examples from Birgitta, and was able to both read and write JSON documents. To give you an example, we pull a JSON document from an HTTP server, select a few fields from it, join it to one of our files, and then write the data out to a file. Its very powerful.
Here is us creating and sending a JSON document in one statement:
exec sql set :Response=systools.HTTPPOSTCLOB(
:url,:hdr,
json_object(key 'fulfillment' value
json_object(
key 'location_id' value :LOCID,
key 'tracking_number' value :Track,
key 'tracking_urls'
value json_array(:TrackURL)
)
)
);
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Birgitta Hauser
Sent: Thursday, May 20, 2021 1:39 AM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: RPG and XML or JSON
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
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
midrange.com
