Facebook page_fan 查询返回不完整的结果
我正在尝试抓取我的朋友喜欢的 Facebook 页面。
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())
我注意到结果集中缺少一些数据,因此我在表中查询了各个用户 id,如下所示:
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid={id1}
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid={id2}
...
显然对于某些朋友 id 有效,但对于其他一些用户 id 查询返回空结果。
我认为那些失踪的用户可能有一些隐私设置,不允许应用程序从他们的帐户中提取数据。
有什么想法吗?
I'm trying to grab the Facebook pages that my friends liked.
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())
I noticed that some data is missing from the result set, therefore I queried the table for individual user ids, as follows:
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid={id1}
SELECT uid,page_id,type,profile_section,created_time FROM page_fan WHERE uid={id2}
...
Apparently for some friend ids is working, but for some others the query returns empty result.
I thought that maybe those missing users have some privacy settings not allowing apps to pull data from their accouns.
Any thoughts?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您在发出此请求时是否使用有效的访问令牌?
如果您查看 page_fan 表的文档,它会解释需要哪些访问令牌
https:// /developers.facebook.com/docs/reference/fql/page_fan/
Are you using a valid access token when making this request?
If you look at the documentation for the page_fan table it explains what access tokens are needed
https://developers.facebook.com/docs/reference/fql/page_fan/