Calling external REST endpoints from Azure SQL Database | Azure Friday

Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL DB to call any HTTP REST API securely: call an Azure Function, send a message to Event Hub, execute a DAX query in Power BI, enrich data with Cognitive Services, etc.
Chapters:
00:00 - Introduction
02:15 - Background discussion
06:21 - Demo 1: Calling an Azure Function
10:02 - Demo 2: Query a GraphQL service
12:05 - Demo 3: Update a page in real time with SignalR
15:05 - Demo 4: Power BI executeQueries
17:20 - Demo 5: Event Hub
19:05 - Wrap-up
19:41 - Bonus demo: Cognitive Services
Recommended resources:
■ sp_invoke_external_rest_endpoint (Transact-SQL) (Preview) - aka.ms/azfr/739/01
■ Azure-Samples/azure-sql-db-invoke-external-rest-endpoints - aka.ms/azfr/739/02
■ Azure SQL Database - aka.ms/azfr/739/03
■ Create a Pay-as-You-Go account (Azure) - aka.ms/azfr/739/payg
■ Create a free account (Azure) - aka.ms/azfr/739/free
Connect with us:
■ Scott Hanselman | @SHanselman - / shanselman
■ Davide Mauri | @MauriDB - / mauridb
■ Azure Friday | @AzureFriday - / azurefriday
■ Azure | @Azure - / azure
#Microsoft #Azure #AzureFriday

[@rgsiiiya]

This is MASSIVE!!!
we've written crazy workarounds in the past to 'advertise' key business events out of the SQL DB into to modern eventing systems like Event Hub. This new feature will save HOURS and HOURS and throw away very costly custom solutions.

[@MicrosoftAzure]

We're so happy to hear that you're excited about the new feature!

[@vitoiacono5426]

Davide this feature is amazing and I am looking forward to use it. Thank you for what you and your team are doing to help us developers to deal with big challenge using Azure Sql.

[@synthmania7275]

This has its place and needs to be used based on your use cases. Great job! Davide!

[@jeevanwijerathna]

This is amazing. I remember few years back I used SQL CLR to call a web service from SQL server. ❤❤

[@lecadou]

This is a very useful and dangerous feature. I am glad it is behind APIM so you apply policies on queries

[@Tony-dp1rl]

Welcome to the most expensive web service client in history ...and yet, that's pretty cool.

[@lecadou]

Ah ah but also the most useful

[@LelandVelasco]

True its expensive if its wasnt optimized..

[@anwarbalim6516]

This is super useful. Please cover how to add external sites. Do you just use API Gateway? Please also this will come to managed instances

[@martijnvanschie]

Great demo Davide and such a welcome feature. I'm already thinking of solutions that might benefit from this. I was wondering if this can also be used from a trigger? (of course keeping in mind the number of triggers and performance).

[@DavideMauri]

Yes, of course. If you do so, I recommend using an async service like Event Hub or Azure Durable Functions to make sure the REST call is the fastest possible

[@martijnvanschie]

Yes, I was thinking about that... thanx. I will be playing around with this in the coming month 😃

[@nemanjadjordjevic5783]

Can someone provide a case where this kind of functionality would be useful?

[@wli7605]

I experienced a limit that only 500 rows can be returned when querying a published Power BI dataset. Can you advise if this is this expected or I should see more?

[@narendra.singh.t]

Any option available to ignore ssl error during Api call ?

[@DavideMauri]

Only HTTPS is supported (for security reason) and the certificate must be valid (and also only TLS1.2+ is supported)

[@narendra.singh.t]

@@DavideMauri thank

[@DoubleUJay]

Is this feature coming to on premise SQL server?🌚

[@DavideMauri]

Yep. Cannot give an ETA at the moment, but we know it is important to have it also on-prem and on Azure SQL MI

[@DoubleUJay]

@@DavideMauri You made my day🙏

[@thakurdherensingh36]

@@DavideMauri This is a great demo, I have seen your other Microsoft AZ Series too. Thanks for great work. My question still is about On-Prem SQL Server, this thread is an year old but Microsoft official information hasnt posted anything about this being available for On Premise. Any Updates for us?

[@cyndijohnson5473]

Not a fan of this at all. People in SQL routinely try to do OO programming , and now you’re doing this?

[@TheJuniorAccountant]

This will save so much effort fixing bad data from NOSQL “engineers” who have to deal with a RMBDS for the first time in their life