ForAll Now generating 429 Errors (52 concurrent requests) for users
I have an application that writes batches of rows to a dataverse table. For the past ~7 months, I have not had an issue with the code below:
CollectionSplit As Split,
Patch(datasource,FirstN(SortByColumns(ShowColumns(Filter(collection,Updated = true),
"recordid","columns",...), "cr1c1_field", Split.Sort),Split.RecordCount));
//Removes records from collection to prevent overwriting.
Remove(Collection,FirstN(SortByColumns(Filter(Collection,Updated = true),"cr1c1_field",
The collection I am using as a source for patching the dataverse table has anywhere from 40-150 rows in it. I ran into 429 errors when I would do Patch(datasource,collection). Instead, I decided to break up the patch into 4 operations using the 'CollectionSplit' collection. This resolved the 429s and everything was working great until 4/26. All of the sudden, 429 errors ran rampant and now the app is almost unusable.
I've tried increasing the amount of batches to 6, I've tried doing a ForAll for each record. Interestingly, the ForAll for each record is faster somehow and still results in 429s.