Clever Geek Handbook

Facebook FQL `like` table retuns max 100 rows?

OK, so the title basically says it all. I want to get the number of likes that I have given to the people I am making a request for like:

SELECT object_id FROM like WHERE user_id = me()

However, for large accounts, this always returns 100, even if I add LIMIT 1000

to the end of the query. If I make the limit below 100 (say 50) it only shows 50 results, so it LIMIT

works ...

Does anyone know about the limit that Facebook places on the number of results returned in this table? I am basically waiting for some Facebook engineers to help me with this, but if anyone has run into this issue, feel free to help me.

EDIT: If I make the following query, it returns 1000 rows, but this query is useless as I want everything to like what I gave and not what I got.

SELECT user_id FROM like WHERE object_id="10150146071791729" LIMIT 1000 // taken from a FQL example page
+3


source to share


4 answers


For anyone who might stumble upon this. Facebook apparently only lets you get 100 likes, etc. This is either a bug or not documented. I submitted a bug report with them.



+4


source


You can try this:



SELECT object_id FROM like WHERE user_id = me() LIMIT 0,100
SELECT object_id FROM like WHERE user_id = me() LIMIT 100,100
SELECT object_id FROM like WHERE user_id = me() LIMIT 200,100
SELECT object_id FROM like WHERE user_id = me() LIMIT 300,100
... and so on
+2


source


You can get the Count value first and then set LIMIT according to the amount

0


source


It seems that this issue is still open - create a new bug: https://developers.facebook.com/bugs/865607590127107/

0


source






More articles:


All Articles