{"id":110720,"date":"2016-05-11T10:26:27","date_gmt":"2016-05-11T17:26:27","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/connecting-flow-sql-twilio\/"},"modified":"2025-06-11T08:18:36","modified_gmt":"2025-06-11T15:18:36","slug":"connecting-flow-sql-twilio","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/connecting-flow-sql-twilio\/","title":{"rendered":"Connecting up Microsoft Flow, SQL and Twilio"},"content":{"rendered":"<p>Last week, at a customer location, we\u00a0attempted to solve an advanced user scenario of triggering a Flow without a built-in trigger. More than the final solution itself, I was particularly interested in <strong>how\u00a0<\/strong>the customer used the available triggers and actions\u00a0within Microsoft Flow to arrive at the solution.<\/p>\n<h2>The Scenario<\/h2>\n<p>It all boils down to this simple problem statement- When a record gets inserted into a SQL table, notify someone with a text message. It sounds like a simple Flow, but it&#8217;s a powerful capability for end-users. The crux of the problem is all about converting potent insights into immediate actions that will result in huge cost savings for the customer. There is this huge backend SQL system with lots of interesting real-time data that gets tucked away into oblivion, albeit after passing through the right analysis algorithms, but when the system provides the right signal, the relevant people are not notified, so they are unable to take the corrective action at the appropriate time.<\/p>\n<h2>The Problem<\/h2>\n<p>Flow does not yet support a \u2018on new record\u2019 trigger on SQL connections. If we wanted a text message on a SharePoint list, it would have taken less than a minute to set up this flow. However, for SQL we have to hand-craft this \u2018on new record\u2019 trigger.<\/p>\n<h2>The Solution<\/h2>\n<p>Microsoft Flow supports executing Stored Procedures on SQL backend. It turns out that the customer was\u00a0a SQL guru, who was able to spin up a stored procedure within minutes. The SPROC did the heavy lifting on the SQL side and dropped\u00a0a single record on a special SQL table. Here is how the problem was solved.<\/p>\n<ol>\n<li>Trigger: Add a recurrence event to act as a trigger, for e.g. every day at 9a.m.<\/li>\n<li>Execute stored proc action: To push to the stack i.e. the special SQL table<\/li>\n<li>Get row from SQL action: To pop from the stack<\/li>\n<li>Send message action: Use the Twilio service to send the text message<\/li>\n<li>Update row action: To clear the stack<\/li>\n<\/ol>\n<p>This is how the Flow looks like after it is setup:<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\" style=\"width: 331px; height: 283px;\"\/><\/p>\n<h2>The Easy Part \u2013 Send a text message<\/h2>\n<p>It took us about two minutes on Twilio.com to sign up for a Twilio account, verify the phone number, set up a new incoming phone number and to pick up the API key\/ secret. Setup a Twilio account, then setup an incoming phone number from <a href=\"https:\/\/www.twilio.com\/console\/phone-numbers\/incoming\"><u>https:\/\/www.twilio.com\/console\/phone-numbers\/incoming<\/u><\/a>, then go to the console &#8211; <a href=\"https:\/\/www.twilio.com\/console\/\"><u>https:\/\/www.twilio.com\/console\/<\/u><\/a> to get the account SID and auth token.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-2.jpg\"\/><\/p>\n<h2>Other Solutions that could work<\/h2>\n<h3>Custom API<\/h3>\n<p>The first thought that occurred to us was to use the built-in recurrence trigger along with a custom API. Flow supports this concept of exposing a custom APIs as yet another action\/trigger along with the other services that are supported. Check out the detailed steps for adding a customer API <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/register-custom-api\/\"><u>here<\/u><\/a>. The proposed API will fetch the unprocessed records in the database and drop them into a specific SQL table. This is how the flow will unfold:<\/p>\n<ol>\n<li>\n<p>Recurrence trigger &#8211; Every n seconds<\/p>\n<\/li>\n<li>\n<p>Custom API action &#8211; Call the custom API to perform this special operation<\/p>\n<\/li>\n<li>\n<p>SQL Action \u2013 Get Record<\/p>\n<\/li>\n<li>\n<p>SMS Action \u2013 Send message to the phone number<\/p>\n<\/li>\n<\/ol>\n<p>While this would be feasible to build couple of days, the custom API still would need to be written\/stood-up and consumed via Flows.<\/p>\n<h3>Web Hooks<\/h3>\n<p>The other thought that occurred to us was to create an API that would act as the trigger. When the SQL trigger event occurs, the API will ping Microsoft Flow via a Web Hook. This works great for efficiency because there is no polling involved, Web Hooks are supported in Microsoft Flow and listens of a specific port for the custom event to occur. This sounded great except that, this still needs extra work to understand how to hook into the web hooks infrastructure.<\/p>\n<h2>Finally<\/h2>\n<p>It was rewarding to walk away with an actual solution to the problem, however complicated. I would like to hear more from you about your scenarios and experiences with Microsoft Flow. I am the extensibility program manager in the Microsoft Flow team. If you like to explore integration opportunities with Microsoft Flow, ranging from providing a simple #HREF link to flow.microsoft.com from your application to being able to use the full CRUD\/manage operations on Flows via REST APIs from within your application reach me by emailing flowdev@service.microsoft.com<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post, you can learn how to work with triggers when there is no built-in triggers available for a service, and how to set up a connection to Twilio. This blog post is intended for advanced developer audience.<\/p>\n","protected":false},"author":370,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3423],"job-role":[],"product":[3474],"property":[],"topic":[3435],"coauthors":[2912],"class_list":["post-110720","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate","topic-operations"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog<\/title>\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.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"In this post, you can learn how to work with triggers when there is no built-in triggers available for a service, and how to set up a connection to Twilio. This blog post is intended for advanced developer audience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/connecting-flow-sql-twilio\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-11T17:26:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:18:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\" \/>\n<meta name=\"author\" content=\"Barath Balasubramanian\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Barath Balasubramanian\" \/>\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.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/barath-balasubramanian\/\",\"@type\":\"Person\",\"@name\":\"Barath Balasubramanian\"}],\"headline\":\"Connecting up Microsoft Flow, SQL and Twilio\",\"datePublished\":\"2016-05-11T17:26:27+00:00\",\"dateModified\":\"2025-06-11T15:18:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\"},\"wordCount\":756,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\",\"keywords\":[\"Developers\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\",\"name\":\"Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\",\"datePublished\":\"2016-05-11T17:26:27+00:00\",\"dateModified\":\"2025-06-11T15:18:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage\",\"url\":\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\",\"contentUrl\":\"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting up Microsoft Flow, SQL and Twilio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/cdc3fbd82bda506702d77c2760f9b6c7\",\"name\":\"Barath Balasubramanian\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=gc137c3e56cabe72a725d7e232a648b79\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=g\",\"caption\":\"Barath Balasubramanian\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/barathb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog","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.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/","og_locale":"en_US","og_type":"article","og_title":"Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog","og_description":"In this post, you can learn how to work with triggers when there is no built-in triggers available for a service, and how to set up a connection to Twilio. This blog post is intended for advanced developer audience.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/connecting-flow-sql-twilio\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2016-05-11T17:26:27+00:00","article_modified_time":"2025-06-11T15:18:36+00:00","og_image":[{"url":"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg","type":"","width":"","height":""}],"author":"Barath Balasubramanian","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Barath Balasubramanian","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/barath-balasubramanian\/","@type":"Person","@name":"Barath Balasubramanian"}],"headline":"Connecting up Microsoft Flow, SQL and Twilio","datePublished":"2016-05-11T17:26:27+00:00","dateModified":"2025-06-11T15:18:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/"},"wordCount":756,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage"},"thumbnailUrl":"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg","keywords":["Developers"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/","name":"Connecting up Microsoft Flow, SQL and Twilio - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage"},"thumbnailUrl":"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg","datePublished":"2016-05-11T17:26:27+00:00","dateModified":"2025-06-11T15:18:36+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#primaryimage","url":"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg","contentUrl":"https:\/\/flowblogassets.blob.core.windows.net\/sqltotext\/image-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/05\/11\/connecting-flow-sql-twilio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting up Microsoft Flow, SQL and Twilio"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/cdc3fbd82bda506702d77c2760f9b6c7","name":"Barath Balasubramanian","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=gc137c3e56cabe72a725d7e232a648b79","url":"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1047397b1385f329b3ab21c2732da84c75add45db8be1be678dd350488103b9d?s=96&d=mm&r=g","caption":"Barath Balasubramanian"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/barathb\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/370"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110720"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110720\/revisions"}],"predecessor-version":[{"id":128880,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110720\/revisions\/128880"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110720"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110720"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110720"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110720"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110720"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110720"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110720"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}