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

[mlazarus <mlazarus@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
>