ruby - Facebook FQL returns <fql_query_response list="true"/> -


I'm trying to get a Facebook panel query to work using the browser, I have a valid Oeth The token is (I can make the graph with the API call).

Here's the url I've tried:

  https://api.facebook.com/method/fql.query?query=SELECT Metric, Object from Insights WHERE object_ID = 89192912655 and end_time = 1280430050 and duration = 86400 and metric = 'Page_fans' & amp; Access_token =?  

I tried to run the fql query via a SQL Encoder first:

  https://api.facebook.com/method/fql .query? Query = Select% 20metric% 2C% 20value% 20FROM% 20insights% 20WHERE% 20object_id% 3D89192912655% 20and% 20end_time% 3D1280430050% 20AND% 20period% 3D86400% 20AND% 20metric% 3D'page_fans' & amp; ACCESS_TOKEN =?  

I tried some other metrics, I can also get the metric through the graph API, so I know that they are there.

I am sure that something is silly, but I have been stumped for a while! Every call just gives it:

  & lt ;? XML version = "1.0" encoding = "UTF-8"? & Gt; & Lt; Fql_query_response xmlns = "http://api.facebook.com/1.0/" xmlns: xsi = "http://www.w3.org/2001/XMLSchema -instance" list = "true" />  

Maybe my date is a problem, I used it to get it: (ruby)

  t = time.now = & Gt; Tuesday August 03 15:00:50 -0400 2010 & gt; & Gt; T = T - 5.days = & gt; Thu July 29 15:00:50 -0400 2010 & gt; & Gt; T.to_i = & gt; 1280430050  

Any ideas?

O people, we have confirmed that this bug is due to this end-time insights table. To return any data, the PST is being aligned with day delimiter. To overcome this issue, we have introduced two custom functions that you can use for insights table queries:

  1. end_time_date (): Accept the string form on DATE ( Like '2010-08-01')
  2. Duration (): Accept 'lifetime', 'day', 'week' and 'month' For example, you can now use these insights table You can ask:

      select metric, price insights WHERE object_id = YOUR_APP_ID and metric That = 'application_active_users' and end_time = end_time_date ('2010-09-01') and duration = duration ('days');  

    We apologize for all the inconvenience about these tasks soon!

    P. s. If you do not want to use the end_time_date () function, please make sure that the end_time timestamp in your query is aligned with the day delimiter in PST.

    Thank you!

    Facebook Insights Team


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -