SSRS Remove XML Header from SOAP Message

I created an SSRS report that connects to a third-party web service. I am trying to then smooth this xml using ElementPathNode.

My xml is like this

<?xml version="1.0" encoding="utf-8"?>
<soap>
<GetAllCustomersResponse>
<GetAllCustomersResult>
    <?xml version="1.0" encoding="utf-8"?>
    <Customers>
        <Customer id="1">
            <Entry>
                <FromTime>2016-07-31T04:00:00</FromTime>
                <ToTime>2016-08-01T04:00:00</ToTime>
            </Entry>
            <Entry>
                <FromTime>2016-08-01T04:00:00</FromTime>
                <ToTime>2016-08-02T04:00:00</ToTime>
            </Entry>
        </Customer>
    </Customers>
</GetAllCustomersResult>
</GetAllCustomersResponse>
</soap>

So this is invalid xml because the web service that returns the data inserts the xml declaration and then it is authenticated with a soap message. I then do not think that I can choose the right data, for example.

<ElementPath>GetAllCustomersResponse/GetAllCustomersResult/Customers/Customer/Entry{FromTime,ToTime}</ElementPath>

Any ideas on how I could ignore / exclude this unwanted declaration?

+4
source share

Source: https://habr.com/ru/post/1650319/


All Articles