SharepointAPI error

[RobbeVL]

HI All,

Recently, I've been encoutnering some problems connecting to the Sharepoint API.
The search API limits to pull 500 records at a time, so I'm working with an offset of 500. 

Whenever the amount of records is exacly 500 or a multiply of that, I seem to get an error. If I then manually change this offset , it can continue. 

How do I work around this issue? 

[Stachu · Accepted solution]

What error do you get? What changes to offset do you make to make it work?

EDIT it seems to be related to the index starting at 0 and not 1. if you have 1500 records starting with 0 the last index should be 1499, and your List.Generate in Offset will also generate 1500

Adjust 

Offset = List.Generate(()=>0, each _ <= Number.RoundTowardZero

to

Offset = List.Generate(()=>0, each _ < Number.RoundTowardZero

 and it should work

[RobbeVL]

Hi Stachu ,

Thank you for your reply!
It is how I fixed the issue before, thank you for pointing out "the why".

Regards,

RObbe

[Stachu]

glad to help, have a good day 🙂