FQL Post Insights 不返回任何内容

发布于 2024-12-18 23:55:53 字数 801 浏览 1 评论 0原文

我试图找出为什么获取帖子见解的简单 FQL 查询失败。我有manage_pages和read_insights权限，facebook不会给我任何关于我做错了什么的提示：

    $query1 = "SELECT post_id, message, created_time, attachment FROM stream WHERE actor_id='XXXXXXXX' and source_id='XXXXXXXXX' order by created_time";
    $query2 = "SELECT object_id, metric, value FROM insights WHERE object_id IN (SELECT post_id FROM #query1) AND metric = 'post_impressions_unique' AND end_time=end_time_date('2011-11-28') AND period=period('lifetime')";
    $queries = '{
    "query1": "' . $query1 . '",
    "query2": "' . $query2 . '"
    }';
    $data = $facebook->api_client->fql_multiquery($queries);

当我查看$data时，我看到很多关于结果的帖子$query1，而我没有看到 $query2 的结果。

我不明白我做错了什么。有人可以帮忙吗？

谢谢！

数据仓库

原文

I'm trying to figure out why a simple FQL query to get post insights is failing. I have manage_pages and read_insights permissions, and facebook won't give me any hints as to what I'm doing wrong:

    $query1 = "SELECT post_id, message, created_time, attachment FROM stream WHERE actor_id='XXXXXXXX' and source_id='XXXXXXXXX' order by created_time";
    $query2 = "SELECT object_id, metric, value FROM insights WHERE object_id IN (SELECT post_id FROM #query1) AND metric = 'post_impressions_unique' AND end_time=end_time_date('2011-11-28') AND period=period('lifetime')";
    $queries = '{
    "query1": "' . $query1 . '",
    "query2": "' . $query2 . '"
    }';
    $data = $facebook->api_client->fql_multiquery($queries);

When I look at $data, I see many posts for the results of $query1, and I see nothing for the results of $query2.

I don't understand what I'm doing wrong. Can anyone help?

Thanks!

分享到QQ

分享到微博