Re: SQL RPG and Web API Consumption

Unless you are going to use SQL to parse the JSON as well Kelly there is really no point in using the QSYS2 HTTP functions. Use Scott's HTTPAPI directly. You will also find it easier in most cases to use DATA-INTO with YAJLINTO to parse the json payload. There are occasions when you will need to use the "raw"YAJL APIs but DATA-INTO deals with most situations really easily.


Jon P.

On Feb 9, 2022, at 9:51 AM, Kelly Cookson via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi,

I am an IBMi COBOL developer (which is the standard language for my shop). I am thinking about learning RPG for use with web/REST/HTTP APIs.

I would like to ask if something is even possible. I am hoping someone has already done this and can tell me it is possible. Or have someone tell me it will not work and not to waste my time trying.

Is it possible to have a SQL RPG program:
1. Use the new QSYS2 HTTP functions to consume a web API.
2. Use Scott Klement's YAJL library to parse the JSON returned by the web API.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486 ext. 12676
www.dotfoods.com<http://www.dotfoods.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