Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
Hi Stachu ,
Thank you for your reply!
It is how I fixed the issue before, thank you for pointing out "the why".
Regards,
RObbe
glad to help, have a good day 🙂