Extract data from JSONArray using jsonpath

Question

I have a JSON file having customer data as below . Here I want to extract the custName & CustId where amount is greater than 10 . But I'm stuck as unable to get the desired jsonpath for extracting these values .

  "customers": [
    {
      "custId": 540,
      "custName": "John",
      "itemId": 647,
      "itemAmount": 3000
    },
    {
      "custId": 432,
      "custName": "Adrian",
      "itemId": 600,
      "itemAmount": 2000
    },
    {
      "custId": 541,
      "custName": "Smith",
      "itemId": 320,
      "itemAmount": 1200
    }
  ]
}

I tried something like - $.customers[*].itemAmount which gave me a list of itemAmount but my objective is entirely different so looking for the jsonPath expression to get the desired data.

egeorge · Accepted Answer · 2022-12-28 20:46:18Z

1

To get both fields for everything meeting the criterion:

$.customers[?(@.itemAmount > 10)]['custName','custId']

I recommend adding some records that do not meet the criterion to your sample so you can be sure it is working.

answered Dec 28, 2022 at 20:46

egeorge

6823 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hiren · Accepted Answer · 2022-12-28 11:28:05Z

1

Try this:

custName when amount > 10 - $.customers[?(@.itemAmount > 10)].custName

custId when amount > 10 - $.customers[?(@.itemAmount > 10)].custId

answered Dec 28, 2022 at 11:28

hiren

1,1051 gold badge9 silver badges17 bronze badges

Collectives™ on Stack Overflow

Extract data from JSONArray using jsonpath

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related