Filter nested JSON object using JSONPath with Condition

Question

I have a below json object and need to get only c_Internet child object with a condition where the PIID is having value "1234567".

{
  "OrderComponentInfo": {
    "members": {
      "ADD": {
        "DIA": [
          {
            "c_Internet": {
              "PIID": "1234567",
              "IPv6_Multiple_Path_Needed": ""
            },
            "Test": {
              "PIID": "1234567",
              "INT_Acc_MSP_ID": "",
              "ConnectedService": "INTERNET"
            }
          },
          {
             "c_Internet": {
              "PIID": "7658964",
              "IPv6_Multiple_Path_Needed": ""
            },
            "Test": {
              "PIID": "7658964",
              "INT_Acc_MSP_ID": "",
              "ConnectedService": "INTERNET"
            }
          }
        ]
      }
    }
  }
}

I trued below query but dint work

$..ADD.DIA[?(@.PIID = "1234567")][['c_Internet']]

Thanks in advance.

Serge · Accepted Answer · 2022-09-29 15:32:18Z

2

you have to use c_Internet.PIID not just PIID

const id="1234567";

$..ADD.DIA[?( @.c_Internet.PIID == id )]["c_Internet"]

result

[
  {
    "PIID": "1234567",
    "IPv6_Multiple_Path_Needed": ""
  }
]

edited Sep 29, 2022 at 15:32

answered Sep 14, 2022 at 15:39

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

1 Comment

Hanumantha Over a year ago

How can I pass value "1234567" in variable ? this is not working $..ADD.DIA[?(@.c_Internet.PIID == Id )]["c_Internet"]

Collectives™ on Stack Overflow

Filter nested JSON object using JSONPath with Condition

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related