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)
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.