{"id":6041,"date":"2015-11-20T22:48:00","date_gmt":"2015-11-20T22:48:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/webdev\/2015\/11\/20\/using-asp-net-webhooks-with-ifttt-and-zapier-to-monitor-twitter-and-google-sheets\/"},"modified":"2023-09-19T11:46:31","modified_gmt":"2023-09-19T18:46:31","slug":"using-asp-net-webhooks-with-ifttt-and-zapier-to-monitor-twitter-and-google-sheets","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/dotnet\/using-asp-net-webhooks-with-ifttt-and-zapier-to-monitor-twitter-and-google-sheets\/","title":{"rendered":"Using ASP.NET WebHooks with IFTTT and Zapier to Monitor Twitter and Google Sheets"},"content":{"rendered":"

With the latest drop of ASP.NET WebHooks<\/a> we have added a generic JSON WebHook receiver, which can be used to receive WebHooks from services like IFTTT<\/a> and Zapier<\/a>. Both IFTTT<\/a> and Zapier<\/a> provide a huge number of integrations in areas such as productivity, automotive, blogging, CRM, commerce, project management, IoT, social, mobile, collaboration, and much more. For a full list, check out IFTTT channels<\/a> and browse Zapier zaps<\/a>.<\/p>\n

A really cool thing about both IFTTT and Zapier is that they enable regular HTTP requests to be output of an integration. That is, you can build integrations that when something happens, a Web request is sent to some specified destination. <\/p>\n

Here we\u2019ll show how to leverage this to build two simple integrations \u2013 one with IFTTT and one with Zapier \u2013 and then use ASP.NET WebHooks to receive the result. For IFTTT we wire it up to Twitter<\/a> monitoring when a tweet is sent, and for Zapier we wire it up to a Google Sheet<\/a> monitoring when a row is added. These are of course just examples \u2013 the possibilities for integrations are endless!<\/p>\n

Configuring Generic WebHook Handler<\/h3>\n

As usual, let\u2019s first create an empty Web Application with Web API in Visual Studio which we will use for receiving WebHooks from IFTTT and Zapier. Btw, if you just want to look at the code then you can also check out this sample<\/a>. Otherwise, continue by setting the project up for deployment in Azure by checking Host in the cloud<\/strong>:<\/p>\n

\"EmptyProject\"<\/a><\/p>\n

Install the Microsoft.AspNet.WebHooks.Receivers.Generic<\/a> Nuget package. The registration happens exactly like in the blog Introducing Microsoft ASP.NET WebHooks Preview<\/a> by adding<\/font> this line<\/font> to the WebApiConfig.Register<\/strong> method:<\/p>\n

\n

public<\/span> static<\/span> class<\/span> WebApiConfig
{
    public<\/span> static<\/span> void<\/span> Register(HttpConfiguration config)
    {
        \/\/ Web API routes<\/span>
        config.MapHttpAttributeRoutes();
        config.Routes.MapHttpRoute(
            name: "DefaultApi"<\/span>,
            routeTemplate: "api\/{controller}\/{id}"<\/span>,
            defaults: new<\/span> { id = RouteParameter.Optional }
        );
 
        \/\/ Initialize Generic JSON WebHook receiver<\/span>
        config.InitializeReceiveGenericJsonWebHooks();<\/font>
    }
}
<\/pre>\n
<\/p>\n
In this case we want the same receiver to handle both IFTTT and Zapier WebHooks which means that we need two WebHook URIs looking like this (one for IFTTT and one for Zapier):<\/p>\n
\n
https:\/\/<<\/span>host<\/span>><\/span>\/api\/webhooks\/incoming\/genericjson\/i<\/font>?code=1388a6b0d05eca2237f10e4a4641260b0a08f3a5<\/font>
https:\/\/<<\/span>host<\/span>><\/span>\/api\/webhooks\/incoming\/genericjson\/z<\/font>?code=80ad19e357b01a04fe767067df7cd31b96a844e1<\/font><\/pre>\n
<\/div>\n
We achieve this by defining the MS_WebHookReceiverSecret_GenericJson<\/strong> application setting as follows:<\/p>\n
\n
<<\/span>appSettings<\/span>><\/span>
  <<\/span>add<\/span> key<\/span>="MS_WebHookReceiverSecret_GenericJson"<\/span>
       value<\/span>="i=1388a6b0d05eca2237f10e4a4641260b0a08f3a5<\/font>,z=80ad19e357b01a04fe767067df7cd31b96a844e1<\/font>"<\/span> \/><\/span>
<\/<\/span>appSettings<\/span>><\/span><\/pre>\n<\/div>\n
As stated in the blog Introducing Microsoft ASP.NET WebHooks Preview<\/a>, the preferred way to do this is to set it in the Azure Portal<\/a>. The ‘code’ parameter must be between 32 and 128 characters long and as usual, you should pick values that have high entropy. A good idea is to pick something like a SHA256 hash which you for example can get from FreeFormatter Online Tools For Developers<\/a>. <\/div>\n
Finally, we add a GenericJsonWebHookHandler.cs file containing the following class for processing the incoming WebHooks for both IFTTT and Zapier. Note how we use the \u2018Id\u2019 property to differentiate between the two:<\/p>\n
\n
public<\/span> class<\/span> GenericJsonWebHookHandler : WebHookHandler
{
    public<\/span> GenericJsonWebHookHandler()
    {
        this<\/span>.Receiver = "genericjson"<\/span>;
    }
 
    public<\/span> override<\/span> Task ExecuteAsync(string<\/span> generator, WebHookHandlerContext context)
    {
        \/\/ Get JSON from WebHook<\/span>
        JObject data = context.GetDataOrDefault<JObject>();
 
        if<\/span> (context.Id == "i"<\/span>)
        {
            \/\/ Received a WebHook from IFTTT!<\/span>
        }
        else<\/span> if<\/span> (context.Id == "z"<\/span>)
        {
            \/\/ Received a WebHook from Zapier!<\/span>
        }
 
        return<\/span> Task.FromResult(true<\/span>);
    }
}<\/pre>\n<\/div>\n
Integrations using IFTTT\u2019s Maker Channel<\/h3>\n
Setting up a recipe with IFTTT<\/a> is fairly straight forward, but obviously you need an account with IFTTT. And just to avoid any confusion, to wire up to Twitter<\/a> you also need a twitter account. Start by going to My Recipes<\/strong>, then IF<\/strong>, then Create a Recipe<\/strong>, and then this<\/strong> to set up the trigger part:<\/p>\n
\"IFTTT-01\"<\/a><\/p>\n
Look for the Twitter channel:<\/p>\n
\"IFTTT-02\"<\/a><\/p>\n
and select New tweet for you<\/strong>:<\/p>\n
\"IFTTT-03\"<\/a><\/h3>\n
Wire it up to your twitter account and create the trigger:<\/p>\n
\"IFTTT-04\"<\/a><\/p>\n
Now select that<\/strong> for the action part:<\/p>\n
\"IFTTT-05\"<\/a><\/h3>\n
Search for the Maker<\/strong> channel:<\/p>\n
\"IFTTT-06\"<\/a><\/p>\n
and select the Make a web request<\/font> action:<\/p>\n
\"IFTTT-07\"<\/a><\/p>\n
Set URL<\/strong> to the first WebHook URI value from above, set the Method<\/strong> to \u2018POST\u2019 and Content Type<\/strong> to \u2018application\/json\u2019.<\/p>\n
\"IFTTT-08\"<\/a><\/p>\n
Also, set the Body<\/strong> to something like this while being careful generating valid JSON \u2013 otherwise the WebHook receiver will reject it:<\/p>\n
\n
{ "Text"<\/span>: "{{Text}}"<\/span>, "Link"<\/span>: "{{LinkToTweet}}"<\/span> }<\/pre>\n<\/div>\n
 <\/div>\n
Select Create Action<\/strong> and you should see something like this:<\/div>\n
 <\/div>\n
\"IFTTT-09\"<\/a><\/div>\n
Integrations using Zapier\u2019s WebHook Action<\/h3>\n
Setting up an integration with Zapier is equally simple, but of course you also need a Zapier account to get going and one for Google Drive to wire up to Google Sheets. Start by going to your dashboard and select Make a new Zap<\/strong>:<\/p>\n
\"Zapier-01\"<\/a><\/h3>\n
Then for trigger search for Google Sheets<\/strong> as the trigger app:<\/p>\n
\"Zapier-02a\"<\/a><\/h3>\n
Then pick New Spreadsheet Row<\/strong> as the trigger. Similarly, pick WebHooks by Zapier<\/strong> as the action app and then POST<\/strong> as the action:<\/p>\n
\"Zapier-03\"<\/a><\/p>\n
For this tutorial I created a Google Sheet with simple data like this:<\/p>\n
\"GoogleSheet\"<\/a><\/p>\n
Now add your Google Sheets account to the trigger part of the Zap in step 2:<\/p>\n
\"Zapier-04\"<\/a><\/p>\n
The WebHooks by Zapier<\/strong> action doesn\u2019t require any account setup in step 3 so just continue to step 4:<\/p>\n
\"Zapier-05\"<\/a><\/p>\n
Select the particular sheet you want to monitor and pick the particular worksheet:<\/p>\n
\"Zapier-06\"<\/a><\/p>\n
Finally, set the URL<\/strong> to the second WebHook URI value from above and set the Payload Type<\/strong> to \u2019json\u2019:<\/p>\n
\"Zapier-07\"<\/a><\/p>\n
In step 6 you can test out the zap but for now just go to step 7, enable the zap and get ready to try it out:<\/p>\n
\"Zapier-08a\"<\/a><\/p>\n
Trying it Out<\/h3>\n
Simply deploy your Web Application Project to Azure and try out the two integrations: To trigger the IFTTT integration, tweet from the account you registered, and for Zapier, add a row to the Google Sheet. For both IFTTT and Zapier there is a delay, at least in the free tier, for some minutes before changes cause a WebHook to fire. However, in both cases you can manually run the integration to cause it to fire.<\/p>\n
If you attach the debugger and add a row to the Google Sheet you and then run the zap manually, you should see this show up in the debugger like this:<\/p>\n
\"Zapier-09\"<\/a><\/p>\n
Similarly, after you tweet you should see the same breakpoint getting hit but this time for the IFTTT integration.<\/p>\n
That\u2019s it \u2013 you can now build integrations using IFTTT and Zapier and get the result straight into ASP.NET using ASP.NET WebHooks.<\/p>\n
Have fun!<\/p>\n
Henrik<\/p>\n","protected":false},"excerpt":{"rendered":"
With the latest drop of ASP.NET WebHooks we have added a generic JSON WebHook receiver, which can be used to receive WebHooks from services like IFTTT and Zapier. Both IFTTT and Zapier provide a huge number of integrations in areas such as productivity, automotive, blogging, CRM, commerce, project management, IoT, social, mobile, collaboration, and much […]<\/p>\n","protected":false},"author":403,"featured_media":58792,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[34,7505,7506],"class_list":["post-6041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aspnet","tag-asp-net-web-api","tag-asp-net-webhooks","tag-webhooks"],"acf":[],"blog_post_summary":"
With the latest drop of ASP.NET WebHooks we have added a generic JSON WebHook receiver, which can be used to receive WebHooks from services like IFTTT and Zapier. Both IFTTT and Zapier provide a huge number of integrations in areas such as productivity, automotive, blogging, CRM, commerce, project management, IoT, social, mobile, collaboration, and much […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/6041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/users\/403"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/comments?post=6041"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/posts\/6041\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media\/58792"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/media?parent=6041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/categories?post=6041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/dotnet\/wp-json\/wp\/v2\/tags?post=6041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}