Re: REST Web Service

I consumed a rest API using systools.httpgetclob and post. I ended up putting the sql in a udf function. It makes it portable and the rpg programs that reference just make a simple select to reference it. The code in the UDF is easy to read.The systools versions Run reliably daily. Next time I will try qsys versions.
On Friday, February 16, 2024, 07:44:52 AM CST, Tim Rowe <timmr@xxxxxxxxxx> wrote:

The Integrated SQL options work very well.  Just don’t use the systools versions.. they are using Java as the engine to exchange the Rest interaction, they work very well, except for every other Thursday or so .  You want the QSYS2 support.  They are ILE based, so very fast and work quite well. The details - https://www.ibm.com/support/pages/node/6486889

A few examples for your reference…

https://gist.github.com/forstie/49bff70e5bc82864d04eaa2471960f31
https://learn.common.org/products/isee-rest-apis-from-dad-jokes-to-sending-text-messages-to-your-phone?packages%5B%5D=46368&in_package=46368&sort_by=package_order&ref=package&ref_id=46368


Thanks Tim

[Logo  Description automatically generated]Tim Rowe    - timmr@xxxxxxxxxx<mailto:timmr@xxxxxxxxxx>
STSM – Application Development & Systems Management
IBM i ISV Council
IBM i Development Lab, Rochester MN
507-250-1293

ACS - http://ibm.biz/IBMi_ACS
Navigator - http://ibm.biz/IBMi_Nav4i


message: 6
date: Fri, 16 Feb 2024 11:01:03 +0200
from: Gad Miron <gadmiron@xxxxxxxxx>
subject: REST Web Service

Hello sages

I need to consume some (in house) Rest Web Services ,
POST & GET (if these are the correct terms for upload and download data)
Which way is the simplest?
Scott's LIBHTTP (we now use it for SOAP WSs) ?
Scott's YAJL (I just know that there is such a thing) ?
SQL's new (and not so new) functions ?

Some pointers would surely help a lot.

TIA
Gad

*****************************************