{"id":2903,"date":"2022-06-14T05:51:08","date_gmt":"2022-06-14T10:51:08","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=2903"},"modified":"2022-06-14T05:51:10","modified_gmt":"2022-06-14T10:51:10","slug":"sms-chat-with-twilio-and-teamdesk-take-2","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/","title":{"rendered":"SMS chat with Twilio and TeamDesk,\u00a0take 2"},"content":{"rendered":"\n

While TeamDesk<\/a> does not support sending SMS messages directly, it is still possible via built-in third-party services integration features. In this article we\u2019ll show how to use Call URL actions and webhooks to build SMS chat via Twilio<\/a> services.<\/p>\n\n\n\n

A while ago we wrote an article<\/a> outlining SMS Chat using Twilio, but due to features missing in TeamDesk at the time of writing we needed to use polling<\/a><\/em> and some JavaScript code in Twilio to make it work. But now with webhooks we can do it in much more simpler way. <\/p>\n\n\n\n

First thing you\u2019ll need is to register an account with Twilio. Once registered, navigate to the console and note Account SID, Auth Token and phone number.<\/p>\n\n\n\n

\"Twilio<\/a><\/figure>\n\n\n\n

Create your copy of the sample database<\/a>, navigate to Setup | Database tab | Database | Variables<\/em> and fill in values of Account SID<\/em> and Phone Number<\/em> variables. Then, navigate to Setup | Database tab | Tools | 3rd-Party Accounts | Twilio<\/em> and put Account SID<\/em> into Username<\/em> and Auth Token<\/em> into Password<\/em> fields. <\/p>\n\n\n\n

In the core of the sample there is Messages<\/em> table which basically needs three fields. From<\/em> is the source phone number. We’ll use the variable as its default, but you can potentially have multiple numbers to send from. To<\/em> is the phone number to send the message to and Body<\/em> is the message text. <\/p>\n\n\n\n

Then there is Call URL action that calls Twilio API to send the message.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

The action is attached to a record change trigger that fires when record is added. Create new record, put recipient’s phone number and message text, save and voil\u00e0! The message is sent. But it’s not guaranteed whether and when it will be delivered \ud83d\ude42<\/p>\n\n\n\n

Checking SMS delivery status<\/h2>\n\n\n\n

The process of sending message is asynchronous. With API call above you instruct Twilio to queue <\/em>the message, but it takes some time for the message to be delivered. Or there might be an error due to, say, phone number is wrong. If you are interested in obtaining delivery status, a bit of extra work is required.<\/p>\n\n\n\n

First, we would need to setup the webhook.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Then we’ll need two more columns in our Messages table. One is Message-ID of text type. It will store unique message identifier reported by Twilio. Another column is Status, also of text type with the word \u201cpending\u201d as default value. Add two assignments to our Call URL action<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

and modify the body of the request to include StatusCallback<\/em> parameter – it’s already on a Call URL setup screenshot.<\/p>\n\n\n\n

Now the record in the message table has Message-ID<\/em>. The change in message status received in webhook also has the Message-ID<\/em>. Relate Message<\/em> and Message Status<\/em> tables by equality of Message-ID<\/em> columns, add a RecordSet column and a record change trigger to update Message<\/em> table’s Status<\/em> from the record received in webhook.<\/p>\n\n\n\n

Receiving SMS chat replies from Twilio<\/h2>\n\n\n\n

Twilio is capable to handle incoming SMS messages by calling some URL with the phone numbers and SMS content payload. So, we need another webhook in our database:<\/p>\n\n\n\n

\"Incoming<\/a><\/figure>\n\n\n\n

Setting up this one is a bit tricky. New webhook automatically creates new table to store incoming data. We want our data to go straight into Messages table. So, you would need to edit the webhook and select Messages table from the dropdown prior to creating the assignments.<\/p>\n\n\n\n

Once webhook is set up, copy its URL. Then visit Twilio console again, select your phone number and scroll down until you see Messaging<\/em> section. Then paste webhook URL into the text box in a A Message Comes In<\/em> sub-section. <\/p>\n\n\n\n

\"Incoming<\/a><\/figure>\n\n\n\n

Save. <\/p>\n\n\n\n

Now you’ll be able to receive messages sent to your Twilio phone number straight into your TeamDesk database.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this article we\u2019ll show how to use Call URL actions and a pair of webhooks to build SMS chat via Twilio services.<\/p>\n","protected":false},"author":4,"featured_media":2917,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[287,286,250],"class_list":["post-2903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-library","tag-sms","tag-twilio","tag-webhook"],"yoast_head":"\nSMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-14T10:51:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-14T10:51:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"SMS chat with Twilio and TeamDesk,\u00a0take 2\",\"datePublished\":\"2022-06-14T10:51:08+00:00\",\"dateModified\":\"2022-06-14T10:51:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/\"},\"wordCount\":620,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/image-2.png\",\"keywords\":[\"sms\",\"twilio\",\"webhook\"],\"articleSection\":[\"Application Library\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/\",\"name\":\"SMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/image-2.png\",\"datePublished\":\"2022-06-14T10:51:08+00:00\",\"dateModified\":\"2022-06-14T10:51:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"description\":\"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/image-2.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/image-2.png\",\"width\":800,\"height\":800,\"caption\":\"SMS chat with Twilio\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/application-library\\\/sms-chat-with-twilio-and-teamdesk-take-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SMS chat with Twilio and TeamDesk,\u00a0take 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog","description":"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/","og_locale":"en_US","og_type":"article","og_title":"SMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog","og_description":"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.","og_url":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/","og_site_name":"TeamDesk Blog","article_published_time":"2022-06-14T10:51:08+00:00","article_modified_time":"2022-06-14T10:51:10+00:00","og_image":[{"width":800,"height":800,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png","type":"image\/png"}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"SMS chat with Twilio and TeamDesk,\u00a0take 2","datePublished":"2022-06-14T10:51:08+00:00","dateModified":"2022-06-14T10:51:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/"},"wordCount":620,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png","keywords":["sms","twilio","webhook"],"articleSection":["Application Library"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/","url":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/","name":"SMS chat with Twilio and TeamDesk,\u00a0take 2 - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png","datePublished":"2022-06-14T10:51:08+00:00","dateModified":"2022-06-14T10:51:10+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"description":"In this article we will show how to use Call URL actions and webhooks to build SMS chat via\u00a0Twilio\u00a0services.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/06\/image-2.png","width":800,"height":800,"caption":"SMS chat with Twilio"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/application-library\/sms-chat-with-twilio-and-teamdesk-take-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"SMS chat with Twilio and TeamDesk,\u00a0take 2"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=2903"}],"version-history":[{"count":9,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2903\/revisions"}],"predecessor-version":[{"id":2923,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2903\/revisions\/2923"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/2917"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=2903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=2903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=2903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}