I have sample JSON Payload shared below.

{
              "multisetAttribute": [
                {
                  "attributes": [
                    {
                      "name": "Loading/Discount Type",
                      "value": "Bonus Discount"
                    },
                    {
                      "name": "Premium of Cover",
                      "value": "9550"
                    },
                    {
                      "name": "LD Rate",
                      "value": "0.35"
                    },
                    {
                      "name": "LD Amount",
                      "value": "3343"
                    }
                  ]
                },
                {
                  "attributes": [
                    {
                      "name": "Loading/Discount Type",
                      "value": "Renewal Loading - OD"
                    },
                    {
                      "name": "Premium of Cover",
                      "value": "1862"
                    },
                    {
                      "name": "LD Rate",
                      "value": "0.0"
                    },
                    {
                      "name": "LD Amount",
                      "value": "0"
                    }
                  ]
                },
                {
                  "attributes": [
                    {
                      "name": "Loading/Discount Type",
                      "value": "Experience Based Discount"
                    },
                    {
                      "name": "Premium of Cover",
                      "value": "6208"
                    },
                    {
                      "name": "LD Rate",
                      "value": "0.7"
                    },
                    {
                      "name": "LD Amount",
                      "value": "4345"
                    }
                  ]
                }
              ],
              "name": "Loading Discount Details",
              "value": null
            }

From above payload, I am trying to fetch “LD Rate” value which resides inside inner JSON Array named as “attributes”.

Since we have multiple “attributes” inner JSON Array , to fetch “LD Rate” element there is one specific condition ie In which compartment “Loading/Discount Type” value comes as “Experience Based Discount”, from that compartment, I should fetch “LD Rate” value (in this case 0.7)

Note: we should not pass array position to fetch element , Because this is dynamic one, we may receive more “attributes” json array.

Below xpath I tried.

<property expression="//multisetAttribute[*]/attributes[*]/name[text()='Loading/Discount Type']/../value[text()='Experience Based Discount']/text()" name="LD_Rate" scope="default" type="STRING"/>

Till this point as per above expression it is printing like “Experience Based Discount” as LD_Rate. really not sure how to navigate to next element value (ie LD Rate) in same node.

Tried below xpath expression which is not giving “LD Rate” value.

<property expression="//multisetAttribute[*]/attributes[*]/name[text()='Loading/Discount Type']/../value[text()='Experience Based Discount']/../name[text()='LD Rate']/../value/text()" name="LD_Rate" scope="default" type="STRING"/>

Sample API Code:

<?xml version="1.0" encoding="UTF-8"?>
<api context="/jsonarrayapi" name="jsonarrayapi"
    xmlns="http://ws.apache.org/ns/synapse">
    <resource methods="POST">
        <inSequence>
            <property expression="//multisetAttribute[*]/attributes[*]/name[text()='Loading/Discount Type']/../value[text()='Experience Based Discount']/../name[text()='LD Rate']/../value/text()" name="LD_Rate" scope="default" type="STRING"/>
            <log level="custom">
                <property expression="//multisetAttribute[*]/attributes[*]/name[text()='Loading/Discount Type']/../value[text()='Experience Based Discount']/../name[text()='LD Rate']/../value/text()" name="LD_Rate" scope="default" type="STRING"/>
            </log>
            <payloadFactory media-type="json">
                <format>"LD_Rate":"$1"}</format>
                <args>
                    <arg evaluator="xml" expression="$ctx:LD_Rate"/>
                </args>
            </payloadFactory>
            <respond/>
        </inSequence>
        <outSequence/>
        <faultSequence/>
    </resource>
</api>

Can someone help us to find out XPATH or JSON path expression for this issue?