83.2 F
Tampa
Friday, June 9, 2023
spot_img
spot_img
Array

FileMaker Twilio Integration | DB Services

Date:



By
Kevin Boehle 

Posted on 
December 12th, 2019 

in 
FileMaker,

Free Downloads

Twilio is used by many major corporations such as LyftTwitter, and AirBnB to send texts to communicate information to their customers. Integrating Twilio with FileMaker can give you the ability to easily send appointment reminders, sales discounts, and much more straight to your clients’ phones with just a few lines of code.

Account Set-Up

To integrate with Twilio, you’ll need to first sign up for an account. Twilio offers a free trial which gives you a $15 budget to play with. You are only charged 1.5 cents per text sent and can upgrade to a full account when your original $15 credit runs out.

Once your account is set up, you will need to buy a phone number to send the texts from. You can do that by navigating to the Phone Numbers section and selecting “Buy A Number”.

Filemaker twilio buy a number screen
Once you’ve found a number you like, you can typically purchase it for one or two dollars per month.

The information you’ll need to successfully authenticate your account appears on the Twilio Console Dashboard. You’ll just need to know your Account ID and the Auth Token.Filemaker twilio console dashboard

Authentication

Twilio uses HTTP Basic authentication to authenticate your account. All you need to do to ensure your account is usable is insert the Account ID and Auth Token in place of the {accountID} and {authToken} in the following url. In FileMaker, use an “Insert from URL” script step to make the call and save the result in a variable .

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

The call will return some XML that includes the attribute tag <Status> which will either display “404” if the account is not found, “401” if the account is found but the Auth Token is incorrect, or “active” if the account is able to be authenticated.

Sending a Text

To send a text in FileMaker, you need to use an “Insert from URL” script step to make the following call

https://{accountID}:{authToken}@api.twilio.com/201...

as well as the appropriate cURL options. To set up the cURL options, you need the number you’re sending your text from, the number you’re sending the text to, and the body of the text.

With these three components, you should store the cURL information in a variable by replacing each part of the following cURL options with your relevant information. Use this variable as the “cURL Options” of your “Insert from URL” step.

curl -X POST {url}<br>
--data-urlencode "Body={body}"<br>
--data-urlencode "From={fromNumber}"<br>
--data-urlencode \"To={toNumber}"

When the “Insert from URL” step is called, the text will immediately be sent to the recipient.

Conclusion

With Twilio, you can easily send texts to customers stored in your FileMaker database. With these texts, you can keep your customers informed, up-to-date, and in constant communication with your organization. Contact us if you would like help integrating Twilio and FileMaker.

Did you know we are an authorized reseller for FileMaker Licensing?
Contact us to discuss upgrading your FileMaker software.

Download

Download the FileMaker Twilio Integration File

Please complete the form below to download your FREE FileMaker file.

Kevin boehle thumbnail
Kevin Boehle

Kevin is a Certified FileMaker and Salesforce developer who is both creative and friendly in his approach to solving client issues. He is motivated by a good challenge and works diligently to produce excellent results in a timely fashion.



Source link

Share post:

crm erp
crm erp

Popular

More like this
Related

Make Apple Watch Apps Easier to Find with List View

With the original version of the Apple Watch, Apple...

DevOps Essentials: Adopting Source Control

In this second episode of the DevOps Essentials, we...

Discussing FileMaker Hosting & Soliant.cloud with Thought Leaders

https://www.youtube.com/watch?v=IEVz-UA-RuA Bill Heizer and Adam Russ with Soliant Consulting sit...

FileMaker Data Exports with RESTful APIs & JSON Data Contracts

In today’s rapidly evolving digital landscape, businesses rely heavily...