Loop in Xpath for ION API

gaston-gledhill

I am using the ION WM API / wmwebservice_rest / {warehouse} / loads / {loadid}

The input document is a BOD Custom:

<SyncInt_LoadId>     <DataArea>         <Sync>             <TenantID>Infor</TenantID>             <AccountingEntityID/>             <LocationID/>             <ActionCriteria>                 <ActionExpression actionCode="Replace"/>             </ActionCriteria>         </Sync>         <Int_LoadId>         <Int_LoadId>     <whseid>xxxxxx_wmwhse10</whseid>     <loadid>909001</loadid>     <route>5001</route>     <externalid>0000000301</externalid>     <status>0</status>     <carrierid>123456</carrierid>     <trailertype>Pallet</trailertype>     <drivername>Carlos</drivername>     <trailerid>5556</trailerid>     <stops>         <stop>             <loadstopid>1</loadstopid>             <loadorderdetails>                 <shipmentorderid>0000000170</shipmentorderid>             </loadorderdetails>         </stop>         <stop>             <loadstopid>1</loadstopid>             <loadorderdetails>                 <shipmentorderid>0000000168</shipmentorderid>             </loadorderdetails>         </stop>     </stops>     <action>A</action>     <idkey>1</idkey> </Int_LoadId>         </Int_LoadId>     </DataArea> </SyncInt_LoadId>

The mapping XPath is:

 

 

{                 "fieldOverrides": null,                 "hrefs": [{                                "ref": null,                                "url": null                 }],                                                 "loadid": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/loadid"},                 "route": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/route"},                 "externalid": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/externalid"},                 "status": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/status"},                 "carrierid": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/carrierid"},                 "trailertype": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/trailertype"},                  "drivername": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/drivername"},                 "trailerid": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/trailerid"}, "stops": [                                          {       "stop": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/stops/stop/loadstopid"},       "loadorderdetails": [         { "shipmentorderid": {"IonApiRef":"SyncInt_LoadId/DataArea/Int_LoadId/Int_LoadId/stops/stop/loadorderdetails/shipmentorderid"}}       ]     }                        ]       }

The document is created fine, but it only takes the first stop of the first document.

The query is like being able to generate the repetitive structure of stops.

Legacy Contributor

I`m using script to loop into specific path of XML, please find bellow in Bold:

 

 

import xml.etree.ElementTree as ET

 

root = ET.fromstring(bod_input)

 

xmlns = "{">schema.infor.com/.../2}"

 

#TAG Raiz

Raiz_O = '<ProcessSupplierInvoice xmlns="http://schema.infor.com/InforOAGIS/2" xmlns:xs="http://www.w3.org/2001/XMLSchema" languageCode="en-US" releaseID="9.2" systemEnvironmentCode="Production" versionID="2.8.0">'

 

#Application Area

CreationDateTime = root.find('.//{0}ApplicationArea/{0}CreationDateTime'.format(xmlns))

 

ApplicationArea = ('<ApplicationArea>'

                        '<CreationDateTime>{0}</CreationDateTime>'

                    '</ApplicationArea>'

                    .format(

                        CreationDateTime.text   #0

                    )

)

 

#Data Area

DataArea_O         = '<DataArea>'

 

TenantID           = root.find('.//{0}DataArea/{0}Sync/{0}TenantID'.format(xmlns)).text

AccountingEntityID = root.find('.//{0}DataArea/{0}Sync/{0}AccountingEntityID'.format(xmlns)).text

LocationID         = root.find('.//{0}DataArea/{0}Sync/{0}LocationID'.format(xmlns)).text

EffectiveDateTime  = root.find('.//{0}DataArea/{0}Sync/{0}ActionCriteria/{0}ChangeStatus/{0}EffectiveDateTime'.format(xmlns)).text

 

#Process

Sync = ('<Process>'

            '<TenantID>{0}</TenantID>'

            '<AccountingEntityID>{1}</AccountingEntityID>'

            '<LocationID>{2}</LocationID>'

            '<ActionCriteria>'

                '<ActionExpression actionCode="Add"/>'

                '<ChangeStatus>'

                    '<Code listAgencyID="Infor" listID="ReceiveDeliveryStatus">Received</Code>'

                    '<Description>Received</Description>'

                    '<EffectiveDateTime>{3}</EffectiveDateTime>'

                '</ChangeStatus>'

            '</ActionCriteria>'

        '</Process>'

        .format(

            TenantID,                      #00

            AccountingEntityID,            #01

            LocationID,                    #02

            EffectiveDateTime              #03

        )

)

 

#SupplierInvoice

SupplierInvoice_O = '<SupplierInvoice type="CreditMemo">'

 

#Shipment Header

H_DocumentID_accountingEntity     = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}DocumentID/{0}ID'.format(xmlns)).attrib['accountingEntity']

H_DocumentID_lid                  = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}DocumentID/{0}ID'.format(xmlns)).attrib['lid']

H_DocumentID_location             = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}DocumentID/{0}ID'.format(xmlns)).attrib['location']

 

Line                         = root.findall('.//{0}DataArea/{0}Shipment/{0}ShipmentItem'.format(xmlns))

i = 1

 

for n in Line:

    if i == 1:

        H_DocumentID_ID = n.find('{0}UserArea/{0}Property/{0}NameValue[@name= "eam.UDFCHAR03"]'.format(xmlns)).text

        i = i + 1

 

H_DocumentDateTime                = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}DocumentDateTime'.format(xmlns)).text

H_Description                     = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}Description'.format(xmlns)).text

H_SupplierParty_accountingEntity  = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}ShipToParty/{0}PartyIDs/{0}ID'.format(xmlns)).attrib['accountingEntity']

H_SupplierParty_ID                = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentHeader/{0}ShipToParty/{0}PartyIDs/{0}ID'.format(xmlns)).text

H_Status_Code                     = 'Open'

H_Status_ReasonCode               = 'A'

H_PurchaseOrderReference_DocumentID_accountingEntity    = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentItem/{0}PurchaseOrderReference/{0}DocumentID/{0}ID[1]'.format(xmlns)).attrib['accountingEntity']    

H_PurchaseOrderReference_DocumentID_lid                 = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentItem/{0}PurchaseOrderReference/{0}DocumentID/{0}ID[1]'.format(xmlns)).attrib['lid']                

H_PurchaseOrderReference_DocumentID_location            = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentItem/{0}PurchaseOrderReference/{0}DocumentID/{0}ID[1]'.format(xmlns)).attrib['location']            

H_PurchaseOrderReference_DocumentID_ID                  = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentItem/{0}PurchaseOrderReference/{0}DocumentID/{0}ID[1]'.format(xmlns)).text                          

H_PurchaseOrderReference_LineNumber                     = root.find('.//{0}DataArea/{0}Shipment/{0}ShipmentItem/{0}PurchaseOrderReference/{0}LineNumber[1]'.format(xmlns)).text

 

SupplierInvoiceHeader = ('<SupplierInvoiceHeader>'

                                '<DocumentID>'

                                    '<ID accountingEntity="{0}" lid="{1}" location="{2}" variationID="">{3}R</ID>'

                                '</DocumentID>'

                                '<AlternateDocumentID>'

                                    '<ID>{3}R</ID>'

                                '</AlternateDocumentID>'

                                '<DocumentDateTime>{4}</DocumentDateTime>'

                                '<Description>{5}</Description>'

                                '<SupplierParty>'

                                    '<PartyIDs>'

                                        '<ID accountingEntity="{6}">{7}</ID>'

                                    '</PartyIDs>'

                                '</SupplierParty>'

                                '<Status>'

                                    '<Code>{8}</Code>'

                                    '<ReasonCode>{9}</ReasonCode>'

                                '</Status>'

                                '<UserArea>'

                                    '<Property>'

                                        '<NameValue name="eam.InvoiceReturnFlag" type="boolean">true</NameValue>'

                                    '</Property>'

                                    '<Property>'

                                        '<NameValue name="eam.TypeCode">C</NameValue>'

                                    '</Property>'

                                '</UserArea>'

                                '<DocumentReference type="ParentInvoice">'

                                    '<DocumentID>'

                                        '<ID accountingEntity="{0}" location="{2}">{3}</ID>'

                                    '</DocumentID>'

                                '</DocumentReference>'

                                '<PurchaseOrderReference>'

                                    '<DocumentID>'

                                        '<ID accountingEntity="{10}" lid="{11}" location="{12}">{13}</ID>'

                                    '</DocumentID>'

                                    '<LineNumber>{14}</LineNumber>'

                                '</PurchaseOrderReference>'

                        '</SupplierInvoiceHeader>'

                        .format(

                            H_DocumentID_accountingEntity,                          #00

                            H_DocumentID_lid,                                       #01

                            H_DocumentID_location,                                  #02

                            H_DocumentID_ID,                                        #03

                            H_DocumentDateTime,                                     #04

                            H_Description,                                          #05

                            H_SupplierParty_accountingEntity,                       #06

                            H_SupplierParty_ID,                                     #07

                            H_Status_Code,                                          #08

                            H_Status_ReasonCode,                                    #09

                            H_PurchaseOrderReference_DocumentID_accountingEntity,   #10

                            H_PurchaseOrderReference_DocumentID_lid,                #11

                            H_PurchaseOrderReference_DocumentID_location,           #12

                            H_PurchaseOrderReference_DocumentID_ID,                 #13

                            H_PurchaseOrderReference_LineNumber                     #14

                        )

)

 

#Shipment Item

SupplierInvoiceLine = ""

n = root.findall('.//{0}DataArea/{0}Shipment/{0}ShipmentItem'.format(xmlns))

 

for Item in n:

    L_LineNumber                                            = Item.find('{0}LineNumber'.format(xmlns)).text                                                         if Item.find('{0}LineNumber'.format(xmlns)).text is not None  else "" 

    L_ItemID_accountingEntity                               = Item.find('{0}ItemID/{0}ID'.format(xmlns)).attrib['accountingEntity']    

    L_ItemID_ID                                             = Item.find('{0}ItemID/{0}ID'.format(xmlns)).text                                                        

    L_Quantity_unitCode                                     = Item.find('{0}ShippedQuantity'.format(xmlns)).attrib['unitCode']                                      

    L_Quantity                                              = Item.find('{0}ShippedQuantity'.format(xmlns)).text                                                    

    L_UnitPrice_Amount_currencyID                           = Item.find('{0}UserArea/{0}Property/{0}NameValue[@name= "eam.UDFCHAR01"]'.format(xmlns)).text         

    L_UnitPrice_Amount                                      = Item.find('{0}UserArea/{0}Property/{0}NameValue[@name= "eam.UDFCHAR02"]'.format(xmlns)).text          

    L_PurchaseOrderReference_DocumentID_accountingEntity    = Item.find('{0}PurchaseOrderReference/{0}DocumentID/{0}ID'.format(xmlns)).attrib['accountingEntity']    

    L_PurchaseOrderReference_DocumentID_lid                 = Item.find('{0}PurchaseOrderReference/{0}DocumentID/{0}ID'.format(xmlns)).attrib['lid']                

    L_PurchaseOrderReference_DocumentID_location            = Item.find('{0}PurchaseOrderReference/{0}DocumentID/{0}ID'.format(xmlns)).attrib['location']            

    L_PurchaseOrderReference_DocumentID_ID                  = Item.find('{0}PurchaseOrderReference/{0}DocumentID/{0}ID'.format(xmlns)).text                          

    L_PurchaseOrderReference_LineNumber                     = Item.find('{0}PurchaseOrderReference/{0}LineNumber'.format(xmlns)).text                               

 

    SupplierInvoiceLine = SupplierInvoiceLine + ('<SupplierInvoiceLine>'

                                                    '<LineNumber>{0}</LineNumber>'

                                                    '<Item>'

                                                        '<ItemID>'

                                                            '<ID accountingEntity="{1}">{2}</ID>'

                                                        '</ItemID>'

                                                    '</Item>'

                                                    '<Quantity unitCode="{3}">{4}</Quantity>'

                                                    '<UnitPrice>'

                                                        '<Amount currencyID="{5}">{6}</Amount>'

                                                        '<PerQuantity unitCode="{3}">1</PerQuantity>'

                                                    '</UnitPrice>'

                                                    '<PurchaseOrderReference>'

                                                        '<DocumentID>'

                                                            '<ID accountingEntity="{7}" lid="{8}" location="{9}">{10}</ID>'

                                                        '</DocumentID>'

                                                        '<LineNumber>{11}</LineNumber>'

                                                    '</PurchaseOrderReference>'

                                                    '<ExtendedAmount currencyID="{5}">{6}</ExtendedAmount>'

                                                    '<UserArea>'

                                                    '<Property>'

                                                        '<NameValue name="eam.ReturnQuantity">{4}</NameValue>'

                                                        '</Property>'

                                                    '</UserArea>'

                                                '</SupplierInvoiceLine>'

                                                .format(

                                                    L_LineNumber,                                           #00

                                                    L_ItemID_accountingEntity,                              #01

                                                    L_ItemID_ID,                                            #02

                                                    L_Quantity_unitCode,                                    #03

                                                    L_Quantity,                                             #04

                                                    L_UnitPrice_Amount_currencyID,                          #05

                                                    L_UnitPrice_Amount,                                     #06

                                                    L_PurchaseOrderReference_DocumentID_accountingEntity,   #07

                                                    L_PurchaseOrderReference_DocumentID_lid,                #08

                                                    L_PurchaseOrderReference_DocumentID_location,           #09

                                                    L_PurchaseOrderReference_DocumentID_ID,                 #10

                                                    L_PurchaseOrderReference_LineNumber                     #11

                                                )

    )

 

#Fechamento das TAGs

SupplierInvoice_C = '</SupplierInvoice>'

DataArea_C = '</DataArea>'

Raiz_C = '</ProcessSupplierInvoice>'

 

XML = (Raiz_O + 

    ApplicationArea + 

    DataArea_O +

    Sync +

    SupplierInvoice_O +

    SupplierInvoiceHeader +

    SupplierInvoiceLine +

    SupplierInvoice_C +

    DataArea_C +

    Raiz_C

)

 

time.sleep(15)

 

bod_output = XML