SharePoint capped at 500 records- Data Row Limit for non-delegable queries
So I was busy creating a nice Canvas App using the brilliant Patch command when my records stopped transferring across to SharePoint at exactly 500 records.
Knowing that SharePoint can hold many more entries than this I was slightly confused – on deeper investigation I found the little gremlin blocking my patch commands (File>App Settings>Advanced Settings):
When increasing this limit it allowed my records through. I hope this helps someone out there!!!