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 account comes with 1000 tokens that can be used for evaluation, development and non-profit use. If you use up your tokens, your account will be refreshed with up to 1000 additional requests on the monthly anniversary of your account start date. Additional tokens can be purchased on an as needed basis with the following pricing. The tokens are good for up to one year. It’s easy and risk free to get started with our free account.