Re: [EXTERNAL] Re: SQL RPG and Web API Consumption

Hi Kelly,

I've written a small blog post about consuming a JSON web service with SQL only - neither RPG nor COBOL oriented.

https://qpgmr.de/ibmi-sql-json_table

Of course I have already used that technique embedded in an application program, to get current weather conditions - works really good and is completely language agnostic (apart from SQL of course).

I'm able to consult remotely part time, if you need more help or support on that topic.

HTH and kind regards,
Daniel

P.S.: I would be happy to get feedback on the blog post if it is helpful.

Am 09.02.2022 um 18:47 schrieb Kelly Cookson via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:

Thanks, Jon.

If we decide to use RPG only for web API clients, then we will probably use the methods Scott presented at POWERUp--which involve HTTPAPI and YAJL.

We are a COBOL shop. I'm not sure HTTPAPI and YAJL will work for COBOL. I was therefore asking about embedded SQL in RPG programs to consume a web API and parse the JSON returned. If this works, which it sounds like it should/does work, then we might be able to consume web APIs with embedded SQL in both RPG and COBOL programs. We would probably do it in SQL COBOL most of the time, but we would have a basic understanding for how to it in RPG when desired.

Thanks,

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