jsonyahoo-pipesxml-namespacesyqldublin-core

YQL XML Output with custom namespace

I am attempting to parse a JSON feed from Yahoo Pipes to turn it into XML, using YQL. My query is:

"select * from json where url='http://pipes.yahoo.com/pipes/pipe.run?_id=[pipe-id]&_render=json'"

The problem is that the original Pipe was parsing an RSS feed, filled with dublin core tags (example: dc:title, dc:source, etc). The XML output cannot handle these tags and Yahoo Pipes cannot remove them properly. Whenever I try to run the XML output in any browser, it throws a fit because of the missing at the beginning of the document.

How can I define a custom namespace from the XML output of YQL?

Solution

  • You could use the W3C Online XSLT 2.0 Service to apply an arbitrary transformation to the XML output. Here's a sample pipe that uses this service.