KNIME HUB - Extract Teams, private spaces & workflow groups & workflows

[narayanan]

Hi Alex,

Thanks for your " Hub Workflow List" workflow. I am trying to use this workflow but this is not compatible for 4.7.7 version.

I have tried to create a workflow with the same nodes and configuration but stuck on the Fetch child items. Can you help on the json path configuration & string manipulation.

jsonpath

Regards
Narayanan.

[AlexanderFillbrunn]

Hi Narayanan,
You should be able to load the workflow I shared in 4.7.7. when you click the “Load anyways” button in the warning message that is shown. Then you can replace only the nodes that do not exist in 4.7.7.
Below you find a screenshot of my JSON Path that is extracting the child item types, paths, and IDs.
Kind regards,
Alexander

[narayanan]

Thanks Alex. I have executed the workflows and got the output on the Recursive loop end but the Rule based row filter has warnings.

Is this node condition extract (filter) only the spaces or workflow groups?

[AlexanderFillbrunn]

Hi,
This warning is expected. In the last iteration, there are no more workflow groups or spaces to crawl, so this table must be empty. Then the loop terminates.
Kind regards,
Alexander

[narayanan]

Thanks Alex for your help and inputs.

Can you give a suggestion (recommended nodes) to segregate this output data into teams/space/workflow in the uniform way. The workflow coach not shows any suggestion to extract the data (Column delimiter / from the path)

I have tried column filter and used cell splitter to segregate the data but not in uniform format to share.

Regards
Narayanan.

[narayanan]

Finally I found the option to segregate the output data using column filter & cell splitter along with excel writer node.

Thank you Alex for your help and inputs always.

Regards
Narayanan.