<xml> <out_trade_no>20211106103205807262</out_trade_no> <out_refund_no>20211106143004931785</out_refund_no> <total_fee>1</total_fee> <refund_fee>1</refund_fee> <appid><![CDATA[wx806e0b0fdfbf1146]]></appid> <mch_id>1535411321</mch_id> <nonce_str><![CDATA[ae4afd50c1f4a669bcce91065ab74a00]]></nonce_str> <op_user_id>1535411321</op_user_id> <sign><![CDATA[9158A7E44600A22F3D22C013E98C05DC]]></sign> </xml>

通过以下过程可以实现发送文本信息，请问下，怎么上传临时文件？怎么得到media_id ？ 官方给的demo 又看不懂！！！请各位大佬帮忙看看。谢谢！ --select  @data='{"msgtype": "text","text": {"content":"'+@TEXT+'"}}' Exec sp_OACreate 'Msxml2.ServerXMLHTTP.3.0', @Object OUT; Exec sp_OAMethod @Object, 'open', NULL, 'POST',@ServiceUrl,'false' Exec sp_OAMethod @Object, 'setRequestHeader', NULL, 'Content-Type','application/x-www-form-urlencoded' Exec sp_OAMethod @Object, 'send', NULL, @data Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT Exec sp_OADestroy @Object --SELECT @ResponseText as ResponseText,@Object,@ID