How to fetch line details/for loop in JSON mapping (ION API connection)

Ajay Dalvi

Hi,

 

I have scenario where XML is transferred to JSON and sending a request, before I'm sending mapping API request and I'm able to sucessfully fetch header data.

But how could we fetch line details/for loop.

 

MY XML DATA

---------------

<SyncWS_PACKCONF releaseID="9.2">
    <ApplicationArea>
        <Sender>
            <LogicalID>infor.database.mk_ws_iontest_db</LogicalID>
            <ComponentID>External</ComponentID>
            <ConfirmationCode>OnError</ConfirmationCode>
        </Sender>
        <CreationDateTime>2019-05-23T10:53:00.123Z</CreationDateTime>
        <BODID>infor.database.mk_ws_iontest_db:1558608780122:5340:0</BODID>
    </ApplicationArea>
    <DataArea>
        <Sync>
            <TenantID>INFOR</TenantID>
            <AccountingEntityID/>
            <LocationID/>
            <ActionCriteria>
                <ActionExpression actionCode="Replace"/>
            </ActionCriteria>
        </Sync>
        <WS_PACKCONF>
            <Doc_Type>01   </Doc_Type>
            <Doc_Code>29809</Doc_Code>
            <Doc_Prefix>ECOM</Doc_Prefix>
            <Doc_Number>3</Doc_Number>
            <LstItems>
                <AddlItemCode/>
                <LogicUser_Code>998899843993</LogicUser_Code>
                <Packing_Box_No>MKFSC34572</Packing_Box_No>
                <Quantity>1</Quantity>
                <Lot_MRP>899</Lot_MRP>
            </LstItems>

<LstItems>
                <AddlItemCode/>
                <LogicUser_Code>998899843993</LogicUser_Code>
                <Packing_Box_No>MKFSC34572</Packing_Box_No>
                <Quantity>1</Quantity>
                <Lot_MRP>899</Lot_MRP>
            </LstItems>
        </WS_PACKCONF>
    </DataArea>
</SyncWS_PACKCONF>

 

MY Mapping code
-----------------

{
 "Doc_Code": {"IonApiRef":"//DataArea/WS_PICKSLIP/Doc_Code"},
 "Doc_Prefix": {"IonApiRef":"//DataArea/WS_PICKSLIP/Doc_Prefix"},
 "DO_Date": {"IonApiRef":"//DataArea/WS_PICKSLIP/DO_Date"}
}

How do we get LstItems line data here?

 

How to fetch line details/for loop in JSON mapping (ION API connection)?

 

Regards,

Somashekhar

Legacy Contributor

<?xml version="1.0"?>

<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform">

<xsl:template match="SyncWS_PACKCONF">

<SyncWS_PACKCONF>

<xsl:apply-templates select="ApplicationArea"/>

<xsl:apply-templates select="DataArea"/>

</SyncWS_PACKCONF>

</xsl:template>

<xsl:template match="ApplicationArea">

<ApplicationArea>

<xsl:copy-of select="*"/>

</ApplicationArea>

</xsl:template>

<xsl:template match="DataArea">

<DataArea>

<xsl:apply-templates select="Sync"/>

<xsl:apply-templates select="WS_PACKCONF"/>

</DataArea>

</xsl:template>

<xsl:template match="Sync">

<Sync>

<xsl:copy-of select="*"/>

</Sync>

</xsl:template>

<xsl:template match="WS_PACKCONF">

<xsl:for-each select="./LstItems">

<AddlItemCode><xsl:value-of select="./Packing_Box_No"/></AddlItemCode>

</xsl:for-each>

</xsl:template>

</xsl:stylesheet>