I have a workflow that executes a GET Request for multiple rows.
After execution the node adds a column “status” to the table.
Based on the “status” I split the records between successfully and not successfully processed rows.
The issue is, that when the table is empty, the request node does not append the “status” column and the rule-based Row Splitter fails and stops the workflow. What is bad in the overall context. The output should just be empty.
This is how it looks like, if the table is empty:
This is how it looks like for a not empty request, if I define the “status” column up-front:
Can anyone tell me how to get this fixed?
if I got you right after GET Request node you should use Empty Table Switch node which will activate first output port in case of non-empty table and second output port in case of empty table.
I already tried that too, but the problem is, that both branches must stay active, as I write the row count into an CSV file in the next step.
but if table is empty then what count are you writing? Zero? Maybe I don’t fully get it. Is problem when you get empty table after Get Request node or problem is when you don’t get status column in non-empty table or both? Is your goal to always have status column after prior to Rule-based Row Splitter regardless of empty/non-empty table?
i am writing nothin in that case. But I have a chain of cobined steps and if I set one stept to inactive, all the following steps will be inactive too.
Maybe a try catch can help?
having Empty Switch Table node in workflow doesn’t mean you end flow in case there is empty table. You can “simply” design your flow in a way to continue by connecting second output port to nodes which need to run after it. For example End IF can be used. However I don’t know your flow so it might not be this simple as shown in picture:
@ipazin Thanks.That works perfectly.
I never had the idea to use the end if node before.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.