declare @headers nvarchar(max), @url nvarchar(max), @payload nvarchar(max), @response nvarchar(max);set @headers= json_object('Accept':'application/xml','Content-Type':'application/json','BrokerProperties':'{"Label": "TestMessage", "SessionId": "Session1"}');set @payload= json_object('MessageId':1);select @headers, @payload;set @url='https://{ServiceBusName}.servicebus.windows.net/{ServiceBusTopicName}/messages'exec sp_invoke_external_rest_endpoint    @url= @url,    @method='POST',    @headers= @headers,    @payload= @payload,    @credential= [https://{ServiceBusName}.servicebus.windows.net],    @response= @response outputselect cast(@responseas xml)go

<output>  <response>    <status>      <httpcode="400"description="Bad Request" />    </status>    <headers>      <headerkey="Date"value="Thu, 05 Oct 2023 13:32:20 GMT" />      <headerkey="Transfer-Encoding"value="chunked" />      <headerkey="Content-Type"value="application/xml; charset=utf-8" />      <headerkey="Server"value="Microsoft-HTTPAPI/2.0" />      <headerkey="Strict-Transport-Security"value="max-age=31536000" />    </headers>  </response>  <result>    <Error>      <Code>400</Code>      <Detail>The value '{\"Label\": \"TestMessage\", \"SessionId\": \"Session1\"}' of the HTTP header 'BrokerProperties' is invalid. TrackingId:1030e3ab-5a69-4414-b28e-73af5a76888d_G58, SystemTracker:***, Timestamp:2023-10-05T13:32:19</Detail>    </Error>  </result></output>

<output>  <response>    <status>      <httpcode="201"description="Created" />    </status>    <headers>      <headerkey="Date"value="Thu, 05 Oct 2023 13:39:17 GMT" />      <headerkey="Transfer-Encoding"value="chunked" />      <headerkey="Content-Type"value="application/xml; charset=utf-8" />      <headerkey="Server"value="Microsoft-HTTPAPI/2.0" />      <headerkey="Strict-Transport-Security"value="max-age=31536000" />    </headers>  </response></output>

{"Accept":"application\/xml","Content-Type":"application\/json","BrokerProperties":"{\"Label\":\"TestMessage\",\"SessionId\":\"Session1\"}"}