Microsoft Dynamics CRM Get Many Return all Does not return all

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.
image

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
  • Operating system: Ubuntu

Cheers @BramKn,

I have created NODE-1117 as the internal ticket to fix the pagination. Pull requests are welcome if you have the time :wink:

2 Likes

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.