declare ret as int, @response as nvarchar(max); exec ret=sp_invoke_external_rest_endpoint @method='POST', @url='https://test-001.dev.azuresynapse.net/pipelines/test/createRun?api-version=2018-06-10', @response=@response output; select ret as ReturnCode, @response as Response;