SQL Server成功调用Webapi

测试目标：

• 在SQL Server成功调用Webapi

---

测试内容：

1. GET请求
2. POST请求

---

测试过程：

1. GET请求

declare @ServiceUrl as varchar(1000)
set @ServiceUrl = 'http://localhost:8055/api/User/GetUserList' -- api接口
DECLARE @data varchar(max);
--set @data='{"orderNo":"GJF0220402286","businessMan":"11096周涛"}'   --入参
DECLARE @Object as Int
Declare @ResponseText AS  varchar(8000);     
Exec sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT;Exec sp_OAMethod @Object, 'open', NULL, 'GET',@ServiceUrl,'false'Exec sp_OAMethod @Object, 'setRequestHeader', NULL, 'Content-Type','application/json;charset=UTF-8'
Exec sp_OAMethod @Object, 'send', NULL, @data --发送数据
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
--EXEC sp_OAGetErrorInfo @Object --异常输出
Select  @ResponseText as  Response
Exec sp_OADestroy @Object
GO

2. POST请求

declare @ServiceUrl as varchar(1000)
set @ServiceUrl = 'http://localhost:8055/api/User/LoginUser' --restful api 接口
DECLARE @data varchar(max);
set @data='{"code":"demo","pwd":"demo"}'   --入参
DECLARE @Object as Int
Declare @ResponseText AS  varchar(8000);     
Exec sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'POST',@ServiceUrl,'false'
Exec sp_OAMethod @Object, 'setRequestHeader', NULL, 'Content-Type','application/json;charset=UTF-8'
Exec sp_OAMethod @Object, 'send', NULL, @data --发送数据
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
--EXEC sp_OAGetErrorInfo @Object --异常输出
 Select  @ResponseText as  Response
Exec sp_OADestroy @Object
GO

---

测试产出：

参考博客：https://blog.csdn.net/qq243348167/article/details/124243810