# JSONata retrieve child objects

**URL:** https://discourse.nodered.org/t/jsonata-retrieve-child-objects/58867
**Category:** General
**Created:** [23 February 2022 10:06 UTC](https://discourse.nodered.org/t/jsonata-retrieve-child-objects/58867 "2022-02-23T10:06:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Imo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/imo/32/57224_2.png) [@Imo](https://discourse.nodered.org/u/Imo)
#### Post date: [23 February 2022 10:06 UTC](https://discourse.nodered.org/t/jsonata-retrieve-child-objects/58867/1 "2022-02-23T10:06:24Z")

</div>

Hi all, please help. I am new in jsonata. How can I modify this:

```auto
{
    "store": {
         "abc1": {
                "category": "reference",
                "author": "Nigel Rees",
                "title": "Sayings of the Century",
                "price": 8.95
            },
           "dfc2" : {
                "category": "fiction",
                "author": "Evelyn Waugh",
                "title": "Sword of Honour",
                "price": 12.99
            }
    },
    "store3": {
        "abc3": {
              "category": "reference",
              "author": "Nigel Rees",
              "title": "Sayings of the Century",
              "price": 8.95
          },
          "dfc4" : {
              "category": "fiction",
              "author": "Evelyn Waugh",
              "title": "Sword of Honour",
              "price": 12.99
          }
  }
}

```

to have something like that

```auto
  "abc1": {
                "category": "reference",
                "author": "Nigel Rees",
                "title": "Sayings of the Century",
                "price": 8.95
            },
           "dfc2" : {
                "category": "fiction",
                "author": "Evelyn Waugh",
                "title": "Sword of Honour",
                "price": 12.99
            },
           "abc3": {
              "category": "reference",
              "author": "Nigel Rees",
              "title": "Sayings of the Century",
              "price": 8.95
          },
          "dfc4" : {
              "category": "fiction",
              "author": "Evelyn Waugh",
              "title": "Sword of Honour",
              "price": 12.99
          }

```

Thanks in advance

---

<div class="post-metadata">

### Author: ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [23 February 2022 10:46 UTC](https://discourse.nodered.org/t/jsonata-retrieve-child-objects/58867/2 "2022-02-23T10:46:43Z")

</div>

try

```auto
$merge($$.payload.*)

```

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [24 April 2022 10:47 UTC](https://discourse.nodered.org/t/jsonata-retrieve-child-objects/58867/3 "2022-04-24T10:47:40Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
