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
7
votes
3 answers

FQL - Getting pid of the photos user is tagged in gives different results with different query

I am trying to get the photos a user is tagged in. I am using the query: SELECT pid FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE subject=me()) The number of results I get is 32. However when I run this query: SELECT pid FROM…
7
votes
1 answer

What are the supported operators and commands in FQL?

I'm trying to compile a complete list but the sources don't agree. Here's what I've got so far. Let me know if I'm missing anything, or if I've put anything in incorrectly. Basic format: SELECT [fields] FROM [table] WHERE [conditions] In the docs:…
Jack Kinsella
  • 4,491
  • 3
  • 38
  • 56
7
votes
3 answers

How can I optimize my FQL to avoid Facebook timeouts?

Let's take a simple FQL query to get all links shared by a user's friends since yesterday for example: SELECT link_id, title, url, owner, created_time FROM link WHERE created_time > strtotime('yesterday') AND owner IN ( SELECT uid2…
Ryan
  • 14,682
  • 32
  • 106
  • 179
7
votes
1 answer

In Facebook graph API how to find which all of your friends like a particular book or movie

I'm trying to figure out how to find how many of my friends like a particular entity. For example, for a given book or movie, how can I look up how many of my friends have already liked the same book or movie. I believe that information does appear…
Gublooo
  • 2,550
  • 8
  • 54
  • 91
7
votes
1 answer

Father's day coming up! - Can I get the profile of a Facebook user's father?

I'd like to get the Facebook profile ID of a Facebook user's father. Basically I want to display a picture of the user's father and say 'how about buying an X for Dad'. Is this possible with the graph (or REST) API ? Edit: It looks like this needs…
Simon_Weaver
  • 140,023
  • 84
  • 646
  • 689
7
votes
2 answers

Facebook Graph API: Get post/status attached photos

How can one get multiple attachments of a post/status in a group? For example: A group status that some member wrote and added multiple photos to.. Currently I am using Graph api to get the group stream with group_id/feed and unable to see images…
Idan
  • 2,819
  • 4
  • 33
  • 61
7
votes
3 answers

Facebook photo get parameters and photo available for how long

When I request a photo from Facebook, some urls are like this: https://{hidden_for_privacy}79141548_n.jpg And others are like…
Luc
  • 331
  • 3
  • 8
7
votes
6 answers

org.json.JSONException: Unterminated object at character on Android

I parse the JSON String and face the error org.json.JSONException: Unterminated object at character 25 my JSON is retrieved from Facebook {Response: responseCode: 200, graphObject: GraphObject{graphObjectClass=GraphObject,…
user3359419
  • 71
  • 1
  • 1
  • 4
7
votes
4 answers

Hashtag search in Facebook API

I am trying to find in Facebook API if they provide the HashTag search. I meant I search in Facebook Query language and searched in Facebook Tool Explorer. Any Idea ?
Pankaj
  • 9,749
  • 32
  • 139
  • 283
7
votes
1 answer

How do I find the timestamp of all the Facebook "likes" of an event photo?

From various postings I know that the timestamp of a 'like' is stored by FB, notably from here: https://developers.facebook.com/docs/reference/opengraph/action-type/og.likes/ But what I'm having trouble getting clear is how, given a photo that's…
Todd
  • 1,770
  • 1
  • 17
  • 42
7
votes
4 answers

How to get insights on a Facebook fan page without user login

I'm trying to figure out how to get the total number of comments, posts, likes and fans for any given Facebook fan page and date range using the Facebook API's. I need to be able to do this without the user having to log into Facebook to give the…
MakkyNZ
  • 2,215
  • 5
  • 33
  • 53
7
votes
2 answers

How to serialize using gson with @SerializedName annotation?

This is my first approach to serialization using Gson. I recive facebook response to my android application like this: Result: { Response: responseCode: 200, graphObject: GraphObject{graphObjectClass=GraphObject, …
alfo888_ibg
  • 1,847
  • 5
  • 25
  • 43
7
votes
2 answers

Querying all public facebook posts

I need to build an application that will have three input fields for three URLs. Application then needs to search all public posts on facebook and find users who posted that specific URLs. I'm using this code: $q = "http://www.someurl.com"; $search…
Xardas
  • 1,777
  • 6
  • 20
  • 31
7
votes
3 answers

passport-facebook in nodejs - profile fields

some of the profile fields i am trying to get from Facebook when logging in a user, are not going through. I am using passportjs in node. this is the facebook strategy: passport.use(new FacebookStrategy({ clientID: FACEBOOK_APP_ID, clientSecret:…
omerkarj
  • 663
  • 2
  • 7
  • 18
7
votes
1 answer

Facebook API Search by phone number

So I have a huge list of phone numbers and want to find facebook users for each of the phone numbers if they exist. There are tons of iphone apps, etc that pull in your contact list and match them to facebook accounts. Any ideas on how I can do…
BigPoppa
  • 1,205
  • 2
  • 13
  • 21