ATOM SVC / RSS data Feed

Hi,

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 (https://hub.knime.com/knime/spaces/Examples/latest/08_Other_Analytics_Types/01_Text_Processing/15_RSS_Feed_Reader) 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.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>Records SummaryTablix1Tablix2

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

looks like the original got cut off / cant entire in the whole thing. had to add a space after after the <
otherwise it wouldn’t show up properly

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

< service xmlns:atom=“http://www.w3.org/2005/Atom” xmlns:app=“http://www.w3.org/2007/app” xmlns=“http://www.w3.org/2007/app”>< workspace>< atom:title>Records Summary</atom:title>< collection href=“http://analystreports.stl.this_company.com/ReportServer?%2FPublic%2FACR%2FACR%20Records%20Summary&ImpactStart=01%2F01%2F2020%2000%3A00%3A00&ImpactEnd=01%2F31%2F2020%2000%3A00%3A00&Status=Cancelled&Status=Closed&Status=Monitoring&Status=Open&Status=Pending&Status=Resolved&CountFlag=0&TableView=1&rs%3AParameterLanguage=&rs%3ACommand=Render&rs%3AFormat=ATOM&rc%3ADataFeed=xAx0x0”>< atom:title>Tablix1< /atom:title>< /collection>< collection href=“http://analystreports.stl.this_company.com/ReportServer?%2FPublic%2FACR%2FACR%20Records%20Summary&ImpactStart=01%2F01%2F2020%2000%3A00%3A00&ImpactEnd=01%2F31%2F2020%2000%3A00%3A00&Status=Cancelled&Status=Closed&Status=Monitoring&Status=Open&Status=Pending&Status=Resolved&CountFlag=0&TableView=1&rs%3AParameterLanguage=&rs%3ACommand=Render&rs%3AFormat=ATOM&rc%3ADataFeed=xAx0x1”>< atom:title>Tablix2< /atom:title>< /collection>

thanks

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 &#038;. Otherwise it is not proper XML and the reader will fail.
Kind regards,
Alexander

1 Like