Hello,
I’m using a workflow scheduled on a list to loop through certain items in an API call that’s stored in DVB and write them to individual cells in the DB. I’d need the workflow to loop through the items in order (hence the scheduling on a list) but i just get jumbled results.
The API output is structured like this:
“items”: [
{
“type”: “organic”,
“rank_absolute”: 1,
“domain”: “xyz”
},
{
“type”: “organic”,
“rank_absolute”: 2,
“domain”: “abc”
},
{
“type”: “organic”,
“rank_absolute”: 3,
“domain”: “123”
},
The problem is that sometimes my DB looks like this:
rank type domain
1 organic xyz
2 organic abc
3 organic 123
And other times it looks like this:
rank type domain
1 organic xyz
3 organic 123
2 organic abc
Or any different possible order really. My guess is that this is due to the workflow just running at the same time for all “items#this number” and then writes to DB in whichever random order it happens to finish.
I’ve tried scheduling the intervals to 5 seconds but it still seems to run all at the same time and in debugging the whole scheduled workflow takes about 1-2 seconds for 10 “rounds” even though that should take 50 seconds due to the interval? Or am i misunderstanding something?
If this is not a bug, help would be greatly apprechiated 