Facebook friends email FQL

I have this FQL:

$femail = $facebook->api(array( 'method' => 'fql.query', 'locale' => 'en_US', 'query' => 'SELECT email FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$user_id.') AND uid = '.$friend_id.' ORDER BY name ASC', ));

Here is the print_r result:

Array ( [0] => Array ( [email] => ) )

I want to get friend's email address, but this query results in empty email values. Does I miss something in query? Does it even possible to get friends email? I tested with my partner, she gave permission to the app to give out email address.

-------------Problems Reply------------

In general, you CAN'T get the email address of your friends (source):

User permission Friends permission
email not available

BUT but since your friend has authorized your application, you can try the following in the FQL console:


What I suspect the problem could be is that you need the "friend's" access_token to actually get the email because I suppose you are logged-in as your user when trying your query. So you need to grant the offline_access permission and then use it with the query.

But before doing the above, I would try it with an application access_token.

P.S: the sub-query is not needed if you know the friend id.

You can't get email addresses of friends. Each account must opt-in to sharing their email address with the application. Friends can't opt other friends in, which is a good thing.

Also, as @Barkermn01 mentioned, drop the AND uid = '.$friend_id.'

Category:php Views:0 Time:2011-02-25

Related post

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.141 (s). 11 q(s)