YQL是Twitter追随者的推文(YQL for twitter follower's tweets)
如何获得特定Twitter帐户关注者的推文列表? 我可以通过以下方式获得关注者的ID列表:
select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml'我的假设是,为了检索所有这些ID的推文,我应该可以写出:
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml')但我只是没有结果。
注意 - 为了比较,下面的查询获得了朋友的推文(我跟随而不是跟随我的人)的确发挥作用:
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/statuses/friends/sqlservercentrl.xml' and itemPath='users.user')How can I get a list of the tweets of a particular twitter account's followers? I can get a list of the follower's ids with this:
select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml'my assumption was that to retrieve the tweets for all these ids I should then be able to write:
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml')but I just get no results.
note - for comparison the following query, which gets the tweets of friends (who I follow as opposed to who follows me), does work:
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/statuses/friends/sqlservercentrl.xml' and itemPath='users.user')最满意答案
你有没有尝试添加itemPath标准?
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml' and itemPath='ids')Have you tried adding the itemPath criteria?
select title from twitter.user.timeline where id in (select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml' and itemPath='ids')更多推荐
发布评论