Fetching all uploaded,tagged in and share videos in Facebook by FQL

Posted by himanshu on Stack Overflow See other posts from Stack Overflow or by himanshu
Published on 2012-06-13T04:08:47Z Indexed on 2012/06/13 4:40 UTC
Read the original article Hit count: 318

Filed under:
|

In my app, i want to fetch all videos of logged in user i.e. videos that are uploaded by user, videos share by user, user tagged in etc. Currently im using "stream" query as:

    SELECT created_time, post_id, actor_id, type, updated_time, attachment FROM stream WHERE created_time>1075593600 AND type IN (56, 80, 128, 237, 272) AND source_id=me() limit 10000

As you can see i use "type IN" to fetch required videos but this query is not fetching all videos of mine . I have two videos in 2011 one of which is uploaded and other one is shared.But i m not getting these two. Also in developer.facebook it was written that "Each query of the stream table is limited to the previous 30 days or 50 posts, whichever is greater, however you can use time-specific fields such as created_time along with FQL operators (such as < or >) to retrieve a much greater range of posts." So i tried "created time>0" i.e.(1970) and other like timestamp of 2001 but still i m not getting all. Please help..its urgent.Thanks

© Stack Overflow or respective owner

Related posts about facebook

Related posts about fql