SSRS report - XML query with POST

Question

How can I specify a request method in an xml query? I need to use POST.

Thanks

Answer 1

Here is my query:
<Query>
<Method Name="LoginOTP" Namespace="http://schemas.xmlsoap.org/soap/envelope/">
<Parameters>
<Parameter Name="ClientID">
<DefaultValue>xxxxxxx</DefaultValue>
</Parameter>
<Parameter Name="GUID">
<DefaultValue>some_guid</DefaultValue>
</Parameter>
<Parameter Name="User">
<DefaultValue>xxx</DefaultValue>
</Parameter>
<Parameter Name="Password">
<DefaultValue>xxxx</DefaultValue>
</Parameter>
</Parameters>
</Method>
<SoapAction>abc/hhh/lkklk</SoapAction>
</Query>

And I get this:

Hard to say if it s the correct one becausue I need to add two headers.

Answer 2

Ok, one problem is solved. What about my other problem such as adding custom headers? Also in Postman it only works if I use form data/raw. Using form fields wasn't working for me. Is the same as specifying parameters in an XML query?

Thanks for all the help you provide.

Answer 3

I need to use POST.

POST is the HTTP command: https://en.wikipedia.org/wiki/POST_(HTTP)
That's automatically done by SSRS when it accesses a SOAP API over Http.

Answer 4

No, I am trying XML query to get data from a web service. The web service method expects POST and custom headers. Both I don't know how to add.

Answer 5

Hi @mark goldin ,
How are you using XML in SSRS , are you trying to have XML datasource from one website ?
Best Regards,
Joy