JsonPath Conditionals Nested Two Arrays Deep

Question

I'm trying to return the full parent object when the url = 'www.fruits.com'

Below is the json schema. It's quite tricky

{
  "produce": [
    {
      "type": "fruit",
      "upc": {
        "code": {
          "codingList": [
            {
              "item": "apple",
              "organizations": [
                {
                  "url": "www.fruits.com"
                }
              ]
            }
          ]
        }
      }
    },
    {
      "type": "fruit",
      "upc": {
        "code": {
          "codingList": [
            {
              "item": "tomato",
              "organizations": [
                {
                  "url": "www.special-fruits.com"
                }
              ]
            }
          ]
        }
      }
    }
  ]
}

Any help would be much appreciated.

i've tried several different method on jsonpath.com but have not been able to crack it.

By "full parent object", do you mean you want { "produce": ... } or do you want the item in the parents array? — gregsdennis
– gregsdennis, Commented Nov 6, 2023 at 4:28

gregsdennis · Accepted Answer · 2023-11-06 04:37:10Z

1

Conditionally returning the root value isn't supported in JSON Path. The only way to get the root is with the path $, which doesn't allow conditions.

Assuming that you mean that you want the items in the parents that have a url with value www.fruits.com, you can use this:

$.produce[?(@..[?(@.url == 'www.fruits.com')])]

You can test this on https://json-everything.net/json-path, which implements the upcoming IETF spec for JSON Path.

https://jsonpath.com/ doesn't seem to support @ very well. It appears that it requires a subquery, e.g. @.foo.

answered Nov 6, 2023 at 4:37

gregsdennis

8,5206 gold badges43 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

JsonPath Conditionals Nested Two Arrays Deep

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related