Upgrade your Claris FileMaker solution with a Twilio integration to send out text messages directly from FileMaker! Implementing Twilio with your solution makes for a seamless experience for both your business and your customers. Twilio can be used to send out MMS (multimedia messaging service) messages for anything your business needs: order confirmation, shipping notifications, and more.

Account Setup

The first step in implementing Twilio in FileMaker is to create a Twilio account. Once your account is created, you will want to buy a number. This will be the phone number that sends out the text messages. Each number has an associated monthly fee. If you create a free trial account, you can use a Twilio phone number for free.

Phone Number Verification

Before you start sending out text messages, you will have to verify your new phone number. Twilio has government regulations they must follow regarding text message marketing, as their product is sending out text messages to real people. You will first need to submit a form to Twilio going into a little more detail about what your business does and how you will be using Twilio. Twilio will not let you send out messages from your phone number until it is verified. You can only send texts to the virtual phone on the Twilio website until then.

Authentication

The Twilio API used HTTP Basic authentication. You will need to plug in your Twilio account SID and auth token to this format:

https://{accountID}:{authToken}@api.twilio.com/2010-04-01/Accounts/{accountID}

Sending Messages

To clarify to the API that we want to send text messages, we must append /Messages.json to the end of the URL for the final result of:

https://{accountID}:{authToken}@api.twilio.com/2010-04-01/Accounts/{accountID}/Messages.json

Before we send out our text, we must build the cURL to pass into the Insert From URL script step that we will use to call the Twilio API.

"curl -X POST " & {url} &

" --data-urlencode \"Body=" & {body} & "\" " &

" --data-urlencode \"From=" & {from} & "\" " &

" --data-urlencode \"To=" & {toNumber} & "\" " & "--dump-header {responseHeader}"

You will need three components to build out this cURL: the number you're sending the text from, the number you're sending the text to, and the contents of the message. Save your results to a variable, and then when you call the Insert From URL script step, the text message will be sent. For further information on using the Twilio API, you can find their API documentation here https://www.twilio.com/docs

Conclusion

Twilio can add even more versatility to your Claris FileMaker Pro solution by strengthening communication with your customers. A direct line of communication will keep your customers well-informed. If you would like some help regarding a Twilio integration or anything else for your FileMaker solution, please contact us at DB Services and we would be happy to help.