# XPath inconsistency between HTTP and FTP?

**URL:** <https://connective.celigo.com/t/xpath-inconsistency-between-http-and-ftp/445>\
**Category:** Integrator.io\
**Tags:** http, ftp, file-transfer, xml\
**Created:** [May 31, 2023, 12:28am UTC](https://connective.celigo.com/t/xpath-inconsistency-between-http-and-ftp/445 "2023-05-31T00:28:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![steveklett](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@steveklett](https://connective.celigo.com/u/steveklett)\
**Post date:** [May 31, 2023, 12:28am UTC](https://connective.celigo.com/t/xpath-inconsistency-between-http-and-ftp/445/1 "2023-05-31T00:28:10Z")

</div>

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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5887cb9f834e1d344a555f92e0283a18d05460a6.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 31, 2023, 1:00am UTC](https://connective.celigo.com/t/xpath-inconsistency-between-http-and-ftp/445/2 "2023-05-31T01:00:00Z")

</div>

@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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/158b533d611d2423d8ec0ecd6ae66fc222427ef3.png)

---

<div class="post-metadata">

**Author:** ![steveklett](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@steveklett](https://connective.celigo.com/u/steveklett)\
**Post date:** [May 31, 2023, 2:02am UTC](https://connective.celigo.com/t/xpath-inconsistency-between-http-and-ftp/445/3 "2023-05-31T02:02:07Z")

</div>

@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 :)