HI @sduplessis
Your first instinct is correct. YOu should limit the number of records because it's a lot.
Have you checked if the API has limits on the Service Now part?
I would proceed with the batching. You can get the full amount of records, break them down into smaller chunks in Power Automate and then send them to Service Now.
Can you please check if and let me know if you have any questions?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel