To give you a little bit of context, I’m trying to build a B2B E-commerce (Private- just for my customers) platform, where I want o display the items I have in stock, so my customers can place an order.
The challenge that I’m having right now is to keep my inventory up to date without having to do it from my development app data bulk modify. I need the internal user (administrator) to be able to do it just by clicking a button.
Therefore, I schedule an API Workflow on a list which gets data from an external API (Airtable Plugin) from a table that contains the item number and the stock and it works well. However, since I’m trying to update 4+ rows of data (And this number will increase), I’m running into capacity issues. Most of the times the application either freezes or stops/times out halfway through
Subsequently, I believe scheduling an API workflow recursively will solve the capacity issue. The user will be able to continue working without having to wait until the whole 4k+ rows of data are updated, praying the app won’t crash, while the inventory is being updated in the back.
I’ve set the recursive API Workflow following this recommendation but it hasn’t work.
Here you have screenshots of how I set it up:
Step 1) Schedule an API workflow “Inventoryupdatetest” when a button is clicked. Make changes to a thing. I created a date field to record the date and time it is updated, to be able to constraint those things that have been updated already. (See screenshot above)
Step 2) Schedule the same API Workflow “Inventoryupdatetest”(LOOP). With condition. Only when Things last_process < current date/time +(days): -3 (See screenshot above)
However, when I run test and check on the server logs, it says action condition failed in step 2.
If any one could give me a hand or point to me what I’m missing I’ll be so grateful.