All Questions
18
questions
0
votes
2
answers
613
views
(Facebook) How to get user check-ins with FQL
I can get users check-ins with Graph API but not with FQL.
SELECT place FROM stream WHERE filter_key = 'owner' AND with_location = 'true' AND type = 285
Returns empty result.
SELECT message FROM ...
- 425
1
vote
1
answer
194
views
How to get last post for multiple facebook pages (one for each)?
Is there any way to get ONLY the latest post from stream for each page you like?
fql?q=
{
"pg":"SELECT page_id FROM page_fan where uid = me() LIMIT 5",
"post":&...
user2217713
1
vote
0
answers
433
views
Facebook FQL properly sorting stream table using ORDER BY created_time
I'm having some trouble to retrieve a sequence of posts using FQL when sorting by *created_time*. It seems that when I try to retrieve posts ordering by *created_time*, FQL first retrieves the first ...
- 343
0
votes
1
answer
113
views
inconsistency of data using FQL - Table stream
I'm using FQL to get the post recently modified to exactly 10 minutes ago, the FQL used is as follows:
SELECT post_id, message, created_time, likes.count, likes.user_likes, comments.count, actor_id
...
2
votes
0
answers
234
views
Stream FQL shows blank messages (which are my posts on other's walls) - but only with 1 App
I've been struggling with this one for a few days.
I use a query like this to get my posts on my wall:
select post_id, viewer_id, app_id, source_id, updated_time, created_time, filter_key, ...
- 126
0
votes
1
answer
262
views
Facebook FQL stream query only returning 4 items
I am trying to retrieve all Photos from a user's stream.
SELECT post_id, actor_id, target_id, message, created_time
FROM stream
WHERE filter_key in (SELECT filter_key FROM stream_filter WHERE uid = ...
- 335
0
votes
1
answer
488
views
FQL query to stream still returning unreliable results?
I am trying to use FQL to query the stream table and retrieve news feed items. Like this:
SELECT post_id, actor_id, target_id, message, created_time
FROM stream
WHERE filter_key in
(SELECT ...
- 103
5
votes
0
answers
2k
views
Facebook Timeline - Activity Log - Graph API - FQL Query All Return Data Based Only on Current Value (Major Bug?)
We are writing a FQL Query that uses READ_STREAM to see whenever that friend has changed their relationship status (and made that information public) and/or current city. In this case the person’s ...
- 148
1
vote
2
answers
2k
views
How to get FQL Stream with full names
I would like to show stream data from FQL
fql?q=SELECT post_id, app_id, source_id, updated_time, created_time, filter_key,
attribution, actor_id, target_id, message, app_data, action_links,
...
- 216
2
votes
2
answers
1k
views
FQL query using stream table doesn't accept app access token
I've searched stackoverflow all day long to find an answer without luck, so here we go.
I'm trying to fetch data from the stream table like this:
FQL: SELECT post_id, message, created_time FROM ...
- 509
2
votes
0
answers
372
views
How can I get "like something" posts from Facebook stream using FQL
I can see in my feed (on the web FB page) "User_Name likes some_link" post. I also can see it in Facebook application for Android (com.facebook.katana).
But I can't get it using FQL from stream table "...
- 433
4
votes
1
answer
560
views
Finding out the original author of a shared post (the "via X" while reading the newsfeed)
While fetching the stream FQL table you can see entries as link post (type_id is set to 80), the attachment attribute says it's a video (in this specific case) but I see no way to find the original ...
- 341
0
votes
1
answer
761
views
Get the proper FQL source_id when querying multiple source_id's
Given the following Facebook Query Language:
SELECT source_id FROM stream WHERE source_id in ('301470456547727', '194053380668945')
I expected to receive two different source_id's for the objects, ...
- 435
0
votes
1
answer
171
views
FQL Result Issue
In looking at the stream table, the documentation says ..
updated_time time
The time the post was last updated, which occurs when a user comments on the post, expressed as a Unix timestamp
...
1
vote
1
answer
453
views
FQL returning different results when queried from APP
I have a process which scrapes the stream table periodically for given users, importing any new comments or posts which have come in. When I test my query using the facebooks fql.query link, the ...
- 1,035