We built an app that copies files from one column to another when the column changes. We have tested it with bulk column changes, for example, changing the status of 500 items at a time, each having 1 file (i.e., 500 files), and it works fine. We also tested it across multiple accounts and it works.
However, when we submitted it for review, it failed to copy some files during the bulk column change mentioned earlier. We store file information (name, upload status, etc.) and found that the file is failing to upload due to reaching the maximum retry limit (we are retrying the file a maximum of 3 times).
When we asked the app reviewer about the steps and other factors they were considering while testing the app, we discovered they are testing other apps as well.
Since our app copies files from one column to another, it extensively uses the monday.com API (mutation and query). We manage the rate limit and concurrency limit by only uploading 10 files per minute. So why are the files still failing?
Can someone please suggest what we should do to make it work?