SSRS report - XML Query example

Question

Can someone please provide an example of XML Query that would get data from a web service?

Thanks

Answer 1

Can we use multi level parameters.

If I send a simple query like this it works ok
<Query>

<Method Name="GetMembresSuccFull" Namespace="http://tempuri.org/">

<Parameters>

<Parameter Name="aFiltreMembreSucc">

<DefaultValue></DefaultValue>

</Parameter>

<Parameter Name="CleDeSecurite">

<DefaultValue>valuehere</DefaultValue>

</Parameter>

</Parameters>

</Method>

<SoapAction>http://tempuri.org/IFMConsultation/GetMembresSuccFull</SoapAction>

</Query>
This query result to this
<GetMembresSuccFull xmlns="http://tempuri.org/">

<aFiltreMembreSucc></aFiltreMembreSucc>

<CleDeSecurite>valuehere</CleDeSecurite>

</GetMembresSuccFull>

But what I need to pass a parameter in the aFiltreMembreSucc parameter for it to be sent like this.
To have a Query that send this.
<GetMembresSuccFull>

<aFiltreMembreSucc>

<ListEnvoiStr>E14</ListEnvoiStr>

</aFiltreMembreSucc>

<CleDeSecurite>valuehere</CleDeSecurite>

<GetMembresSuccFull>
How can we do this?