× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.