Get only first/ last row of a node expression

Questions
1

Hi folks

Have a trigger node with more than one table row and want to extract only the first/ last row…

Hope someone can share an example that I can use for that.

Cheers Jakob

2

The example below should do it if I understood well.

{
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "functionCode": "return [\n  {\n    json: {\n       name: 'ricardo'\n    } \n  },\n    {\n    json: {\n       name: 'carlos'\n    } \n  }\n]"
      },
      "name": "Mockup",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        520,
        300
      ]
    },
    {
      "parameters": {
        "functionCode": "return [ { json: items[0].json } ]"
      },
      "name": "Function",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        770,
        300
      ],
      "notesInFlow": true,
      "notes": "Pick first"
    }
  ],
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "Mockup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mockup": {
      "main": [
        [
          {
            "node": "Function",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
4

yeah is cool! Thank you. How can I get the last instead of the first row? Is this also possible?

5

This should work:

return [{ json: items[items.length - 1].json }];

The node JSON:

2 Likes
6

Hey cool, works! Thank you guys!