SQL Server for Developers

SQTH02 Using REST APIs from within TSQL

11/16/2023

8:00am - 9:15am

Level: Intermediate

Josh Luedeman

Principal Engineering Manager

Microsoft

When sending data through a REST API, you need to pull together multiple tools to get it done. You'll of course need your database platform to store your data and a service to get the data from your database, send it to the REST API, and then receive and publish the response. Wouldn't it be great if you could do all that in one tool?? What if I told you, that you absolutely can?? A new feature in public preview for Azure SQL Database allows you to make REST API calls from within your database. In this session, attendees will get a walkthrough of how to make REST API calls from their database and some examples of how they can use this feature within their own environment.

You will learn:

  • How to configure and execute TSQL to call REST API endpoints
  • What is the right use case for this feature, versus the wrong use case.
  • Real world examples of how to use this feature in their environment when the attendee walks out of the session