Questions tagged [facebook-fql]

Facebook Query Language (FQL) enables you to use a SQL-style interface to query the data exposed by the Graph API. It provides for some advanced features not available in the Graph API such as using the results of one query in another.

Facebook Query Language (FQL) is now deprecated and the service is completely disabled and unusable.

FQL enabled you to use a SQL-style interface to query the data exposed by the Graph API. It provided for some advanced features not available in the Graph API such as using the results of one query in another.

3041 questions
13
votes
3 answers

How can I get all photos in one post using Graph API?

{ "id": "11882030_4952296803730", "from": { "name": "xxx", "id": "11882030" }, "message": "test", "picture": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-ash4/408410_4952294483672_298434229_s.jpg", …
adali
  • 5,977
  • 2
  • 33
  • 40
12
votes
1 answer

FQL select column name "AS" alias

I am using JSDK, but the problem is for sure in FQL request. I am trying select which makes basic operation and i want to name the result. But facebook always name it "anon" SQL example: SELECT (register_time - unregister_time) AS time_registered…
Jindra
  • 780
  • 13
  • 39
12
votes
5 answers

Setting Facebook comments web plugin

The default sorting order of the facebook comments plugin is by social status. How do I set the default order to reverse chronological on my web page? I know there is an option on the top of the plugin. But not all users know about it and the…
Jan Turoň
  • 31,451
  • 23
  • 125
  • 169
12
votes
3 answers

Get all of a user's likes (all of them) with FQL

I'm trying to get ALL of a user's likes with FQL. Following is my research including what I've tried and the problems with each attempt. 1) The most simple method would be to query the table on the uid. So this returns 57 (for me) likes on other's…
ow3n
  • 5,974
  • 4
  • 53
  • 51
11
votes
2 answers

Key Facebook insights metrics deprecated -- alternatives not documented?

Over at https://developers.facebook.com/docs/reference/fql/insights/ Facebook states:: We are deprecating some old insights. These metrics are marked as __deprecated__ throughout this document. After 12/21/2011, data for these metrics won't be…
Bram Houf
  • 111
  • 1
  • 3
11
votes
7 answers

Getting user likes of stream items via FQL (posts, comments, pictures, links, etc)

I need assistance in getting user likes of stream items via FQL. I've got some of the likes coming back, but cannot figure out how to get others. For the access_token, every permission is granted. Let me show you what I've been able to…
DMCS
  • 31,720
  • 14
  • 71
  • 104
11
votes
3 answers

To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook

As you can see in the screenshot above, I got Facebook app review approval but now I tried to access Facebook public page posts and comments per page. Still, I am getting bellow massage in R Console: Error in callAPI(url = url, token = token, api =…
11
votes
1 answer

Facebook FQL LIKE operator

Possible Duplicates: Does facebook fql contain the sql like operator? FaceBook query using FQL Is it possible to use the familiar SQL LIKE operator within Facebook's query language? I have tried running the query in the FQL test console, but it…
Alan David Garcia
  • 1,523
  • 2
  • 14
  • 23
10
votes
5 answers

Is there an API to retrieve Facebook recent activity?

I know there's a Graph api url for getting the recent wall feeds: https://graph.facebook.com/me/feed?access_token=... But how do I get the Recent Activity? Is there any way? FQL (not Graph API) can work too. I don't really care which way I get…
Alex K
  • 6,737
  • 9
  • 41
  • 63
10
votes
2 answers

I upgraded to FQL to Graph API - am I using it correctly?

I used the FQL until a few days ago to retrieve Facebook data, but I noticed that it will be discontinued in about 1 year so I upgraded to Graph API. But am I using it correctly? Will this method work still next year? I am still using a…
user1227914
  • 3,446
  • 10
  • 42
  • 76
9
votes
2 answers

What is the difference between a Facebook Page "Like" and an external URL "Like"? And will the "user_likes" permission scope give access to both?

I'd like to pull a list of all Facebook "Likes" for a user, whether they are Facebook pages or external URLs. Example: If you "Like" the Facebook Platform, I know I can see it via the /me/likes API call. However, if you like an external URL, I'm not…
Ryan
  • 14,682
  • 32
  • 106
  • 179
9
votes
2 answers

Facebook App Users List

I am fairly new to the Facebook APIs. I want to get a list of my friends who have also installed my app. (The idea being you can then start a game with them). This gives a list of my friends: FB.api('/me/friends', ... This gives my app…
Simon Lang
  • 40,171
  • 9
  • 49
  • 58
9
votes
3 answers

Unable to retrieve user info through facebook api or FQL

I am building an app in which I need to read education and work history of all people(if it is not hidden by privacy settings) in a facebook group(public group). People in the group need not necessarily be friends of the user logged in to my app. I…
Ninja
  • 5,082
  • 6
  • 37
  • 59
9
votes
7 answers

Facebook mutual friends and FQL 4999/5000 record limit

I'm trying to select all mutual friends' connections with PHP/FQL. Using my UID (540 friends), which means >12,000 connections, of which >6500 are unique. So this code should return all the connections but Facebook apparently has a 4999/5000 row…
ow3n
  • 5,974
  • 4
  • 53
  • 51
9
votes
6 answers

Getting friends of friends in FB graph API

I would like to get friends of friends via an API call and when I try to do it, I get the following exception, { "error": { "type": "OAuthException", "message": "(#604) Can't lookup all friends of .... Can only lookup for the…
Abhishek
  • 6,862
  • 22
  • 62
  • 79