I’ve gotten my application to work completely using the Schedule API Workflow on a List function but the problem is if the list is any greater than 150 items, the app crashes. I did try adding the 3 units of capacity for an hour to see how the app behaved and it could handle up to about 400 items but it’s still not nearly efficient enough.
Has anyone figured out a work-around for this? I contemplated finding a third-party service that will take my .CSV, parse the data and then return it to my app via API but I am having a hard time finding a service that can accept a CSV dynamically via URL that has this capability. Do you guys know of anything like this?
I think the problem could be solved by buying like 15 units of capacity, but that’s extremely expensive so an alternative solution is needed during the start-up phase of my project.
It seems that the scheduling itself is what causes the crash, I set the schedule to be Current Date/Time + 60 Seconds to ensure it didn’t start in the background before the scheduling had finished but it takes much longer than 60 seconds and ultimately crashes just for scheduling the workflows. I didn’t think scheduling workflows would be so hard on the system but apparently there’s something at play here that I am not seeing.