# Create a JSON to use inside another JSON \[send to API node\]

**URL:** <https://community.parabola.io/t/create-a-json-to-use-inside-another-json-send-to-api-node/1597>\
**Category:** Ask a question\
**Tags:** Using-APIs\
**Created:** [February 24, 2021, 10:23pm UTC](https://community.parabola.io/t/create-a-json-to-use-inside-another-json-send-to-api-node/1597 "2021-02-24T22:23:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![reuben](https://avatars.discourse-cdn.com/v4/letter/r/54ee81/32.png) [@reuben](https://community.parabola.io/u/reuben)\
**Post date:** [February 24, 2021, 10:23pm UTC](https://community.parabola.io/t/create-a-json-to-use-inside-another-json-send-to-api-node/1597/1 "2021-02-24T22:23:01Z")

</div>

Hi! Let’s see if someone can help me. I am calling an API that creates a Sals order. Inside that sales order I need to include the list of “items” in the order.

The API call looks like this.

```auto
Order data
Order data
-- Items
--- item 1 data
----- item data
----- item data
--- item 2 data
----- item data
Order data.

```

Is there any way to generate the “item” part of the API call in another node and then add it to the “send to API node”?

Hope this makes any sense.

Any help will be appreciated!  
Thanks!

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [February 25, 2021, 1:14am UTC](https://community.parabola.io/t/create-a-json-to-use-inside-another-json-send-to-api-node/1597/2 "2021-02-25T01:14:03Z")

</div>

Hi @reuben 👋

If I understand you correctly, are you trying to merge all of your items into a single row grouped by order? If so, check [this post](https://community.parabola.io/t/create-an-array-from-table-values/1554) by another Parabola user.

The “Insert Text Column” step can be used to format each `item` as a JSON object in a single row. The “Merge duplicate rows” step can be used to merge the items together and group them by a unique identifier.

In your case, you may be able to use a unique `Order Id` or `Order Name` to group your items. Your final JSON might look like this:

```auto
Order data
Order data
  "items": [
    {Merged Items Column}
  ]
Order data

```

---

<div class="post-metadata">

**Author:** ![reuben](https://avatars.discourse-cdn.com/v4/letter/r/54ee81/32.png) [@reuben](https://community.parabola.io/u/reuben)\
**Post date:** [February 25, 2021, 1:43am UTC](https://community.parabola.io/t/create-a-json-to-use-inside-another-json-send-to-api-node/1597/3 "2021-02-25T01:43:04Z")

</div>

very interesting, I will test it out! Thanks a lot!