json-transformation.yaml

#!/usr/bin/env ansible-playbook
- hosts: localhost
  gather_facts: no
  tasks:

    - vars:
        data:
          system:
            df:
              cmd: df -a
            mem:
              cmd: mem
          hw:
            pci:
              cmd: lspci
      debug:
        msg: |
          {{ data | json_query('*.*') }}

# TODO: category (system, hw) must be also added to each dictionary
# TODO: command name (2nd dic key), must be also added to each dicitonary
# TODO: flatten the nested list

# Current output:
# "msg": [
#     [
#         {
#             "cmd": "df -a"
#         },
#         {
#             "cmd": "mem"
#         }
#     ],
#     [
#         {
#             "cmd": "lspci"
#         }
#     ]
# ]

# Desired output:
# - cmd: "df-a"
#   group: system
#   name: df
# ...

# Resources:
# https://jmespath.org/tutorial.html