Icon

GET Request (XML response)

<p><strong>Parsing the XML answer to a GET request with XPath</strong></p><p>This workflow demonstrates how to parse the XML body of an example GET request.</p><p>To choose the output of the XPath node, open the configuration. There, one can select a field in the XML-Cell Preview. Selecting one and clicking "Add XPatch" opens a configuration window, where one can:</p><ul><li><p>select the resulting column name</p></li><li><p>tweak the XPath value query make sure it does not contain numbers in brackets if all values shall be extracted</p></li><li><p>change the data type</p></li><li><p>select, how multiple values shall be treated (in this example, "Multiple Rows" was selected)</p></li></ul>

Parsing the XML answer to a GET request with XPath

This workflow demonstrates how to parse the XML body of an example GET request.

To choose the output of the XPath node, open the configuration. There, one can select a field in the XML-Cell Preview. Selecting one and clicking "Add XPatch" opens a configuration window, where one can:

  • select the resulting column name

  • tweak the XPath value query make sure it does not contain numbers in brackets if all values shall be extracted

  • change the data type

  • select, how multiple values shall be treated (in this example, "Multiple Rows" was selected)

Nodes

Extensions

Links