Retrieve Facebook Fan Names
I'm trying to grab the names of fans of a Facebook fan page that I administer. I've done some snooping around, and apparently, the FB API doesn't support that, but Facebook actually uses AJAX/JSON to populate the list. Anyways, can anyone suggest a way to make that call myself and grab the data as plain text?
Also, I've found a hack that a guy wrote in Ruby, but I am completely unfamiliar with the language.
Thanks for the help in advance!
At the current time the FQL schema would suggest that there is no way to get a collection of FANS for any given PAGE. I think they are hiding this information because they display the FANS on the page... One would think that at least the ADMIN would have privileges to see the list of users.
Anyway... I hope someone make is possible in the near future.
can you please try this and let me know :
select uid,name from user where uid in ( select uid from page_fan where uid in (select uid2 from friend where uid1 = me()) and page_id = 'Your Page Id')
I think you can get it only for the currently logged in user and his / her friends only.
If you have less than 500 fans, you can use the following url:
Each page will give you 100 fans. Change &start to (0, 100, 200, 300, 400) to get the first 500. If &start is >= 401, the page will be blank :(
I found that in the doc: http://developers.facebook.com/docs/reference/fql/page_fan/
uid - "The user ID who has liked the Page being queried."
SELECT first_name, last_name FROM user WHERE uid IN (SELECT uid FROM page_fan WHERE page_id = [your page id])
This should work, but I get an error trying to run this through the .net facebook api...something about the where clause not being on an indexable column, which it is.
Perhaps give that a try on your platform.
That one worked
SELECT user_id FROM like WHERE object_id="YOUR PAGE ID"