Integration

Get Involved. Join the Conversation.

Topic

    Mark Chappell
    XPATH Filter Expression
    Topic posted October 25, 2019 by Mark ChappellBronze Medal: 1,250+ Points, tagged Adapters, ERP Cloud, Events, Integration 
    51 Views, 3 Comments
    Title:
    XPATH Filter Expression
    Summary:
    Can we define a XPATH Filter Expression using 'AND' and 'OR' operators?
    Content:

    Hi Integration Guru's

    We have a requirement to include complex conditions in our Xpath Filter Expression within our ERP Adaptor, such that our Integration will only fire if a number of attributes meet certain conditions. For example;

    Currently I am subscribing to the Item Update Event in Oracle Product Hub, and I am successfully employing this xpath filter;

    <xpathExpr xmlns:ns_0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns_1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/" xmlns:ns_2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/">$eventPayload/ns_2:result/ns_0:Value/ns_1:VehicleItemFlag="true"</xpathExpr>   

    So we only fire the integration when the VehicleItemFlag is true.

    But I want to only fire the integration when VehicleItemFlag is true AND itemstatus = 'A' and itemOrganisation = 'MASTERORGANISATION' 

    Is this possible? 

    If so, what is the syntax I need to use when referencing multiple items?

    any help is as always, greatly appreciated. 

     

    Thanks

    Mark

    Version:
    Version: 19.3.3.0.0 (190924.1600.31522)

    Comment