How to Insert array inside JSON object?

Question

I have a json file that I need to reformat - insert array around some of the nested objects.

It looks like that:

    {
      "test": {
        "UserData": "test",
        "password": "123"
      },
      "test2": {
        "UserData": "test2",
        "password": "123"
      },
      "test3": {
        "UserData": "test3",
        "password": "123"
      }
   }

And I need it to look like that:

    {
      "test": [{
        "UserData": "test",
        "password": "123"
      }],
      "test2": [{
        "UserData": "test2",
        "password": "123"
      }],
      "test3": [{
        "UserData": "test3",
        "password": "123"
      }]
    }

I'm using Ansible, jq and bash.

Vladimir Botka · Accepted Answer · 2022-08-01 11:42:46Z

^{Given the data
d1:
test:
UserData: test
password: '123'
test2:
UserData: test2
password: '123'
test3:
UserData: test3
password: '123'}

Convert the dictionaries to the first items in the lists. For example

  d2_query: '[].[key, [value]]'
  d2: "{{ dict(d1|dict2items|json_query(d2_query)) }}"

gives

  d2:
    test:
    - UserData: test
      password: '123'
    test2:
    - UserData: test2
      password: '123'
    test3:
    - UserData: test3
      password: '123'

^{Example of a complete playbook for testing
- hosts: localhost
vars:
d1:
test:
UserData: test
password: '123'
test2:
UserData: test2
password: '123'
test3:
UserData: test3
password: '123'
d2_query: '[].[key, [value]]'
d2: "{{ dict(d1|dict2items|json_query(d2_query)) }}"
tasks:
- debug:
var: d2}

pmf · Accepted Answer · 2022-08-01 11:57:42Z

2

Using jq: Select each field of the object with .[], and update it |= to itself wrapped in an array [.].

jq '.[] |= [.]' file.json

{
  "test": [
    {
      "UserData": "test",
      "password": "123"
    }
  ],
  "test2": [
    {
      "UserData": "test2",
      "password": "123"
    }
  ],
  "test3": [
    {
      "UserData": "test3",
      "password": "123"
    }
  ]
}

Demo

answered Aug 1, 2022 at 11:57

pmf

38.3k3 gold badges31 silver badges41 bronze badges

1 Comment

Frenchy Over a year ago

jq is great tool used with shell module, but the problem is shell module is not idempotent

Frenchy · Accepted Answer · 2022-08-01 11:51:49Z

you could use this playbook (using dict2items and combine):

- name: "tips4"
  hosts: localhost
  vars:
    json1:
      test:
        UserData: test
        password: '123'
      test2:
        UserData: test2
        password: '123'
      test3:
        UserData: test3
        password: '123'   
  tasks:
    - name: set var 
      set_fact:
        newjson: "{{newjson|d({})|combine({item.key:[item.value]}) }}"
      loop: "{{ json1|dict2items }}"

    - name: disp result
      debug:
        msg: "{{ newjson }}"

result:

ok: [localhost] => {
    "msg": {
        "test": [
            {
                "UserData": "test",
                "password": "123"
            }
        ],
        "test2": [
            {
                "UserData": "test2",
                "password": "123"
            }
        ],
        "test3": [
            {
                "UserData": "test3",
                "password": "123"
            }
        ]
    }
}

Collectives™ on Stack Overflow

How to Insert array inside JSON object?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related