ansible parse json with several keys with the same name to one list variable

Question

I have an issue to parse a json using ansible I have a task that connected to rancher and get a json file

task:

- uri:
    url: http://rancher.local:8080/v1/hosts
    method: GET
    user: ##################
    password: ################
    body_format: json
  register: hosts_json

- name: test
  set_fact:
    rancher_env_hosts: "{{ item.hostname }}"
  #when: item.hostname == "*-i-*"
  with_items: "{{hosts_json.json.data}}"

- name: output
  debug:
    msg: "hosts: {{rancher_env_hosts}}"

and I get the following json (after edit it to be more readable):

{
    "json": {
        "data": [
            {
                "hostname": "rancher-i-host-02",
                "id": "adsfsa"
            },
            {
                "hostname": "rancher-i-host-01",
                "id": "gfdgfdg"
            },
            {
                "hostname": "rancher-q-host-01",
                "id": "dfgdg"
            },
            {
                "hostname": "rancher-q-host-02",
                "id": "dfgdg"
            }
        ]

    }

}

When I start the playbook I get only the last host name in the variable and not all the list of hostname. can I register all the list to the same variable?

In addition, I also added a line with the a comment "#" in order to get only the host names that match the string "-i-" bit it's not working. any idea?

Is rancher_env_hosts need to be string with comma/space separated values? Or it's need to be array? — Dmitry MiksIr
– Dmitry MiksIr, Commented Nov 9, 2016 at 14:06
Hi @Terra the next thing will be to run task for each hostname woth the ansible so probably array is preferred but maybe I can handle both of them. — dsaydon
– dsaydon, Commented Nov 9, 2016 at 14:16

Konstantin Suvorov · Accepted Answer · 2016-11-09 15:10:47Z

8

This is what filters (and this) for:

- set_fact:
    hosts_all: "{{ hosts_json.json.data | map(attribute='hostname') | list }}"
    hosts_i: "{{ hosts_json.json.data | map(attribute='hostname') | map('regex_search','.*-i-.*') | select('string') | list }}"

host_all will contain all hostnames, host_i will contain only .*-i-.* matching hostnames.

answered Nov 9, 2016 at 15:10

Konstantin Suvorov

68.9k9 gold badges175 silver badges202 bronze badges

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

Comments

Dmitry MiksIr · Accepted Answer · 2024-08-15 13:15:42Z

5

Try this

- uri:
    url: http://rancher.local:8080/v1/hosts
    method: GET
    user: ##################
    password: ################
    body_format: json
  register: hosts_json

- name: init fact
  set_fact:
    rancher_env_hosts: []

- name: test
  set_fact:
    rancher_env_hosts: "{{ rancher_env_hosts + [item.hostname] }}"
  when: item.hostname | search(".*-i-.*")
  with_items: "{{hosts_json.json.data}}"

- name: output
  debug:
    msg: "hosts: {{rancher_env_hosts}}"

About search you can read here http://docs.ansible.com/ansible/playbooks_tests.html

UPD:
About adding values to array here: Is it possible to set a fact of a list in Ansible?

edited Aug 15, 2024 at 13:15

answered Nov 9, 2016 at 14:23

Dmitry MiksIr

4,4851 gold badge20 silver badges31 bronze badges

2 Comments

CularBytes Over a year ago

Did give it a thumbs up for the overall solution, but combining the list doesn't seem to give good results. I get something like hosts: [] + [ rancher-i-host-02 ] in the debug msg output. So it's really just appending strings

CularBytes Over a year ago

To solution to above comment is to initiate the list with [] (so no "[]") and then when appending: rancher_env_hosts: "{{ rancher_env_hosts + [ item.hostname ] }}" Not sure if that is valid in all versions of ansible..

Collectives™ on Stack Overflow

ansible parse json with several keys with the same name to one list variable

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related