From the course: REST APIs, Vectors, and AI in SQL Server 2025
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
What is a REST API? - SQL Server Tutorial
From the course: REST APIs, Vectors, and AI in SQL Server 2025
What is a REST API?
- [Instructor] After setting that baseline, let's start talking about our first features and see how we can use SQL Server to connect to external REST APIs. A REST API, or a representational state transfer API, is an endpoint that is typically accessed by an application. The application will bidirectionally communicate with the REST API. However, your REST API could also communicate with another REST API or multiples of those. REST APIs can be used for external data and external functionality by accessing them as micro or web services. Typically, your application will send a JSON request which is sent through HTTP or HTTPS. Each request is dateless, so all the information or the payload required for that request will be included in that request. The REST API will then typically send a JSON response, which can either contain data or just the status. In the SQL world, we will first have to enable the REST API feature…