Microsoft Dynamics CRM node does not return all values when setting it to get many and then turning on Return All. It returns 100, while there are a lot more.
And the limit with the GET request we can only set to 10.
Information on your n8n setup
n8n version: 1.25.1
Database (default: SQLite): Postgres
Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
I’ve run into similar issues with pagination in Microsoft Dynamics CRM, and it can be pretty frustrating when you’re expecting to retrieve all records but only get a partial set. It’s great that you’ve already created an internal ticket for NODE-1117! When I was dealing with a similar problem in a previous project, we had to manually tweak some API settings to make sure the pagination was handled correctly. It took a bit of trial and error, but eventually, it worked out. If you’re looking for a workaround, I’d suggest checking the request limits and the “top” parameter to adjust the number of records returned. By the way, I was working with www.fieldboss.cоm/industries/hvac/ software recently, and they had a really smooth integration for managing job data, which helped avoid issues like this.