Json Path querying without an array

Question

In the below JSON I am trying to find a condition.Where I want the result only if OrderNumber is not empty or null.

Conditions I have tried. But havent worked for me are:

> $..Item[?(@.OrderNumber)]
> $..Item[?(@.CurrentOrder.OrderNumber)]

Any suggestions will be appreciated. I am testing my queries here https://jsonpath.curiousconcept.com/

{
        "Response": {
            "ID": "123456",
             "Items": {
                "Item": [
                    {                       
                        "CurrentOrder": {
                            "OrderNumber": "123",
                            "Status": ""
                        }
                    }
                ]
            }
        }
    }

If you are using Newtonsoft's JToken.SelectTokens() then this might not be implemented. See JSONPath scripts not executing correctly for objects #1256 and Json.NET JSONPath query not returning expected results. — dbc
– dbc, Commented Mar 16, 2018 at 17:43
Can you provide a minimal reproducible example showing what API you are using? — dbc
– dbc, Commented Mar 16, 2018 at 18:20

CodeFuller · Accepted Answer · 2018-03-16 17:39:30Z

$..Item[?(@.CurrentOrder.OrderNumber)] is the correct JSONPath for your case.

The tool you used is known to not working correctly. See for example this question.

I have test above query with JSONPath Online Evaluator and for JSON

{
    "Response": {
        "ID": "123456",
        "Items": {
            "Item": [
                {
                    "CurrentOrder": {
                        "OrderNumber": "123",
                        "Status": ""
                    }
                },
                {
                    "CurrentOrder": {
                        "OrderNumber": "456",
                        "Status": ""
                    }
                },
                {
                    "CurrentOrder": {
                        "Status": ""
                    }
                }
            ]
        }
    }
}

it gives correct result:

[
  {
    "CurrentOrder": {
      "OrderNumber": "123",
      "Status": ""
    }
  },
  {
    "CurrentOrder": {
      "OrderNumber": "456",
      "Status": ""
    }
  }
]

Collectives™ on Stack Overflow

Json Path querying without an array

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