How to retrieve all executions data of a node?

[Kakulukian]

Hello,
I began to use n8n in order to generate some KPI reports over Stripe API.
I manage to handle Stripe pagination but I have struggle to return merged data of my HTTP request node executions.
I used $items(‘My node’) which should return all the data of the different execution for a node according to the doc but it seems not working, may be it’s not the right way to use it.
Can you give me us some hints how to merge all execution data of a specific node?

Here my workflow, if it helps to understand:

{
  "name": "KPI Stripe",
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "triggerTimes": {
          "item": [
            {
              "hour": 23
            }
          ]
        }
      },
      "name": "Cron",
      "type": "n8n-nodes-base.cron",
      "typeVersion": 1,
      "position": [
        470,
        160
      ]
    },
    {
      "parameters": {
        "functionCode": "const d = new Date();\nd.setUTCHours(0,0,0,0);\nconst startTS = Math.round(d.getTime() / 1000);\nd.setUTCHours(23,59,59,59);\nconst endTS = Math.round(d.getTime() / 1000);\nreturn [{json: {startTS, endTS}}];"
      },
      "name": "Timestamp",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        680,
        160
      ]
    },
    {
      "parameters": {
        "conditions": {
          "boolean": [
            {
              "value1": "={{$node[\"Retrieve Stripe Charges\"].json[\"has_more\"]}}",
              "value2": true
            }
          ]
        }
      },
      "name": "Pagination Stripe Charge",
      "type": "n8n-nodes-base.if",
      "typeVersion": 1,
      "position": [
        700,
        -260
      ]
    },
    {
      "parameters": {
        "authentication": "basicAuth",
        "url": "https://api.stripe.com/v1/charges",
        "options": {},
        "headerParametersUi": {
          "parameter": []
        },
        "queryParametersUi": {
          "parameter": [
            {
              "name": "limit",
              "value": "100"
            },
            {
              "name": "created[lte]",
              "value": "={{$node[\"Timestamp\"].json[\"endTS\"]}}"
            },
            {
              "name": "={{$node[\"Next ID\"].json[\"nextID\"]? 'starting_after' : ''}}",
              "value": "={{ $node[\"Next ID\"].json[\"nextID\"]  ? $node[\"Next ID\"].json[\"nextID\"] : '' }}"
            },
            {
              "name": "created[gte]",
              "value": "={{$node[\"Timestamp\"].json[\"startTS\"]}}"
            }
          ]
        }
      },
      "name": "Retrieve Stripe Charges",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 1,
      "position": [
        940,
        140
      ],
      "credentials": {
        "httpBasicAuth": "Stripe"
      }
    },
    {
      "parameters": {
        "keepOnlySet": true,
        "values": {
          "string": [
            {
              "name": "nextID",
              "value": "={{ $node[\"Pagination Stripe Charge\"].json[\"data\"][$node[\"Pagination Stripe Charge\"].json[\"data\"].length - 1][\"id\"] }}"
            }
          ]
        },
        "options": {}
      },
      "name": "Next ID",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        970,
        -550
      ]
    },
    {
      "parameters": {
        "functionCode": "return $items(\"Retrieve Stripe Charges\");"
      },
      "name": "Merged Charges",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1260,
        -240
      ]
    }
  ],
  "connections": {
    "Cron": {
      "main": [
        [
          {
            "node": "Timestamp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Timestamp": {
      "main": [
        [
          {
            "node": "Retrieve Stripe Charges",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pagination Stripe Charge": {
      "main": [
        [
          {
            "node": "Next ID",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merged Charges",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve Stripe Charges": {
      "main": [
        [
          {
            "node": "Pagination Stripe Charge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Next ID": {
      "main": [
        [
          {
            "node": "Retrieve Stripe Charges",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "timezone": "Europe/Paris",
    "saveManualExecutions": true
  },
  "id": "9"
}

[jan]

Welcome to the community @Kakulukian!

The problem is that the node does not have multiple items it has multiple runs. So you have to iterate over them instead. Here an example how you can do that:

[Kakulukian]

Thanks for your answer
I came with a solution pretty similar but it iterates over last runIndex of the node, your solution works pretty well too!
Keep up the good work on n8n, can’t wait discover more features

[jan]

Ah great to hear that you also found a solution.

Have fun!

[dickhoning]

Awesome! Helped me to collect all possible errors into one output/result file