CREATE PROCEDURE CLR_CallWebAPIEx
@ReceiveData NVARCHAR(MAX) OUTPUT,
@LocalWCFUrl NVARCHAR(4000),
@IsPost BIT,
@WebAPIUrl NVARCHAR(500),
@UserName NVARCHAR(100),
@UserPassword NVARCHAR(100),
@TimeOutS INT,
@ContentType NVARCHAR(MAX),
@Headers NVARCHAR(MAX),
@PostFormParams NVARCHAR(MAX),
@PostRawParams NVARCHAR(MAX),
@GetParams NVARCHAR(MAX)
AS
BEGIN
SET @LocalWCFUrl='' ---应用端接口链接
SET @WebAPIUrl='' ---钉钉API接口链接
--SET @MessageKeyWord = 'Hello,'
--@Message NVARCHAR(500), --需要发送的消息
-- @Receivers NVARCHAR(500) --接收人,格式:"136*****239","152***8108"...
SET @IsPost = '' --端口值
--SET @UserName = ''
--SET @UserPassword = ''
SET @TimeOutS='' --执行
SET @UserName = N'5929673f-1db6-440c-a188-d5****' ---授权用户名
SET @UserPassword = N'W2kdw1JIjxhkEVwVJSiYE4kFBH*****' --授权密钥
--SET @ContentType = N''
SET @ContentType = 'application/json;charset-utf-8' --数据类型
SET @Headers = ''
--SET @Headers = N''
SET @PostFormParams= ''
SET @PostRawParams = '
{
"msgtype": "text",
"text": {
"content": "'+@MessageKeyWord+' '+@Message+'"
},
"at":{
"atMobiles":['+@Receivers+'],
"isAtAll":false
}
}'
SET @GetParams = ''
IF ISNULL(@LocalWCFUrl,'')<>'' AND ISNULL(@WebAPIUrl,'')<>''
BEGIN
SET @ReceiveData=-1
END
END