The new function CDXZip4 is now part of CDXZipStream and provides address correction and USPS Zip+4 approved formatting using our CDXGeoData web service. Available in all versions of CDXZipStream with a CDXGeoData API key, you can now perform address verification and correction using U.S. Postal Service databases. Get address data in standard format and find ZIP+4 Codes even for addresses with missing data.
The CDXZip4 function can be used by right-clicking on any cell in your worksheet and selecting Insert CDXZip4 Function from the new CDXGeoData Functions drop down menu. Provide the input address information as either a single-line or multiple line address. Multiple-line input will look like this:
If parts of the address are unknown, such as state or postal code, they can be omitted from the input data. When specifying what data should be returned, you can request the “fullAddressOut” to return the entire address with all available information. You can also request that just portions of the address be returned, which is useful for identifying a missing ZIP code, for instance, or to accurately parse the address into different worksheet cell
Requests are checked against a USPS database to determine the correct format and if it is deliverable. Addresses not validated with return “Unknown or Invalid Address”. The results should closely match the individual results returned at the USPS site.
To gain access to this functionality you must have a CDXGeoData API Key which is not part of the CDXZipStream license. Tokens are used to access CDXGeoData with different levels for each service request. This Zip+4 address verification will require 5 tokens per request. Any number of users can access the CDXGeodata service with a single API key.
A free CDXGeodata API key to try out the service can be obtained on our website. Click the "Generate API Key" button to get your free key. The free key can be used for evaluation, development or non-profit use and is good for 24 hours. The key can be used to evaluate our CDXGeodata Excel Add-in and templates as well as the used in the Geodata portal. Users are allowed to generate one free key each day.
For higher usage levels and commercial use purchase blocks of additional token requests at this link. The purchased requests are available for up to one year and include an additional development API key with 1000 tokens per month. The development key will reset each month. No automatic rebilling.