Facebook fql.query 始终为空结果

发布于 2024-12-09 22:57:37 字数 1030 浏览 0 评论 0原文

我正在编写一个应用程序来查询数十个应用程序的见解；无论我尝试哪个见解表查询，我总是得到一个空结果集。没有错误。其他表（例如页面、应用程序）确实可以正常工作。谁能发现我缺少什么吗？

header('Content-type: text/plain');

//有效：

$q = 'SELECT app_id, api_key, canvas_name, display_name FROM application WHERE app_id="111"';

//无效：

$q = "SELECT metric, value FROM insights WHERE object_id='111' AND metric='page_active_users' AND period='604800' AND end_time='1318615472'";

//代码：

require_once '../../scg_common/facebook/facebook.php';
$facebook = new Facebook(array(
    'appId'  => '111', 
    'secret' => '222', 'cookie' => true, 
    ));
$facebook->getAccessToken();
$facebook->getSignedRequest();

$params = array( 
    'method' => 'fql.query', 'query' => $q, 
//'callback' => null, 'format' => '', 'access_token' => '',
    );

try{
    $result = $facebook->api($params);   }
catch(Exception $o){
    var_dump($o);  }

var_dump($result);

原文

I'm writing an app to query insights for several dozen applications; no matter which of these insights table queries I try, I always get an empty result set. No errors. Other tables (eg page, application,) do work fine. Can anyone spot what I'm missing?

header('Content-type: text/plain');

//WORKS:

$q = 'SELECT app_id, api_key, canvas_name, display_name FROM application WHERE app_id="111"';

//DOESN'T WORK:

$q = "SELECT metric, value FROM insights WHERE object_id='111' AND metric='page_active_users' AND period='604800' AND end_time='1318615472'";

//CODE:

require_once '../../scg_common/facebook/facebook.php';
$facebook = new Facebook(array(
    'appId'  => '111', 
    'secret' => '222', 'cookie' => true, 
    ));
$facebook->getAccessToken();
$facebook->getSignedRequest();

$params = array( 
    'method' => 'fql.query', 'query' => $q, 
//'callback' => null, 'format' => '', 'access_token' => '',
    );

try{
    $result = $facebook->api($params);   }
catch(Exception $o){
    var_dump($o);  }

var_dump($result);

分享到QQ

分享到微博