Question 170815 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

How do I select a dict from a list of dicts where key = value in an Ansible playbook?

I’ve seen a few other questions that are similar to my need, however I’m still having a really hard time figuring out how I need to get exactly what I need from this json. Here’s my ansible debug task:
- debug: msg: "{{ foreman_environments.stdout }}"

and here’s the output:

ok: [127.0.0.1] => { "msg": "[{'id': 12, 'name': 'CDE', 'label': 'CDE', 'permissions': {'readable': True}}, {'id': 7, 'name': 'QA3', 'label': 'QA3', 'permissions': {'readable': True}}, {'id': 4, 'name': 'Library', 'label': 'Library', 'permissions': {'readable': True}}, {'id': 6, 'name': 'Development', 'label': 'Development', 'permissions': {'readable': True}}, {'id': 8, 'name': 'Production', 'label': 'Production', 'permissions': {'readable': True}}]" }

I need to essentially capture the ‘id’ value where the ‘name’ key is equal to x. In this exact case I want to get the ID of QA3, but I might need to capture the ID of other environments as well. So I need to take this list of environments and return the value of id where name == some name. Then I need to search for that ID in a different list that contains all the different versions.

Here’s what I’ve tried:

- debug: msg: "{{ foreman_environments.stdout | selectattr('name', 'equalto', 'QA3') | list | last | to_json }}"

and here’s the output I get:

{"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'nnThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but maynbe elsewhere in the file depending on the exact syntax problem.nnThe offending line appears to be:nnn - debug:n ^ heren"}

I need to be able to register the result and then use that registered result to functionally do this same thing but against a different set of data. Can someone help me understand what I’m missing?

EDIT:

I’ve changed my method to use "{{foreman_environments.stdout | selectattr('name', 'equalto', 'QA3') }}" and that returns a generator object. If I try to translate that to a list, though, i get an error:

fatal: [127.0.0.1]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: 'str object' has no attribute 'name'nnThe error appears to be in '/opt/git/ci_cd_ansible/playbook_publish_foreman_view.yml': line 36, column 7, but maynbe elsewhere in the file depending on the exact syntax problem.nnThe offending line appears to be:nnn    - debug:n      ^ heren"}
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Here's the answer I was looking for. Took me all day to get it.

        - name: "collecting ID of QA3"
      command: echo "{{ (content_views.resources[0].environments | selectattr('name', 'equalto', 'QA3') | list | first)['id'] }}"
      register: qa3_foreman_environment_id

    Trying to use .stdout I think is what messed me up. Something about that output format just wasn't working as expected. I just used the original json output and filtered it down to the same chunk then selectattr() worked as expected. I also had to figure out that the parentheses needed to go around the entire statement, but inside of the {{}} in order to get the ['id'] to work.


  2. 0

    The filter json_query gives the same result

      id_qa3: "{{ foreman_environments.stdout|
              json_query('[?name == `QA3`].id')|
              first }}"

    Example of a complete playbook for testing

    shell> cat pb.yml
- hosts: all

  vars:

    foreman_environments:
      stdout:
        - id: 12
          label: CDE
          name: CDE
          permissions: {readable: true}
        - id: 7
          label: QA3
          name: QA3
          permissions: {readable: true}
        - id: 4
          label: Library
          name: Library
          permissions: {readable: true}
        - id: 6
          label: Development
          name: Development
          permissions: {readable: true}
        - id: 8
          label: Production
          name: Production
          permissions: {readable: true}

    id_qa3_a: "{{ foreman_environments.stdout|
                  json_query('[?name == `QA3`].id')|
                  first }}"

    id_qa3_b: "{{ (foreman_environments.stdout|
                  selectattr('name', '==', 'QA3')|
                  first).id }}"

  tasks:

    - debug:
        var: id_qa3_a
    - debug:
        var: id_qa3_b

    gives

    shell> ansible-playbook pb.yml -l test_11

PLAY [all] ************************************************************************************

TASK [debug] **********************************************************************************
ok: [test_11] => 
  id_qa3_a: '7'

TASK [debug] **********************************************************************************
ok: [test_11] => 
  id_qa3_b: '7'

PLAY RECAP ************************************************************************************
test_11: ok=2    changed=0    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search