Jump to content
Sign in to follow this  
  • entries
    128
  • comments
    4
  • views
    59118

Filemaker Twilio Integration

Sign in to follow this  
DB Services

83 views

Filemaker Twilio Integration

Twilio is used by many major corporations such as Lyft, Twitter, 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/2010-04-01/Accounts/{accountID}/Messages.json

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}
--data-urlencode "Body={body}"
--data-urlencode "From={fromNumber}"
--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.

DownloadDownload the FileMaker Twilio Integration Database

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

  • Name*
    First Last
  • Company
  • Phone*
  • Email*
  • FileMaker Experience*
    • New to FileMaker Platform
    • Existing User of FileMaker
    • Existing Developer of FileMaker
  • Terms of Use
    • I agree
    OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
  • Constant1

Afficher la totalité du billet

Sign in to follow this  


0 Comments


Recommended Comments

There are no comments to display.

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...