TMS Softare, LLC, d/b/a Taylor Made Services

This is the Home page for the Zippopotam.us API Solution.

Visit our Business home page at www.tms.us

Download the latest version from TMS Templates.

TMS Software, LLC, developed this app for the Claris Community. It is a FileMaker solution that utilizies the Zippopotam.us API to find the City and State when you provide a Postal Code.

This FileMaker template has a script that makes a URL call with the Insert from URL script step to talk to the Zippopotam.us API with a Postal Code and Returns the City and State or Province. As of the original development of this template, the API supports about 70 countries, but we have only tesed it on USA and Canada. The API returns a variable that is stored in fields identified in the Script Parameter. The template is completely open and you can customize this to your needs.

One common use has been for people typing in Addreses to have the Postal Code before the City and State fields and after exiting the Postal Code field, this automatically fills in the City and State so that the user does not have to type them. The benefit is it makes for faster input of addresses and better accuracy. It could also be used to flag address records where the City and State do not match the result so as to update addresses that already exist but may be inaccurate.

There is no cost to use this API or FileMaker template. This is an extension meaning it is not designed to be a final solution. This is for you to use to copy, edit and incorporate the script into your own solution. We hope this solution can assist you in your business process needs!

The solution is provided as-is with no warranty of functionality and was prepared as freeware released to the FileMaker community. TMS Software, LLC retains the rights to the code, but asks that if you make use of it, you give us appropriate credit. And if you need assistance in implementing this solution, our consulting services are available and you can contact us at www.tms.us or 877-709-7072.


This software template was developed by Taylor Sharpe, FMCD, the President and owner of TMS Software, LLC, a FileMaker Business Alliance member and certified developer. He is also the Co-Chapter Coordinator of the FileMaker Pro Users Group of Dallas. You can contact Mr. Sharpe at Taylor@tms.us The API is from Zippopotam.us Project 2013 and licensed under their Open Database License.