JSONPath Expression in wso2 esb

Question

I have a json payload that looks like below:

{
   "orders" : {
    "order.id" : 1024,
    "order.name" : "Ruffled-top"
}
}

I need to fetch order.id and order.name. Dot notation of JSONpath expression anyways won't work here. So I tried bracket notation like:

<property name="order-id" expression="json-eval($[orders][order.id])"/>

But the bracket notation is not working in wso2. Is there any other way this can be achieved? Thanks in advance.

score 1 · Accepted Answer · answered Oct 18 '22 at 10:42

You need to have order.id surrounded by '' inside the []. To access the orders object you can use the dot notation as well.

<property expression="json-eval($.orders.['order.id'])" name="order-id" scope="default" type="STRING"/>

or

<property expression="json-eval($['orders']['order.id'])" name="order-id" scope="default" type="STRING"/>

1 Answers1