XPath inconsistency between HTTP and FTP?

Integrator.io
, , ,
1

I have an HTTP export calling a SOAP web service and an xpath statement to access the records in the response:

XML Data from web service:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
    xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    
        <aa
            xmlns="http://tempuri.org/">
            
                
                    
                        152561087
                    
                    
                        152580890

XPath:

/*[local-name()='Envelope']/*[local-name()='Body']/*[local-name()='aa']/*[local-name()='bb']/*[local-name()='Data']/*[local-name()='cc']

Yields:

{
    "page_of_records": [{
            "record": {
                "$": {
                    "xmlns": "http://tempuri.org/"
                },
                "OrderId": [{
                    "_": "152561087"
                }]
            }
        },
        {
            "record": {
                "$": {
                    "xmlns": "http://tempuri.org/"
                },
                "OrderId": [{
                    "_": "152580890"
                }]
            }
        }
    ]
}

OK, great, so that is working. Now I'm trying to load the same exact data, literally the web service response stream from PostMan saved to xml file, but I can't figure out what the Xpath should be in the FTP Export. You'd think it would be the same Xpath as the HTTP export, but no, it's not. I've been at this for hours trying to figure out what Celigo is expecting for the FTP resource path to be.

I've tried the XML parser tool in the dev playground with the same results.

5301043caa20740200000001-e3f138ea16754abf8f69e1897f435d5c.png
5301043caa20740200000001-e3f138ea16754abf8f69e1897f435d5c.png890×681 29.8 KB

2

@steveklett it looks like we made need a ticket logged for the inconsistency, but it also looks like you can use normal path:

/soap:Envelope/soap:Body/aa/bb/Data/cc

5301043caa20740200000001-a5bc84d38bbb4cf5bd1d95473f75cb67.png
5301043caa20740200000001-a5bc84d38bbb4cf5bd1d95473f75cb67.png1823×931 38.6 KB

3

@tylerlamparter Well, I'll be damned! I guess I was overcomplicating it. I was sure I had to avoid namepsaces altogether, especially because the element didn't have a binding, guess I was wrong.

Thanks a ton, Tyler, you got me out of a pinch.

BTW, I'm doing this to try to workaround the IIO response stream limitation of 5242880 bytes. The endpoint we're calling doesn't have pagination and they response payload size is obscene.

Thanks again :)