Sales Tax Integration in FileMaker
Finding the tax rate for an address can prove to be quite tricky. The sales tax can vary based on the jurisdiction of the location where some states have a statewide sales tax. Integrating FileMaker with a web service to automatically find the sales tax will take a lot of the guesswork out of running your business.
Sales Tax Through Geolocation
When searching for the web service you would like to use, you will want to make sure you find one that allows you to get the tax rate using an address or latitude and longitude. Most web services offer a look up based on a zip code, however, often times that will return an inaccurate sales tax because a specific zip code can have multiple jurisdictions within it. In our example, we are using the free service from the Avalara Tax Rates API in order to find the sales tax from a specific street address. This API will translate an address to geographic coordinates behind the scenes in order to provide the most accurate tax rate for that address. However, if your tax needs are more complex, Avalara does provide other services.
Integrate With FileMaker
In order to find the sales tax for an address in FileMaker, you will need to register with Avalara in order to receive your API key. The API key is what you will pass to Avalara in order for Avalara to recognize you as a user, so treat this key like a password. Once you have the key, you will need to build a URL query to request the sales tax from Avalara using the FileMaker script step Insert from URL. You will also want to make sure that the parameters within your URL are encoded using the FileMaker function GetAsURLEncoded(). Feel free to check out the Avalara Tax Rate API documentation to see how to build the URL.
Once the URL has been built, the request will return JSON-encoded text, which will include the total tax rate for that address and all of the jurisdictions that make up the total tax rate. FileMaker does not have a native way to decode JSON-encoded text, but you can simply text parse the response, as it is not overly complex. You may also use the BaseElements Plugin , which has a function just for JSON text parsing, JSONPath.
Download FileMaker Sales Tax Integration Database
Please complete the form below to download your FREE FileMaker database file.
Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.