YQL (the Pipes sister product) is more programmer friendly, and also free. Give YQL a go if the Pipes visual UI doesn't work for you (and it has lots of yummy server side JS goodness too).
Requires Yahoo ID to use the demo console, but YQL doesn't need that when you make the web service calls.