How can I define jsonPath for given json?

Question

 {
"name": "ninja",
"contry": "India",
"Account": [
{
  "id": "123",
  "orgId": 223,
  "investment": [
    {
      "invetmentId": "111",
      "name": "India tech",
      "performance": [
        {
          "id": "123",
          "performanceSet": [
            {
              "amount": "231",
              "currency": "USD"
            },
            {
              "amount": "250",
              "currency": "IND"
            }
          ]
          
        }
      ]
    }
   ]
 }
]
}

So I have to select the amount where the currency is USD?

And I tried it as "$.Account..investment.performance..performanceSet.amount[?(@.currency=~/.*USD/)]"

$.Account..investment..performance..performanceSet..[?(@.currency=~/.*USD/)].amount will this be fine ? — Ninja, Jul 29 '20 at 10:50

pavelsaman · Answer 1 · 2020-07-29T11:01:14.787

This JsonPath should work:

$..performanceSet[?(@.currency == "USD")].amount

Tested on:

{
   "name":"ninja",
   "contry":"India",
   "Account":[
      {
         "id":"123",
         "orgId":223,
         "investment":[
            {
               "invetmentId":"111",
               "name":"India tech",
               "performance":[
                  {
                     "id":"123",
                     "performanceSet":[
                        {
                           "amount":"231",
                           "currency":"USD"
                        },
                        {
                           "amount":"250",
                           "currency":"IND"
                        }
                     ]
                  }
               ]
            },
            {
               "invetmentId":"112",
               "name":"India tech 2",
               "performance":[
                  {
                     "id":"124",
                     "performanceSet":[
                        {
                           "amount":"235",
                           "currency":"USD"
                        },
                        {
                           "amount":"250",
                           "currency":"IND"
                        }
                     ]
                  }
               ]
            }
         ]
      }
   ]
}

which returns:

[
  "231",
  "235"
]

A good way to try it out is this site: https://jsonpath.com/

score 2 · Answer 2 · answered Jul 29 '20 at 10:56

2

Read the docs: https://github.com/intuit/karate#jsonpath-filters

* def temp = $..performanceSet[?(@.currency=='USD')]
* match temp[0].amount == '231'

answered Jul 29 '20 at 10:56

Peter Thomas

54,465
21
84
248

score 0 · Accepted Answer · answered Aug 10 '20 at 08:45

0

You can try it this way

$.Account..investment.performance..performanceSet.amount[?(@.currency=~/.*USD/)]

answered Aug 10 '20 at 08:45

How can I define jsonPath for given json?

3 Answers3