Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Retrieve Facebook users that like a URL / web page via Open Graph

Is there a way to retrieve the list of Facebook users that have clicked the like button on an external website?

  • E.g. there is a domain example.com which has been confirmed via Facebook Insights to belong to fbUser1 (using OG meta tags).
  • Somewhere on example.com there is a page with multiple XFBL like buttons, each one pointing to a further specific URL on example.com, e.g. example.com/xyz, example.com/abc etc.

What I'd like to get is the list of users that liked example.com/xyz and of those who liked example.com/abc.

My intuitive approach would be to look at graph.facebook.com/123456789/likes (where the number is the ID of the domain taken from FB insights), but this always returns an empty dataset:

{
   "data": [

   ]
}

I've also tried getting an OAuth access token from https://graph.facebook.com/oauth/access_token?type=client_cred&client_id=APPID&client_secret=APPSECRET (where APPID and APPSECRET are taken from a FB application that is marked as owning the domain using OG meta tags), but that makes no difference.

I'd also be interested in a non-OpenGraph (i.e. JS SDK, FQL etc.) solution.

EDIT: Using the following code (according to WideBlade's answer below) still gives me an empty list of likes (the second query never returns):

var objectsQuery = "select id from object_url where url in ('http://example.com/xyz', 'http://example.com/abc', 'http://example.com/123')";
var likesQuery = "select object_id from like where object_id = {0}";

FB.Data.query(objectsQuery).wait(function (objectRows) {
    console.log(objectRows);

    FB.Array.forEach(objectRows, function (objectRow) {
        FB.Data.query(likesQuery, objectRow.object_id).wait(function (likeRows) {
            console.log(likeRows);
        })
    });
});
like image 465
Samu Lang Avatar asked Feb 02 '11 15:02

Samu Lang


2 Answers

FQL Should do the trick.

$facebook->api_client->fql_query('SELECT user_id FROM like WHERE object_id="OBJECTID"');

Here is the link.

Some general info about FQL.

FQL is initiated using the JavaScript SDK, in this way.

If you can post some sample code-I can try and give some more specific help.

A note should be made-once you've got the user ID's, you can just query the names and get them in a list.

EDIT: To get the URL of an object you should query this table using fql.

like image 189
Tom Granot Avatar answered Oct 19 '22 15:10

Tom Granot


This cannot be done. Facebook does not allow you to query for specific user ID's of people who have liked a certain page. This is because of privacy concerns.

See the disclaimer on this page https://developers.facebook.com/docs/reference/fql/like/

like image 26
sid Avatar answered Oct 19 '22 16:10

sid