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

[mlazarus <mlazarus@xxxxxxxxxxxx>]

Paul,

 We're not looking for that level of detail at all.  We just need a 
valid city/state to be returned when a ZIP code is provided.  I'm 
looking for the SQL syntax to make a request from a web service and 
return the string.  Thanks.

 -mark

On 8/3/2018 11:54 AM, Musselman, Paul wrote:
> Mark--
>
> We've used a paid service for decades to provide us with updated ZIP code data tied to sales tax.  There are so many local jurisdictions with the authority to add additional sales tax to the state sales tax (and almost any with the authority do) that there are monthly if not weekly updates!
>
> I believe the company is VeraZip.
>
> Paul E Musselman
> PaulMmn@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of mlazarus
> Sent: Friday, August 03, 2018 10:03 AM
> To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
> Cc: RPG programming on the IBM i (AS/400 and iSeries)<rpg400-l@xxxxxxxxxxxx>
> Subject: Web service example to retrieve city/state by ZIP?
>
>    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
>
>