3

Possible Duplicate:
Querying Users who 'like' my Facebook Page

Currently all the solutions on this site don't work. I am an admin on a facebook page and would like to export the ID's off all my fans, is this possible ?

https://api.facebook.com/method/fql.query?query=SELECT uid FROM page_fan WHERE page_id= [PAGE_ID]&access_token=[ACCESS_TOKEN]

enter image description here

Community
  • 1
  • 1
daniel
  • 9,732
  • 7
  • 42
  • 57

1 Answers1

5

EDIT: no longer possible, see Querying Users who 'like' my Facebook Page

FQL:

SELECT uid FROM page_fan WHERE page_id = <page_id>
Community
  • 1
  • 1
Rufinus
  • 29,200
  • 6
  • 68
  • 84
  • says it needs an oauth access token, I am currently logged in as the admin, and given an access token a page_id says its invalid – daniel Jun 14 '11 at 00:07
  • see http://developers.facebook.com/docs/authentication/ the part with: In order to authenticate your app, you must pass the authorization code and your app secret to the Graph API token endpoint at https://graph.facebook.com/oauth/access_token. The app secret is available from the Developer App and should not be shared with anyone or embedded in any code that you will distribute – Rufinus Jun 14 '11 at 00:12
  • `https://graph.facebook.com/oauth/access_token? client_id=YOUR_APP_ID&redirect_uri=YOUR_URL& client_secret=YOUR_APP_SECRET&code=THE_CODE_FROM_ABOVE` so you get an accesstoken for the fql request. – Rufinus Jun 14 '11 at 00:13
  • where it says: Your statement is not indexable. The WHERE clause must contain an indexable column. Such columns are marked with * in the tables linked from http://developers.facebook.com/docs/reference/fql – daniel Jun 14 '11 at 00:14
  • try `SELECT user_id FROM like WHERE object_id=` – Rufinus Jun 14 '11 at 00:20
  • I get . I am opening this in the browser, is there a special way to see this ? or is the list just empty – daniel Jun 14 '11 at 00:22
  • will be empty. there was a way via the old rest api, but it seems FB has closed all ways via FQL to get the data. – Rufinus Jun 14 '11 at 00:24
  • So there is really no way to see my list of fans ? – daniel Jun 14 '11 at 00:32
  • @daniel did you find a solution? i am tryin rufinus solution but that didn't work. For posts it does work but not for page_id?? i am getting error 604 "Your statement is not indexable..." – alex Sep 30 '11 at 11:58
  • yes the solution is to not use facebook at all, this is not possible, facebook API sucks too much.. – daniel Sep 30 '11 at 14:54
  • try SELECT user_id FROM like WHERE object_id= – Rufinus Jun 14 '11 at 0:20 - that will NOT work, because The object_id is id of a video, note, link, photo, or album. – Vadim Ivanov Nov 21 '12 at 20:00
  • `will be empty. there was a way via the old rest api, but it seems FB has closed all ways via FQL to get the data. – Rufinus Jun 14 '11 at 0:24` - you should read all comments pal. – Rufinus Nov 22 '12 at 00:34