Hi AliYilmaz,

Refer below article.

Web API CRUD operations with Stored Procedure in ASP.Net MVC

Hi Dharmendr,

It was misunderstood. I need to do this with the stored procedure in sql management. I will do it with tsql.

Hi AliYilmaz,

Refer below query.

SQL

Declare @Object as Int;
Declare @ResponseText as Varchar(8000);

Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
                 'API_Url',
                 'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT

Select @ResponseText

Exec sp_OADestroy @Object

Reference:

https://stackoverflow.com/questions/22067593/calling-an-api-from-sql-server-stored-procedure/52686957

Hi Dharmendr,

I need to add content type json in the header.

I need to add username and password to this code. As a parameter to the body part.

Hi AliYilmaz,

Please try to follow below Link.

https://www.zealousweb.com/calling-rest-api-from-sql-server-stored-procedure/

https://www.sqlshack.com/how-to-parse-json-in-sql-server/