Saturday, October 11, 2014

Sorting YQL into RSS feed format using YahooPipes

This tutorial will show how to sort the jargon YQL produces in YahooPipes into a familiar RSS format.



1. The YQL query here is
select * from html where url=’http://www.cadred.org’ and xpath=’/html/body/div/div/div[3]/div[5]/div[3]/div/div’
The output is not useful for an RSS feed and needs sorting out before it can be used

2. Select the Loop module from operators

3. Place the “item builder” module into the “loop” module

4. This process is very difficult and requires some trial error.
On the left hand side of the “item builder” input the field you want to create.
Then from the drop down try to select the path that is the closest match to the jargon from the YQL debugger.
Sometimes you will get lucky and you will find it works first time! However sometimes the dropdown path is incorrect and you will need to try and figure out the correct path and manually enter it



5. Repeat this process for every field you want.
Use the “rename module” to create virtual fields hilst you figure out the exact path of the item you want. Then add the exact path to the item builder. This will save time having to refresh through the loop module which can be sensitive to incorrect paths.

No comments:

Post a Comment