Simple json_query example with ansible

test-json-query.yml

#!/usr/bin/env ansible-playbook -i localhost,


# Example on how to use json_query as asked by Hagen Bauer (@hbauer)
# https://twitter.com/hbauer/status/1366784668629139458
#
# This requires jmespath python module (pip3 install jmespath).
#
# For further details have a look at:
#
#  - https://jmespath.org/examples.html
#  - https://docs.ansible.com/ansible/latest/user_guide/playbooks_filters.html
#  - https://www.middlewareinventory.com/blog/ansible_json_query/
#
#
# This example is standalone assuming this file is executable. Simply run:
#
#    ./test-json-query.yml
#
# An other version was proposed (https://gist.github.com/jpmens/02568d7dc89a838a59b5295a25a487dc)
# This version does not require any other variable creation.

- hosts: all
  gather_facts: false
  connection: local
  become: false

  vars:

    # Minio configuration
    minio_server:
      - name: server1
        password: xyz
      - name: server2
        password: abc

    # As an example we want server1 password 
    wanted: server1

  tasks:
    - name: get server2 hard-coded version
      debug:
        # String escaping is a mess. Rule of thumb:
        #
        #  * Use simpl quote for the template string
        #  * Use double quote for json_query query string
        #  * Use back quote for string inside query.
        #  * Double simple quotes can also be used for strings inside query
        #
        msg: '{{ minio_server
            | json_query("[? name==''server2''].password | [0]")
            }}'

    - name: get server1 parametric version
      debug:
        msg: '{{ minio_server
            | json_query("[? name==`" + wanted + "`].password | [0]") 
            }}'