HTTP Request vs redmine

[tokenring]

Hello everyone!
Could you please advise on how to retrieve user data from Redmine using an HTTP request?
The issue is as follows: in an HTTP request for Redmine, it’s possible to specify a limit for the number of returned records with a query like https://redmine.server/users.json?limit= {{ $json.limit }}&offset={{ $json.offset }}. However, even if the limit is set to 10000, only 100 records will be returned.
I need to iterate through all records (which is implemented in a loop) and ultimately collect them into a single variable, which I will then sort accordingly.

Information on your n8n setup

• **n8n version: 1.93.0 **
• **Database (default: SQLite): postgres **
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• **Running n8n via (Docker, npm, n8n cloud, desktop app): docker **
• **Operating system: linux **

[Franz]

Have you tried to use the pagination feature of the HTTP node?
Easy to implement and easy to use.

Here is a small example with the pokeapi.

To help you with it, please share the HTTP response. It would be best to “pin” the data in the HTTP node (using the pin icon in the top right corner) and then post the workflow or the node as a comment.

[tokenring]

Output data in http_request node
i try pagination but idk what parameter to use (offset not working)

https://redmine.server/users.json?limit=3&offset={{ $json.offset }}

[
  {
    "users": [
      {
        "id": 1,
        "login": "admin",
        "admin": true,
        "firstname": "Redmine",
        "lastname": "Admin",
        "mail": "[email protected]",
        "created_on": "2025-05-27T07:28:51Z",
        "updated_on": "2025-05-27T07:36:26Z",
        "last_login_on": "2025-05-27T07:36:13Z",
        "passwd_changed_on": "2025-05-27T07:36:26Z",
        "twofa_scheme": null
      },
      {
        "id": 5,
        "login": "test",
        "admin": false,
        "firstname": "test",
        "lastname": "test",
        "mail": "test@test",
        "created_on": "2025-05-27T07:37:02Z",
        "updated_on": "2025-05-27T07:37:02Z",
        "last_login_on": null,
        "passwd_changed_on": "2025-05-27T07:37:02Z",
        "twofa_scheme": null
      },
      {
        "id": 6,
        "login": "test2",
        "admin": false,
        "firstname": "test2",
        "lastname": "test2",
        "mail": "test2@test",
        "created_on": "2025-05-27T07:38:00Z",
        "updated_on": "2025-05-27T07:38:00Z",
        "last_login_on": null,
        "passwd_changed_on": "2025-05-27T07:38:00Z",
        "twofa_scheme": null
      }
    ],
    "total_count": 3,
    "offset": 0,
    "limit": 3
  }
]

[tokenring]

Solution. Tested. Worked. Plz add tags ‘redmine’ for all ppl

[darrell_tw]

@tokenring

However, even if the limit is set to 10000, only 100 records will be returned.

Yes the hard limit is 100.

Can not just set to 10000.

---

To get all the record. Maybe use $runIndex might a good help