How to create a webhook for Azure SQL Server?

Question

Hello,

We have a setup of extracting data from different APIs with code hosted on function app. Then we store that data in json blob storage and eventually map the data in data factory to SQL Server.

Right now we are looking into Hubspot's new webhooks where you can do Get and Post requests from the CRM. What we are interested in is the Get-request where we get data from our database and push it back to the CRM. For this, we need a webhook that can call data from our database. What would be a good solution to do this? I have found for instance Logic App, but that seems to be more to trigger a specific action based on a certain event. We would like to trigger the webhook from Hubspot but would need the webhook-url in order to do so.

Answer 1

Jonatan Thanks for posting your question in Microsoft Q&A. Based on my understanding, you are looking to create a webhook URL so that HubSpot can invoke and webhook can process the data. Correct? Please correct me if I misunderstood.

You can use Azure Functions Http Trigger which can act as a webhook service for HubSpot and there are a couple of examples such as SharePoint webhook as well as GitHub webhook (Full training sample). This will be a good starting point and use it as a reference/template and modify the code for your scenario.

Similarly, Azure Logic Apps can be used to create a webhook that is triggered by an HTTP request from HubSpot. For this scenario, use HTTP webhook built-in connector and here is the doc: Create and run automated event-based workflows by using HTTP webhooks in Azure Logic Apps for reference which includes step by step guide.

Once you have set up webhook, you can process data from SQL (or another database) and push it back to CRM.

I hope this helps and let me know if you have any questions.

---

If you found the answer to your question helpful, please take a moment to mark it as Yes for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.