Re: Web service example to retrieve city/state by ZIP?

a simple statement like this should work

EXEC SQL
VALUES CAST( SYSTOOLS.HTTPGETCLOB('http://ziptasticapi.com/90210' ,'')
AS VARCHAR(128) )
INTO :HostVar.


Paul



From: mlazarus <mlazarus@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/08/2018 18:17
Subject: Re: Web service example to retrieve city/state by ZIP?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Paul,

That site looks very promising. Do you have the SQL syntax to make a
request from that web service and return the string into a variable?

-mark

On 8/3/2018 10:30 AM, Paul Roy wrote:

I kwow
http://ziptasticapi.com/

very simple :
http://ziptasticapi.com/90210 returns Json string...
{"country":"US","state":"CA","city":"BEVERLY HILLS"}

and I think you can do it US Postal service after registration.. but I
did not test it


Paul




From: mlazarus<mlazarus@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
Cc: "RPG programming on the IBM i \(AS/400 and iSeries\)"
<rpg400-l@xxxxxxxxxxxx>
Date: 03/08/2018 16:03
Subject: Web service example to retrieve city/state by ZIP?
Sent by: "MIDRANGE-L"<midrange-l-bounces@xxxxxxxxxxxx>



Does anyone have a web service example of retrieving a city/state by
passing the ZIP code (or country and ZIP code)? Preferably in RPG
and/or SQL. TIA.

-mark