Integration

Get Involved. Join the Conversation.

Topic

    Vitor Souza
    OIC mapping only one element of a repeated elementAnswered
    Topic posted September 11, 2019 by Vitor SouzaGreen Ribbon: 100+ Points, tagged Integration, RightNow, xml 
    39 Views, 2 Comments
    Title:
    OIC mapping only one element of a repeated element
    Summary:
    OIC mapping only one element of a repeated element
    Content:

    I'm trying to map one element of a repeated element, this repetead element is receiving the value of 3 tags with the same name (result) of a XML (image attached).

    The problem is that I would like to map only the third tag value but I can't expand this repeated element and select only one tag value.

    Is there any function that I could use to map only one of the values I'm receiving?

    Thanks in advance!

     

     

     

    Image:
    Document:
    XML.png (228KB)

    Best Comment

    Hemanth Lakkaraju

    In the mapping, you need to add predicate. like $PreviewContrato/previewContractResponse/result[3]

    This is possible in JET mapper but ADF mapper it is not possible directly.

    What you can do to fix?
    1. Drag and drop result onto target
    2. Save the mapping.
    3. Right click on the xsl:value-of and say edit or click on the pencil icon for the row.
    4. Copy the contents of the child of select attribute. the row starts with (x) symbol.
    5. Right click on the child of select attribute. the row starts with (x) symbol and select Input Literal.
    6. Paste the contents and then add predicate [3] at the end.
    7. Save the mapping and you should be good to go.

    Comment

     

    • Hemanth Lakkaraju

      In the mapping, you need to add predicate. like $PreviewContrato/previewContractResponse/result[3]

      This is possible in JET mapper but ADF mapper it is not possible directly.

      What you can do to fix?
      1. Drag and drop result onto target
      2. Save the mapping.
      3. Right click on the xsl:value-of and say edit or click on the pencil icon for the row.
      4. Copy the contents of the child of select attribute. the row starts with (x) symbol.
      5. Right click on the child of select attribute. the row starts with (x) symbol and select Input Literal.
      6. Paste the contents and then add predicate [3] at the end.
      7. Save the mapping and you should be good to go.