An underlying assumption with Yahoo Pipes was that interesting places on the Internet would offer APIs which have a developer UX that matches or exceeds the quality of their official UI. A mixture of unprofitability and abuse lead to this no longer being the case. Tom Scott's essay here: https://www.youtube.com/watch?v=BxV14h0kFs0