47601

How do I get a list of friends who clicked “Like” on an external page?

Question:

<b>PART A</b> -<br /> There are many many questions like this, but none of them seem to provide a working solution. I want to get a list of friends who clicked the Facebook "Like" button on an external site.

NOTE: This is NOT for a Facebook page. In this case, I know I can query the page_fan table.

To get the list of Facebook page-likes for example, I can use the url_like table. I guess I just want a way to invert this table. I know I cannot get a list of ALL people that liked a link due to privacy concerns, but I want a list of my friends alone - which should be fine.

I know facebook does this internally every time I see a Facebook Like button... right below that there is statistics about my friends that also like the same link. How do I get this using FQL?

<b>PART B</b> <br /> Equivalently, how do I get a list of friends that <b><i>shared</i></b> a specific URL as a link? I cannot search the link table by url because that is not indexed. Also, the link_id is not the same as the Open Graph ID of the URL.

I tried select link_id from link where url="http://urladdress.com/a/b.html" and owner in (select uid2 from friend where uid1=me()) but that neither throws an error not returns anything... just stalls.

Answer1:

Part A: you can't.

Part B: you can't the way you are trying. You <strong>might</strong> be able to get the feed for every one of the users friends and look for that url from their feed, but it will be painfully slow.

Lots of people would like to know this but Facebook is (rightfully so) not giving this information out. That is why you see lots of questions regarding it but no working solutions.

Answer2:

You could possibly look into the <a href="https://developers.facebook.com/docs/reference/api/permissions/" rel="nofollow">read_insights</a> permission. You might not be able to get the exact information about "likes" (yet)... but you <strong>will</strong> be able to get other possibly useful information.

Recommend

  • Facebook comment box plugin
  • Facebook Javascript SDK: Processing Response from Facebook
  • Graph api (facebook) is too slow
  • Gathering a user's news feed with Koala (Ruby)
  • Getting “like” data from an URL which has a facebook ID
  • Finding who shared a link publicly and finding who reshared a given link
  • How do I query links shared by Facebook Pages?
  • Facebook FQL: I want to get all the posts that a user wrote on friends timelines
  • Getting Facebook Share, Like and Comment Counts for a Given URL with API Graph v2.6
  • publish_stream message visibility to everyone
  • Facebook API - fql_query, Invalid session
  • Best way to get common “likes” from public info page out of your friends list
  • Get username of logged in user in os via browser
  • ListView list is reversed when selection made
  • What's effective way to write Vaadin project ?
  • How to ignore/remove leading zeros?
  • deploy SQL Server Database with a Winforms app
  • Search Facebook by first name with Koala
  • django - can't see the uploaded media files from apache
  • Making public posts via Facebook App?
  • Counterintuitive design of addition/subtraction between numbers and nullable numbers [closed]
  • How can I get all open graph pages owned by an application?
  • iOS, How to check whether the user likes a facebook page or not?
  • How to identify incomplete rectangles in openCV
  • C# - Most efficient way to iterate through multiple arrays/list
  • NHibernate manually control fetching
  • Consuming a WCF service in a Java Client using wsHttpBinding
  • how to set variables in a php include file?
  • Webgrid not refreshing after delete MVC
  • Installing iPhone App to iPhone
  • Abort upload large uploads after reading headers
  • Jquery UI tool tip close icon
  • Recording logins for password protected directories
  • Traverse Array and Display in markup
  • Data Validation Drop Down Box Arrow Disappearing
  • SetUp method failed while running tests from teamcity
  • What are the advantages and disadvantages of reading an entire file into a single String as opposed
  • Exception on Android 4.0 `android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode)`
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?
  • Qt: Run a script BEFORE make