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!

Answers


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:

http://www.facebook.com/browse/?type=page_fans&page_id=13207908137&start=400

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"

Need Your Help

Best way to unit test console c# app

c# unit-testing nunit

I have a simple console app. It's fired of with a normal main and the entire program recides in main. It uses the Command Line Parser Library. Then I have a second project in the solution containin...

MySql difference between two timestamps in days?

mysql datetime timestamp

How can I get the difference between two timestamps in days? Should I be using a datetime column for this?