Hi @narayanan,
thanks for the workflow! I suggest there are two parts to it:
- Find out which workflows (and their versions!) contains SAP connectivity that are already existing on your Hub.
- Find out if a newly uploaded or modified workflow contains such connectivity.
For 1.: That can get quite resource-intensive, as yes, each workflow needs to be loaded to get the node configurations (which does not execute, but might take a while, depending on the size of the workflow to be loaded). You’d probably also need to consider workflow (and component) versions – people might have removed a connection. Luckily, we have some components that can assist there. On the positive side: We can get filter all workflows by the relevant nodes first, before doing the expensive workflow loading. I uploaded an example that does all that here:
From there, you’d need to evaluate the node settings that are relevant for you and then decide on an action. I’d also recommend to write out partial successes in the loop, e.g. by appending to a excel file, in case something goes wrong at some point.
For a solution for 2. we are currently working on, I’m contacting you via Email.
I hope that brings you forward already and may serve as an inspiration!
Kind regards,
Lukas