Best-pratice for HTTP-Request that include pagination

I would like to retrieve all records of a certain API-Endpoint. However, that Endpoint only allows me to fetch a maximum of 100 records. Is there a best practice to get all records, i.e. follow the pagination (which may or may not be according to a pagination standard)

My goal is to run them all through a reformatter and then store the endresult in an Excel Spreadsheet.

That should be no problem. You can simply create a loop (so create a connection back to an earlier node). Just make sure that you build a node which breakes the loop else it will keep on going forever.

Here a simple example:

{
  "nodes": [
    {
      "parameters": {},
      "name": "Other Nodes",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        1200,
        300
      ]
    },
    {
      "parameters": {},
      "name": "Start Loop",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        600,
        300
      ]
    },
    {
      "parameters": {
        "values": {
          "number": [
            {
              "name": "count",
              "value": "={{$node[\"Start Loop\"].data[\"count\"] - 1}}"
            }
          ]
        }
      },
      "name": "Decrement",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        800,
        300
      ]
    },
    {
      "parameters": {
        "conditions": {
          "number": [
            {
              "value1": "={{$node[\"Decrement\"].data[\"count\"]}}",
              "operation": "equal"
            }
          ]
        }
      },
      "name": "Check End",
      "type": "n8n-nodes-base.if",
      "typeVersion": 1,
      "position": [
        1000,
        300
      ]
    },
    {
      "parameters": {
        "values": {
          "number": [
            {
              "name": "count",
              "value": 10
            }
          ]
        }
      },
      "name": "Init Data",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        400,
        300
      ]
    }
  ],
  "connections": {
    "Start Loop": {
      "main": [
        [
          {
            "node": "Decrement",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decrement": {
      "main": [
        [
          {
            "node": "Check End",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check End": {
      "main": [
        [
          {
            "node": "Other Nodes",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Start Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Init Data": {
      "main": [
        [
          {
            "node": "Start Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}