Filtering using json_query

Question

I'm trying to extract serial number from below JSON whenever the Disabled value is true.

{
        "CertificateDetails": {
                "Serial": "1234ABCD",
                "SignatureAlgorithm": "sha256RSA"
        },
        "Disabled": true,
        "Guid": "{456767-546566-45676}"
}

Able to retrieve the value of Disabled from below query:

- name: store disabled value
  set_fact:
    Cert_Disabled: "{{ test.json | json_query('Disabled') }}"

However, as per the requirement, I would like to retrieve the Serial number only when Disabled boolean value is true. Tried below query but it isn't giving the desired result.

- name: store disabled value
  set_fact:
    Cert_Disabled: "{{ test.json | json_query('[?Disabled].CertificateDetails.Serial') }}"

β.εηοιτ.βε · Accepted Answer · 2025-11-11 15:54:08Z

2

In JMESPath, filtering can only happen on arrays, not on a single object.

So, you'll need to convert you object to an array first, with an expression using the to_array function:

to_array(@)

Then, you can come back to a simple object, after stopping the projection created by the filter, with the help of the pipe expression:

to_array(@)[?Disabled] | [0]

And finally select the property you want:

to_array(@)[?Disabled] | [0].CertificateDetails.Serial

Which, in this case gives you 1234ABCD but that would give a null if the Disabled field is false.

answered Nov 11 at 15:54

β.εηοιτ.βε

40.3k14 gold badges81 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

Filtering using json_query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related