returns only first matching node

unknown

Hello,

I am using Map input document to API request to form the Request Body of an API Connection point call. I am trying to include all lines from a PO. The issue is <IonApiRef> with XPath for the lines only pulls in the first line. How do form an IonApiRef path that will include all lines?

Example custom BOD with many section snipped out:

<SyncSAPPurchaseOrder >

    <ApplicationArea>

        <SnippedText/>

    </ApplicationArea>

    <DataArea>

        <Sync>

            <SnippedText/>

        </Sync>

        <SAPPurchaseOrder>

            <HEADER>

                <POID>23000313</POID>

                <SnippedText/>

            </HEADER>

            <ITEM>

                <PO_LINE>1</PO_LINE>

                <SnippedText/>

            </ITEM>

            <ITEM>

                <PO_LINE>2</PO_LINE>

                <SnippedText/>

            </ITEM>

            <ITEM>

                <PO_LINE>3</PO_LINE>

                <SnippedText/>

            </ITEM>

            <ITEM>

                <PO_LINE>4</PO_LINE>

                <SnippedText/>

            </ITEM>

        </SAPPurchaseOrder>

    </DataArea>

</SyncSAPPurchaseOrder>

This is my Request Body:

<ns0:MT_FLNA_PurchaseOrder xmlns:ns0="">company:flna:PTP:WCMS:PurchaseOrderIn"
xmlns:xs="">www.w3.org/.../XMLSchema">
<IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/HEADER</IonApiRef>
<IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/ITEM</IonApiRef>
</ns0:MT_FLNA_PurchaseOrder>

This is what gets formed:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<ns0:MT_FLNA_PurchaseOrder xmlns:ns0="">company:flna:PTP:WCMS:PurchaseOrderIn" xmlns:xs="">www.w3.org/.../XMLSchema">

<HEADER>

                <POID>23000313</POID>

                <SnippedText/>

            </HEADER>

<ITEM>

                <PO_LINE>1</PO_LINE>

                <SnippedText/>

            </ITEM>

</ns0:MT_FLNA_PurchaseOrder>

Please note the API payload includes only the first <ITEM> node and not the remaining nodes.

Using an XPath testing tool return all <ITEM> nodes for the XPath contained within the <IonApiRef> node in the Rewquest Body.

Any input appreciated!

Thank you,

James Crow

unknown

Hi, 

From hatGPT.

regards

Erik

To include all the lines from a PO in your API request, you need to modify the <IonApiRef> paths in your Request Body. Currently, you have separate <IonApiRef> elements for the header and each item, which is why only the first item is included in the resulting XML.

To include all the items, you can use a wildcard in the <IonApiRef> path to represent multiple occurrences. In your case, you can use the wildcard "*" after the "ITEM" element to indicate that you want to include all occurrences of the ITEM element. Here's an updated version of your Request Body:

xmlCopy code

<span class="hljs-tag"><<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder <span class="hljs-attr">xmlns:ns0=<span class="hljs-string">"">company:flna:PTP:WCMS:PurchaseOrderIn" xmlns:xs="">www.w3.org/.../XMLSchema"> <span class="hljs-tag"><<span class="hljs-name">IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/HEADER<span class="hljs-tag"></<span class="hljs-name">IonApiRef> <span class="hljs-tag"><<span class="hljs-name">IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/ITEM/*<span class="hljs-tag"></<span class="hljs-name">IonApiRef> <span class="hljs-tag"></<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder>

With this modification, all the ITEM elements within the SAPPurchaseOrder will be included in the resulting XML of the API request.

example ?

ChatGPT

Here's an example of how the modified Request Body would look with the wildcard in the <IonApiRef> path:

xmlCopy code

<span class="hljs-tag"><<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder <span class="hljs-attr">xmlns:ns0=<span class="hljs-string">"company:flna:PTP:WCMS:PurchaseOrderIn" <span class="hljs-attr">xmlns:xs=<span class="hljs-string">"www.w3.org/.../XMLSchema"> <span class="hljs-tag"><<span class="hljs-name">IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/HEADER<span class="hljs-tag"></<span class="hljs-name">IonApiRef> <span class="hljs-tag"><<span class="hljs-name">IonApiRef>SyncSAPPurchaseOrder/DataArea/SAPPurchaseOrder/ITEM/*<span class="hljs-tag"></<span class="hljs-name">IonApiRef> <span class="hljs-tag"></<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder>

The resulting XML from this Request Body would include all the ITEM elements within the SAPPurchaseOrder, like this:

xmlCopy code

<span class="hljs-meta"><?xml version=<span class="hljs-string">"1.0" encoding=<span class="hljs-string">"UTF-8" standalone=<span class="hljs-string">"no"?> <span class="hljs-tag"><<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder <span class="hljs-attr">xmlns:ns0=<span class="hljs-string">"company:flna:PTP:WCMS:PurchaseOrderIn" <span class="hljs-attr">xmlns:xs=<span class="hljs-string">"www.w3.org/.../XMLSchema"> <span class="hljs-tag"><<span class="hljs-name">HEADER> <span class="hljs-tag"><<span class="hljs-name">POID>23000313<span class="hljs-tag"></<span class="hljs-name">POID> <span class="hljs-tag"><<span class="hljs-name">SnippedText/> <span class="hljs-tag"></<span class="hljs-name">HEADER> <span class="hljs-tag"><<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">PO_LINE>1<span class="hljs-tag"></<span class="hljs-name">PO_LINE> <span class="hljs-tag"><<span class="hljs-name">SnippedText/> <span class="hljs-tag"></<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">PO_LINE>2<span class="hljs-tag"></<span class="hljs-name">PO_LINE> <span class="hljs-tag"><<span class="hljs-name">SnippedText/> <span class="hljs-tag"></<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">PO_LINE>3<span class="hljs-tag"></<span class="hljs-name">PO_LINE> <span class="hljs-tag"><<span class="hljs-name">SnippedText/> <span class="hljs-tag"></<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">ITEM> <span class="hljs-tag"><<span class="hljs-name">PO_LINE>4<span class="hljs-tag"></<span class="hljs-name">PO_LINE> <span class="hljs-tag"><<span class="hljs-name">SnippedText/> <span class="hljs-tag"></<span class="hljs-name">ITEM> <span class="hljs-tag"></<span class="hljs-name">ns0:MT_FLNA_PurchaseOrder>

Now, all the ITEM elements are included in the resulting XML, allowing you to include all the lines from the purchase order in your API request.