# Trying to get pagenation working **URL:** \ **Category:** Questions\ **Created:** [March 28, 2024, 1:39pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366 "2024-03-28T13:39:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [March 28, 2024, 1:39pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/1 "2024-03-28T13:39:58Z")
## Describe the problem/error/question Getting pagination to work after a set field ## What is the error message (if any)? ERROR: Bad request - please check your parameters 400 - “{"error":"invalid value for Integer(): \"\""}” When i hardcode the page number to a URL or Query param, it works, however when i use an expression that changes the number dynamically, it never works, but the page number shows correctly in green ---
**Author:** ![n8n](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/n8n/32/196425_2.png) [@n8n](https://community.n8n.io/u/n8n)\ **Post date:** [March 28, 2024, 1:39pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/2 "2024-03-28T13:39:59Z")
It looks like your topic is missing some important information. Could you provide the following if applicable. - **n8n version:** - **Database (default: SQLite):** - **n8n EXECUTIONS\_PROCESS setting (default: own, main):** - **Running n8n via (Docker, npm, n8n cloud, desktop app):** - **Operating system:** ---
**Author:** ![bartv](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/bartv/32/156374_2.png) [@bartv](https://community.n8n.io/u/bartv)\ **Post date:** [March 28, 2024, 1:40pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/3 "2024-03-28T13:40:32Z")
Can you share the workflow? ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [March 28, 2024, 2:07pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/4 "2024-03-28T14:07:45Z")
![image](https://europe1.discourse-cdn.com/n8n/original/3X/6/1/61aec787f35479683b770cd0f046197d51c8bf82.png) ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [March 28, 2024, 2:10pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/5 "2024-03-28T14:10:12Z")
Hi, share it like an image. so when i see the URL with the expression, it looks correct, so i am expecting the endpoint to be [api.com](http://api.com)&page={{expression}} the preview of the URL shows with the number 2, which is what i am expecting But it is not working, but same thing happens when i hardcode it with 2 it works ![image](https://europe1.discourse-cdn.com/n8n/original/3X/a/7/a7ed9f8a1a2aab669354d92ae233cb4f38adf459.png) so for example, the above images do not work even though the page parameter shows correct, but hard-coding des, i have spent ages on this, and i almost give up. ---
**Author:** ![liam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/liam/32/34968_2.png) [@liam](https://community.n8n.io/u/liam)\ **Post date:** [March 28, 2024, 10:04pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/6 "2024-03-28T22:04:58Z")
Have you tried using the pagination feature built into the http request? Please click into this node and see the pagination configuration. This will return the same thing as shown in your screenshot and automatically increment it for each request. We also can not see your code in the screenshot so we can’t really help you unless we see what the code block is doing. Either way, I would recommend using the built in pagination feature. If you’re still having trouble after that please [embed your workflow](https://www.youtube.com/watch?v=yGD7-RKFRb0) in your next reply instead of using a screenshot ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [March 29, 2024, 5:34am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/7 "2024-03-29T05:34:07Z")
I have tried everything possible under the sun. This is something basic that should work, but it does not. I first started with the pagination. I keep getting a timeout error. I was a bit hesitant to copy and paste the node JSON as it was going to expose my auth code, i could take it out, but i am not sure what else i need to take out before i post it publically. Could i email you directly so that i don’t post this publically ![Screen Shot 2024-03-29 at 10.36.26 AM](https://europe1.discourse-cdn.com/n8n/original/3X/c/9/c97a9f7ec41d4b4119ef1c20344b60c74ea0aafa.png) ---
**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\ **Post date:** [March 29, 2024, 2:48pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/8 "2024-03-29T14:48:42Z")
Is not what the error message says actually the case? That you are pulling so much data that n8n crashes? Maybe set max pages to something low like 5 and see if that works. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [March 30, 2024, 10:49am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/9 "2024-03-30T10:49:28Z")
I am pretty sure that is not the case. The same happens even when i try 2 pages. It just keeps spinning and spinning. If 500 records are fetched per page then there is only 5 pages in total anyways ---
**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\ **Post date:** [March 30, 2024, 2:37pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/10 "2024-03-30T14:37:22Z")
We then talk about 2.5k records. No idea how much memory your instance has but depending on that and how much memory your instance has does it still sound reasonable. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [April 1, 2024, 3:50am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/11 "2024-04-01T03:50:25Z")
I am not sure if this is a memory issue because even if i just put in 2 pages, it does not work. Whenever i hard code the page number, it seems to work really fast, i am using the 20$ hosted plan, if that makes any difference. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [April 1, 2024, 2:26pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/12 "2024-04-01T14:26:53Z")
Ok, i finally got this to work, not sure what i did differently. I set it to retrieve only three pages, and now it shows returned three items It is supposed to show 500 per page, and i can not see past the 500, is there a way to jump to the next item? because i can not seem to access the records after 500 So 1 item should contain 0-499, so on and so forth ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [April 9, 2024, 6:29am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/13 "2024-04-09T06:29:42Z")
Hi 👋🏻 still staying to get a response on my last question Thanks 🙏🏻 Anto ---
**Author:** ![bartv](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/bartv/32/156374_2.png) [@bartv](https://community.n8n.io/u/bartv)\ **Post date:** [April 18, 2024, 2:19pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/14 "2024-04-18T14:19:40Z")
Would you be able to share a (simplified) version of your workflow here? That’ll help us understand better what’s happening here. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [April 18, 2024, 3:52pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/15 "2024-04-18T15:52:56Z")
Dear Bart, it baffles me that something so simple is not achievable on this platform, i don’t think we can solve this via text or email, i would need to send you a video of what i am facing. There is a lot of private info of sdtudets that i don’t want anyone else to see. I really don’t think i can continue paying 20$ a month if something as simple as this can not be solved. ---
**Author:** ![bartv](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/bartv/32/156374_2.png) [@bartv](https://community.n8n.io/u/bartv)\ **Post date:** [May 7, 2024, 7:40am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/16 "2024-05-07T07:40:41Z")
You can post a video here, no problem. Also, you’ll need to share an actual (simplified) workflow here if you want us to be able to really dig in - not just screenshots. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [May 7, 2024, 10:11am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/17 "2024-05-07T10:11:47Z")
dude, your support continues to baffle me, i dont believe i am paying 20$ per month for this, am i not entitled to support ? my concern was if i post the video here will anyone be able o see this ? or just you ? the video will contain personal info that i do not want to share. I can belive your lack of communctionc skills and made this simple issue one of the most resolvable things in the world. I hope you dont take another week to respond to this ? ---
**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\ **Post date:** [May 7, 2024, 10:45am UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/18 "2024-05-07T10:45:20Z")
Hey @Antony_Rappai, Can you share a link for the API docs for the service you are using and can you also share the JSON data for the HTTP Request node? Looking at the posts here I suspect the HTTP Request node has either not been correctly configured following whatever options it is that the API you are using expects or the n8n instance you are using is running out of memory and you will need to handle the data in smaller batches. As for support the Starter plan of n8n cloud comes with Community Support only which happens here on the forum, While we try to answer everything sometimes things will through the gaps and we are working on ways to prevent more issues like that from happening. We also need to prioritise questions we get based on if it is likely to be a bug, a configuration issue or a general workflow building question, It also very much helps if all of the questions we ask get answered as they will help us find the answer for you. ---
**Author:** ![Antony\_Rappai](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/antony_rappai/32/35608_2.png) [@Antony\_Rappai](https://community.n8n.io/u/Antony_Rappai)\ **Post date:** [May 18, 2024, 3:01pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/19 "2024-05-18T15:01:33Z")
Dear team, i was able to pull the data using the correct pagination sucessfully, but what i am simply asking is hopefully explained on this screenshot. Thanks for helping in advance ![image](https://europe1.discourse-cdn.com/n8n/original/3X/e/e/eec0b8de3189c6d22c679745f7317eaff542f016.jpeg) ---
**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\ **Post date:** [August 16, 2024, 3:02pm UTC](https://community.n8n.io/t/trying-to-get-pagenation-working/43366/20 "2024-08-16T15:02:29Z")
Closed on August 16, 2024, 3:02pm UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.