RE: REST-JSON-YAJL

["Tony Cesarios" <tony@xxxxxxxxxxxxxxxxxxx>]

Hi Ross,

Thanks I will look at this.

Regards,
Tony



-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx
[mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Rainer Ross
Sent: Tuesday, April 26, 2016 8:32 AM
To: HTTPAPI and FTPAPI Projects <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: REST-JSON-YAJL


Hi Tony,

I have a example parsing JSON-data from OpenExchangeRates.org

For test:

1) You need HTTPAPI and YAJL from Scott Klement

2) Take the HTTPAPI Command to Download the file from
http://openexchangerates.org/api/latest.json?app_id=yourid
      or take the JSON file at the appendix

3) Look at the GETCURRAT program to parse the JSON data

4) It is possible too to access a REST webservice with SQL since V7R1. 
This example is a access to Google Maps Webservice

SELECT SYSTOOLS.HTTPGETCLOB
('https://maps.googleapis.com/maps/api/geocode/json?address=Renntalstra%C3%9
Fe%2020,74360%20Ilsfeld&components=country:DE','')
  From SYSIBM.SYSDUMMY1;


Best regards

Rainer

Rainer Ross
IT-Consulting
www.myhofi.com - a smarter way to book hotels - powered by IBM i Kaufering
Germany





Am 25.04.2016 um 21:48 schrieb Tony Cesarios:
>      [cid:image001.gif@01D19F7F.48A941D0]
>
>     Hi,
>
>
>     Just wondering if anyone has a sample program using HTTPAPI to execute
>     a GET from an external URL using REST and JSON.
>
>
>     Had a look at YAJL as a solution.
>
>
>     We need to go and retrieve orders which contain about 15 elements
>     (parameters) and process them into our iSeries.
>
>
>
>     Regards,
>
>     Tony Cesarios
>
>
>
> ----------------------------------------------------------------------
> - This is the FTPAPI mailing list.  To unsubscribe, please go to:
> http://www.scottklement.com/mailman/listinfo/ftpapi
> ----------------------------------------------------------------------
> -




-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------