Tag Archives: sql server 2025 rest end point

SQL Server 2025 API End Points Feature

by

To check your current SQL Server configuration for the parameter “external rest endpoint enabled”:

select * from sys.configurations where name like’external%’;

To enable it:

sp_configure ‘external rest endpoint enabled’, 1

RECONFIGURE WITH OVERRIDE

select * from sys.configurations where name like’external rest%’;

For the sake of illustration, I can now invoke a dummy api to get data in JSON format:

DECLARE @response NVARCHAR(max)

EXEC Sp_invoke_external_rest_endpoint

  @url = N’https://api.maldatabase.com/download -H “Authorization:9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08” –compressed -o feed_file.json’,

  @method = ‘GET’,

  @response = @response output

SELECT @response