Pagination errors with REST API 3.2

Officially Answered

Follow

New post

Frederic Le Bars

• July 09, 2024 12:59

Hi,

When using the REST API 3.2 with pagination ($count=200,$skip), I get duplicates items in the results and missing ones. Running the same request gives the same results (same duplicates) but if I change the $count (for instance, $count=100), the duplicate items and the missing ones change.

The total item count looks good but it seems than some items are replaced by others.

Regards 

0

• 

  Vanja Pletikosić

  • July 10, 2024 09:54

  Hello Frederic,
  
  Thank you for reaching out to us.
  You will need to specify a value for the $skip command, even if it is to skip zero.
  So when using both $count and $skip, the $count command determines how many rows your query will fetch, and the $skip command determines how many will be skipped before they are fetched.
  So if you are using $count=200, you should use $skip=0 in the first query. Then your second query should have ($count=200, $skip=200), and your third query should have ($count=200,$skip=400).
  
  Please let me know if this helps.
  
  Best regards,
  Vanja

  0

  Comment actions Permalink
• 

  Frederic Le Bars

  • July 10, 2024 12:45

  Hello,

  that is exactly what I am doing:

  

  After some analyzis, I found that the error occurs after a $skip=1200. there are around 20 results duplicated with the $skip=1000.

   

  Best regards,

  Frédéric

  0

  Comment actions Permalink
• 

  Vanja Pletikosić

  • July 10, 2024 14:20

  Hi Frederic,
  
  I have created ticket #60799 for us to further troubleshoot this. Let's continue our communication there.
  
  Best regards,
  Vanja

  0

  Comment actions Permalink

Please sign in to leave a comment.