ATOM SVC / RSS data Feed


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 ( 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

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=“” xmlns:app=“” xmlns=“”>< workspace>< atom:title>Records Summary</atom:title>< collection href=“”>< atom:title>Tablix1< /atom:title>< /collection>< collection href=“”>< atom:title>Tablix2< /atom:title>< /collection>


You can read in the file using the XML Reader node and then use an XPath node with the XPath expression


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,

1 Like