What could be this XML success path

Integrator.io
, , , ,
1

Hello,

I'm trying to find response success if response code 200, then update NetSuite again.

flow: Export NetSuite orders - Import in (HTTP warehouse) - response (200) then update a custom field in NetSuite. however, I couldn't able to find a way to get success path and response.

Postman Response:

<?xml version="1.0" encoding="utf-8"?>
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">

http://www.capacityllc.com/">


SUCCESS


SF119634
PR
Inital
36358200






Thanks

Harish

2

Hi @harishbakka,

I'm checking with some internal experts, but in the meantime you might want to check out this thread for any insights that may help you: https://connective.celigo.com/t/success-path-in-xml-lookups/1272

Thanks,
Kate

3

Hi Harish,

You can simply map 'statusCode' in the response mapping for the import step to pass the response code to the next step. You don't need to set the success path since the response code is unrelated to the XML being sent back in the import.

5301043caa20740200000001-507b3122a9df487ead2300bf1ca2b57b.png
5301043caa20740200000001-507b3122a9df487ead2300bf1ca2b57b.png1091×544 23.9 KB

-Anirudh

4

Hi,

for the succes path to a SOAP xml response you need the complete local-name xpath to the node you want to find, so for your example you would need:

/*[local-name()='Envelope']/*[local-name()='Body']/*[local-name()='SubmitOrdersResponse']/*[local-name()='SubmitOrdersResult']/*[local-name()='SUBMITORDERSTATUS']/*[local-name()='STATUS']/text()

You can test it by using a site like xpather.com

For the resource xpath you would use the same syntax only point it to the ORDER node, ommitting the /text() operator.