I am using the HTML5 version of Facebook Comment in my website. I have my own Facebook APP Id.

Using Graph-API, and FQL (I think this is how to do it), I want to list all the Comments posted in my website.

Example -

Page Title1
--Comment1
--Comment2
--Comment3

Page Title2
--Comment1
--Comment2
--Comment3

Page Title3
--Comment1
--Comment2
--Comment3

etc.

Please help me out.

I am using the HTML5 version of Facebook Comment in my website. I have my own Facebook APP Id.

Using Graph-API, and FQL (I think this is how to do it), I want to list all the Comments posted in my website.

Example -

Page Title1
--Comment1
--Comment2
--Comment3

Page Title2
--Comment1
--Comment2
--Comment3

Page Title3
--Comment1
--Comment2
--Comment3

etc.

Please help me out.

• javascript
• facebook-graph-api
• facebook-fql
• facebook-ments

• If you appreciate any of the answers below, please mark one of them as the right answer. This will increase your reputation, and the answer poser's. – gardenofwine Commented Oct 15, 2013 at 11:59

3 Answers 3

It is possible, in two different ways, as long as you have a fixed set of sub-pages you want to fetch ments from.

If you have a large amount of sub-pages, or a variable amount, then you don't have a good scalable solution - and many have been looking for one:

• Facebook fb:ments Graph API
• How to display recent ments from Facebook Comments social plugin?
• Facebook FQL query to return all ments against an application
• Retrieve all ments with FQL by application ID
• Facebook FQL query to return all ments against an application
• fql query to get ment count no longer working
• http://facebook.stackoverflow./questions/10023179/retrieve-all-the-ments-posted-using-fql

For a Fixed set of sub-pages in your website, you can either use a batch request, or an FQL query.

Batch Request

First, you need your access token. Just enter the following as a url in a browser (credit to this website ):

https://graph.facebook./oauth/access_token?type=client_cred&client_id=APP_ID&client_secret=APP_SECRET

$.ajax({
  url: 'https://graph.facebook./',
  type : "POST",
  data: {
    access_token : 'YOUR_APP_ACCESS_TOKEN',
    batch : '[ \
    {"method":"GET","relative_url":"URL1"}, \
    {"method":"GET","relative_url":"URL2"} \
    ]'
  },
  success: function(data) {
    jdata = JSON.parse(data);
    $.each(jdata, function(index,value){
        jdata[index].body = JSON.parse(value.body);
        console.log(value.body);
    });
    // Do whatever you want with jdata
  }
});

FB.api({
    method: 'fql.query',
    query: 'select text from ment where object_id in (select ments_fbid from link_stat where url="URL1" or url="URL2")'
  }, function(response) {
    // Do something with results
  });

Conclusion

Because of this limitation of Facebook, I plan to switch to disqus., which apparently supports this feature (As you can see from this blog, for example. (search for 'recent ments')

Rather than list all the ments on your site, Facebook wants you to implement code to get notified when a new ment is posted anywhere on your site.

To make this happen, you have to put some Javascript into the page where the ment is posted to also notify yourself:

window.fbAsyncInit = function(){
    console.log("subscribing to ment create");
    FB.Event.subscribe('ment.create',function(response){
        console.log("facbeook ment created: " + JSON.stringify(response));
        var mentQuery = FB.Data.query('SELECT fromid, text FROM ment WHERE post_fbid=\'' + response.mentID + '\' AND object_id IN (SELECT ments_fbid FROM link_stat WHERE url=\'' + response.href + '\')');
        FB.Data.waitOn([mentQuery], function () {
            console.log("Facebook ment: " + JSON.stringify(mentQuery));
        }); 
    });
};

Where rather than just logging the ment to the console, you would need to implement some AJAX that would send the ment back to your site where you could store the ment in your database, or send yourself an email notifying you that the ment has been posted.

Reference: Facebook Comments Plugin

Say your website is http://mywebsite./blog.php?id=3 and you have a facebook ments plugin on it, you can access ments this way

 https://graph.facebook./ments/?ids={YOUR_URL}.

{YOUR_URL} bees http://mywebsite./blog.php?id=3

Example 1: (Comments plugin installed on developers facebook doc website )

website: http://developers.facebook./docs/reference/plugins/ments

fetch ments: https://graph.facebook./ments/?ids=http://developers.facebook./docs/reference/plugins/ments

Example 2:

website: http://techcrunch./2011/04/08/the-seven-most-interesting-startups-at-500-startups-demo-day/

fetch ments: https://graph.facebook./ments/?ids=http://techcrunch./2011/04/08/the-seven-most-interesting-startups-at-500-startups-demo-day/

Check this too

Sample code for pulling ments can be found on this blog post