0

The update stream on yahoo profile pages

 

by
4 Replies
  • Hello, I believe you are looking for the social.updates table. To retrieve your own most recent updates, you can run the following query: 

    SELECT * FROM social.updates WHERE guid=me

    Best, 
    Daniel
    0
  • I tried that Daniel but the results on the profile page are different than on that table.I can't imagine it is a glitch.


    QUOTE(Daniel @ 19 Sep 2012 1:30 AM)
    Hello, I believe you are looking for the social.updates table. To retrieve your own most recent updates, you can run the following query: 

    SELECT * FROM social.updates WHERE guid=me

    Best, 
    Daniel
    0
  • Sorry for the delayed response. I've also found that the results don't match what was on my profile page and have been trying to a construct a query that matches those results. Unfortunately, I don't have anything that resembles the actual profile updates. However I did notice that the profile page is not pulling some of its information through an API.

    For example, comments are being pulled through:
    http://profile.yahoo.com/{guid}/comments/

    And reading activity:
    http://profile.yahoo.com/{guid}/reading_activity/

    It's possible these are exposed through the social.updates table. I'll see if I can reach out to the Social team for some additional insight. In the meantime, you might be able to scrape the data you want from those respective URLS using the data.html.cssselect table or with some other solution.

    Best,
    Daniel
    0
  • Thanks Daniel:) I will scrape and investigate further, if you can remember, please inform me of whatever the Social team says to you in response


    QUOTE(Daniel @ 27 Sep 2012 11:24 AM)
    Sorry for the delayed response. I've also found that the results don't match what was on my profile page and have been trying to a construct a query that matches those results. Unfortunately, I don't have anything that resembles the actual profile updates. However I did notice that the profile page is not pulling some of its information through an API.

    For example, comments are being pulled through:
    http://profile.yahoo.com/{guid}/comments/

    And reading activity:
    http://profile.yahoo.com/{guid}/reading_activity/

    It's possible these are exposed through the social.updates table. I'll see if I can reach out to the Social team for some additional insight. In the meantime, you might be able to scrape the data you want from those respective URLS using the data.html.cssselect table or with some other solution.

    Best,
    Daniel
    0

Recent Posts

in YQL