get all youtube videos that a user has liked on facebook

Question

What I need, through the facebook API, is to get (for a specific, logged user) all the youtube videos (links to youtube pages) she liked on facebook, meaning all the posts she liked that contained a link to a youtube video.

I know I can do that in FQL with the url_like table, but I'd like to also have access to when the user liked the link (or at least when the link was posted), and more in general have access to the post it liked the video on.

For reference, this is the FQL documentation for that table (which does not serve the purpose): https://developers.facebook.com/docs/reference/fql/url_like/

Answer 1

The call is very complex and I'm not really sure where to begin fixing the performance, maybe some batch calls, saving of data to post process... but the actual call itself using purely FQL takes a long time or chokes out on too big a query.

SELECT link_id, owner, created_time, title, summary, url, picture, image_urls 
FROM link 
WHERE url in 
    (SELECT url, user_id 
     FROM url_like 
     WHERE user_id=me()
     AND strpos(url, 'http://www.youtube.com/watch?v=') >= 0)
AND owner in (select uid2 from friend where uid1 = me() LIMIT 20)

Notice I imposed a limit of 20 friends.

Answer 2

Can you not use:

{userId}/likes?fields=created_time.

For example, if I use "https://graph.facebook.com/me/likes?fields=created_time" it gives me my likes and the times I liked them.

Hope this helps.