Learn how to use the new sp_invoke_external_rest_endpoint feature in SQL Server 2025 to call any external REST API — directly from T-SQL!
In this video:
We perform a real GET request to a public API
Extract and parse JSON arrays using OPENJSON
Handle nested/double-encoded JSON safely
All done without any external tools, code, or middleware!
#backenddeveloper If you’re a DBA or backend dev, this opens a whole new world of API-driven SQL workflows 🚀
EXEC sp_configure 'external rest endpoint enabled', 1;
RECONFIGURE WITH OVERRIDE;
Full code : https://dotnetfiddle.net/QxyoyJ
#SQLServer2025 #TSQL #RESTAPI #OpenJSON #SQLTips #sp_invoke_external_rest_endpoint #JSONinSQL #MicrosoftSQL #APIsInSQL #BackendDev
Download
0 formats
No download links available.
🔥 SQL Server 2025: Call Any REST API & Parse JSON Arrays with T-SQL | NatokHD