How to get the full raw JSON output from a node into a single item?

Questions
, ,
#1

Hey,

I’m getting a JSON output from a Notion node — getting full content of the blocks in a Notion page — and I want to be able to group the full raw JSON under a single object so I can POST it through the HTTP Request node.

Any help will be truly appreciated.

Thanks beforehand.

Demo JSON

[
  {
    "object": "page",
    "id": "03d526ba-8c71-4e6d-b6c6-9fa8493b7ed5",
    "created_time": "2022-11-03T09:29:00.000Z",
    "last_edited_time": "2022-11-07T10:37:00.000Z",
    "created_by": {
      "object": "user",
      "id": "4ef20010-e89c-425e-9caa-08d2bd1f3c65"
    },
    "last_edited_by": {
      "object": "user",
      "id": "817a044a-f00d-4f22-9b9e-e698dd4b911e"
    },
    "cover": null,
    "icon": {
      "type": "emoji",
      "emoji": "🎭"
    },
    "parent": {
      "type": "database_id",
      "database_id": "3f9f0621-dabc-4f0a-a6db-cb7e63a3f067"
    },
    "archived": false,
    "properties": {
      "Date": {
        "id": "tlC_",
        "type": "date",
        "date": {
          "start": "2021-03-29",
          "end": null,
          "time_zone": null
        }
      },
      "Headline": {
        "id": "title",
        "type": "title",
        "title": [
          {
            "type": "text",
            "text": {
              "content": "Demo content — A",
              "link": null
            },
            "annotations": {
              "bold": false,
              "italic": false,
              "strikethrough": false,
              "underline": false,
              "code": false,
              "color": "default"
            },
            "plain_text": "Demo content — A",
            "href": null
          }
        ]
      }
    },
    "url": "https://www.notion.so/demo-url-1"
  },
  {
    "object": "page",
    "id": "08beb9f4-9f24-4092-bcab-74da867bdd79",
    "created_time": "2022-11-03T09:29:00.000Z",
    "last_edited_time": "2022-11-07T10:35:00.000Z",
    "created_by": {
      "object": "user",
      "id": "4ef20010-e89c-425e-9caa-08d2bd1f3c65"
    },
    "last_edited_by": {
      "object": "user",
      "id": "4ef20010-e89c-425e-9caa-08d2bd1f3c65"
    },
    "cover": null,
    "icon": {
      "type": "emoji",
      "emoji": "🧩"
    },
    "parent": {
      "type": "database_id",
      "database_id": "3f9f0621-dabc-4f0a-a6db-cb7e63a3f067"
    },
    "archived": false,
    "properties": {
      "Date": {
        "id": "tlC_",
        "type": "date",
        "date": {
          "start": "2022-05-27",
          "end": null,
          "time_zone": null
        }
      },
      "Headline": {
        "id": "title",
        "type": "title",
        "title": [
          {
            "type": "text",
            "text": {
              "content": "Demo content — B",
              "link": null
            },
            "annotations": {
              "bold": false,
              "italic": false,
              "strikethrough": false,
              "underline": false,
              "code": false,
              "color": "default"
            },
            "plain_text": "Demo content — B",
            "href": null
          }
        ]
      }
    },
    "url": "https://www.notion.so/demo-url-2"
  },
  {
    "object": "page",
    "id": "3bb557fe-fde8-4bdf-83f0-591567ccda5d",
    "created_time": "2022-11-03T09:29:00.000Z",
    "last_edited_time": "2022-11-04T07:26:00.000Z",
    "created_by": {
      "object": "user",
      "id": "4ef20010-e89c-425e-9caa-08d2bd1f3c65"
    },
    "last_edited_by": {
      "object": "user",
      "id": "1aeabc4f-6585-4108-bf70-66ab01a667ff"
    },
    "cover": null,
    "icon": {
      "type": "emoji",
      "emoji": "📷"
    },
    "parent": {
      "type": "database_id",
      "database_id": "3f9f0621-dabc-4f0a-a6db-cb7e63a3f067"
    },
    "archived": false,
    "properties": {
      "Date": {
        "id": "tlC_",
        "type": "date",
        "date": {
          "start": "2021-02-14",
          "end": null,
          "time_zone": null
        }
      },
      "Headline": {
        "id": "title",
        "type": "title",
        "title": [
          {
            "type": "text",
            "text": {
              "content": "Demo content — 3",
              "link": null
            },
            "annotations": {
              "bold": false,
              "italic": false,
              "strikethrough": false,
              "underline": false,
              "code": false,
              "color": "default"
            },
            "plain_text": "Demo content — 3",
            "href": null
          }
        ]
      }
    },
    "url": "https://www.notion.so/demo-url-3"
  }
]
#2

Hi @Mike_M

Are you looking for the aggregate functionality of the item lists node?

#3

Hey @BramKn, thanks for your quick reply!

Not exactly.

When I try to map the whole JSON output from another node I can only map specific objects to a field as an expression.

Specifically, my question is, how can I map the whole JSON output from another node to a field as an expression?

#4

Hi @Mike_M

simply remove the fields it names when dragging the value in, resulting in:

{{$json}}
2 Likes
#5

Thanks a lot!

2 Likes
#6

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