Jump to content
  • entries
  • comments
  • views




Ziptastic Revisited

By: Doug West

**Requires FileMaker Pro 16

Lookup the city and state for any ZIP Code quickly and easily using JSON data from the Ziptastic web service API with FileMaker Pro 16.

Ziptastic is a simple web service for accessing geolocation data associated with postal codes. The API provided at getziptastic.com supports postal codes in 70 countries. By sending a US-based ZIP Code in a URL, we can quickly and easily get the associated city, county, and state. This service replaces the hassle of creating and updating an offline reference for postal codes.

We first provided the Ziptastic tip file for this web service roughly four years ago as a demonstration of the Insert From URL script step that was introduced in FileMaker Pro 12. Enhancements in FileMaker Pro 16 now allow us to simplify this process even more. Let’s take a look at the fundamental differences:

OLD Way (FileMaker Pro 12+)

  • Insert From URL script step returns JSON results to a global field
  • Separate script is called to parse field values out of the JSON data object

NEW Way (FileMaker Pro 16+)

  • Insert From URL script step returns JSON results to a global variable
  • JSONGetElement function is called to parse field values out of the JSON data object

Net Result
We have eliminated the script for the JSON parsing and the global field we were using to store the response from the Ziptastic API. Adding this feature to a solution now requires only one script and no additional fields. The script can be triggered when the user exists the ZIP Code field, and the city and state will be looked up so the user doesn’t have to enter them manually.

The Ziptastic service continues to be free for up to 100 requests per day, but now offers premium service levels for higher usage. The revenue generated by the subscriptions allows them to update the data monthly instead of only twice a year. Additional details for this web service can be found at getziptastic.com, but the concepts described in this tip are relevant to any web service using JSON as the data interchange format.

•• Download FREE FileMaker Pro demo file ••

screen shot of demo using FileMaker Pro and JSON with ziptastic web service

**This article is provided for free and as-is, use, enjoy, learn, and experiment at your own risk – but have fun! eXcelisys does not offer any free support or free assistance with any of the contents of this blog post. If you would like help or assistance, please consider retaining eXcelisys’ FileMaker Pro consulting & development services.

About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com)is an FBA Platinum Partner and FileMaker Certified developer organization. eXcelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of database solutions for Desktop, Mobile, and Web applications. Our core technology competencies are FileMaker Pro, FileMaker Go, and MySQL for database frameworks, along with FileMaker WebDirect, WordPress, MySQL, PHP, CodeIgniter, PostgreSQL, Joomla, Drupal, Magento, CSS, HTML5, and Javascript for web sites and web applications. Aside from providing eXcellent customer service, our goals are to use these technologies to intuitively automate your organization’s data solution needs seamlessly and flawlessly across the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about making your business more efficient through intuitive and effective software automation. 866-592-9235.

eXcelisys, Inc. is an independent entity and this web site/information/blog post has not been authorized, sponsored, or otherwise affiliated with FileMaker, Inc. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries.

The post [FMP Tip-n-Trick] Ziptastic Revisited Using FileMaker Pro 16 appeared first on eXcelisys.


View the full article




Recommended Comments

There are no comments to display.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.