I have a data feed that is being produced from a SQL Server report and I’m trying to use the RSS Feed Reader node (RSS Feed Reader – KNIME Community Hub) to input the URL properly into the first node (Table Creator).
When I open the ATOMSVC file it looks something like the text below. Question is how the heck do I get a URL out of it? Any help would be appreciated. I also setup up a proxy on the website.
i think this is what i’m suppose to use/extract
.
http://analystreports.stl.this_company.com/ReportServer/Public/ACR/ACR+Records+Summary&ImpactStart=01/01/2017&ImpactEnd=12/31/2100&Status=Cancelled&Status=Closed&Status=Monitoring&Status=Open&Status=Pending&Status=Resolved&CountFlag=1&CountFlag=0&TableView=1&rs:ParameterLanguage=&rs:Command=Render&rs:Format=ATOM
Hi,
You can read in the file using the XML Reader node and then use an XPath node with the XPath expression
/dns:service/dns:workspace/dns:collection/@href
to extract the URL. However, the document contains ampersand (&) characters, which in XML denote special entities. Before being able to read the file with the XML Reader, the & characters must be replaced with &. Otherwise it is not proper XML and the reader will fail.
Kind regards,
Alexander