Implementing Xpath in Mapping



1 minute read

XPATH is an essential concept that is required when implementing mapping and transformations. XPATH access nodes in a hierarchical structure as represented in the XML file.

Pre-requisites for implementing Xpath in Mapping

  • Login to the APPSeCONNECT Portal with valid credentials.
  • Navigate to the Process Flow Listing Section. Here you can view the list of existing Process Flows.
  • Create a New Process Flow or Edit an existing Process Flow.
  • If you are using Tech App or Custom App create the app prior to designing process flow.

Basic Flow

  1. Navigate to the processflow from process flow listng page, for which the Mapping is to be done.
  2. Click on the Mapper node on the processflow you have selected. The user will now be able to view the Transformation window of that processflow.
    Xpath Mapping Processflow1
  3. Expand the Transformation node till the Complex Objects and the ComplexObjectsCollections are visible.
    Note : In this case the processflow Business Partner add is used for syncing data between Magento2 and SAP B1.
  4. In the ComplexObject BPAddresses, XPATH has been provided for mapping the attribute Street.
    Xpath Mapping Processflow2
    Note : The XPATH should be provided based upon the INPUT packet generated after the sync process. As a prerequisite, the processflow should be deployed and executed for viewing the XML nodes structure hierarchy.
  5. The XPATH mapped is { {street/item[1]} }. [1] indicates the first position instance of the node item under the element street shall be accessed.
  6. For easy know-how, view the input packet provided below. xpath-usecase2

ProTip: XPATH can be mapped in any entity, be it a ComplexObject, ComplexObjectCollection or an attribute. XPATH can be used for mapping in variables too.

The user can view the successful sync of the processflow for the integration between Magento2 and SAP Business One. The user can implement rendering when required for any process flow. Click Here to know more about the troubleshootings.