Hi,

Is it possible to do a Loop for each XML element in VisualCron?

Essentially wish to loop through an XML document and fire off via HTTP Send. Could do this by doing SQL select to get each XML node but wondering if I can cut that bit out and just use a VC loop.

Cheers

Hi,

Is it possible to do a Loop for each XML element in VisualCron?

Essentially wish to loop through an XML document and fire off via HTTP Send. Could do this by doing SQL select to get each XML node but wondering if I can cut that bit out and just use a VC loop.

Cheers

Through a task named XML-Read node, with an Xpath where you can create a query that will return several answers, which you can then loop

---

Hi Michael,

That much I gathered however you cannot choose XML as a method in "Task Loop" you have a For X to Y, While X and For Each X In Y there isn't any method to loop XML elements retrieved by an XML-Read Node.

You also cannot use the For Each X and Y because the Read-XML does not return each element as a row but as a single row all together.

Regards,

Hi Michael,

That much I gathered however you cannot choose XML as a method in "Task Loop" you have a For X to Y, While X and For Each X In Y there isn't any method to loop XML elements retrieved by an XML-Read Node.

You also cannot use the For Each X and Y because the Read-XML does not return each element as a row but as a single row all together.

Regards,

No, but you use the XML Read Node Task with an XPath query that returns all elements first. Then you use that output for loop.

---