What could be this XML success path

Avatar
Harish Bakka
Updated
Engaged

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"?>
<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">
<soap:Body>
<SubmitOrdersResponse xmlns="http://www.capacityllc.com/">
<SubmitOrdersResult>
<SUBMITORDERSTATUS xmlns="">
<STATUS>SUCCESS</STATUS>
<ORDERS>
<ORDER>
<ORH_ORDER_NUMBER>SF119634</ORH_ORDER_NUMBER>
<ORH_ORDER_STATUS>PR</ORH_ORDER_STATUS>
<ORH_ORDER_STATUS_DESCRIPTION>Inital</ORH_ORDER_STATUS_DESCRIPTION>
<ORH_WAREHOUSE_ORDER>36358200</ORH_WAREHOUSE_ORDER>
</ORDER>
</ORDERS>
</SUBMITORDERSTATUS>
</SubmitOrdersResult>
</SubmitOrdersResponse>
</soap:Body>
</soap:Envelope>

Thanks

Harish

0

Comments

3 comments
Date Votes
  • Avatar
    Kate Larson
    (Edited )
    Senior UX Researcher Community moderator

    Hi Harish Bakka,

    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://docs.celigo.com/hc/en-us/community/posts/360076810211-Success-Path-in-XML-Lookups

    Thanks,
    Kate

    0
  • Avatar
    Anirudh Sundaram
    Senior Integration Engineer
    Engaged
    Great Answer

    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.

    -Anirudh

    0
  • Avatar
    Bas van Ditzhuijzen
    Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz
    Partner Implementation Certification
    Great Answer
    Answer Pro
    Engaged
    Celigo University Level 4: Legendary

    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.

    2

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post