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

[Paul Roy <paul.roy@xxxxxxx>]

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