Can't fetch a data table from a data source using Query

[aerosmile]

Hi,

I am trying to feed my annotated graph with a data table generated by
a separate php file. I thought I should be able to do this by
generating JSON output in the same format as produced by the
spreadsheet that was used in this Playground example:
http://code.google.com/apis/ajax/playground/?type=visualization#ready_event

When I run my code, it works well when it fetches the above URL. As
soon as I direct it to my php file, it produces the following 2 errors
in Firebug:

- Missing query for request id: undefined
- Data Table is not defined

At first I thought it must be something in my code, but then I tried
to simplify my data table to do nothing else other than just replicate
the exact same output produced by the spreadsheet above, and this
still doesn't work. The file I created and its output can be found
here (same output as in the spreadsheet above): http://www.kangoria.com/json.php

At this point, I am starting to think that it must be something about
the headers or some other information that the spreadsheet above is
delivering and my file is not. Any thoughts?

Here is the code I used for the file:

<?php
header("Content-Type: text/plain; charset=UTF-8");
$string = "google.visualization.Query.setResponse
({version:'0.6',status:'ok',sig:'261991901',table:{cols:
[{id:'A',label:'Release Date',type:'date',pattern:'M/d/yyyy'},
{id:'B',label:'Budget (in
dollars)',type:'number',pattern:'#0.###############'},
{id:'C',label:'Gross revenue (in the
US)',type:'number',pattern:'#0.###############'},{id:'D',label:'Movie
name',type:'string',pattern:''}],rows:[{c:[{v:new Date
(1981,10,6),f:'11/6/1981'},{v:5000000.0,f:'5000000'},{v:
4.2365581E7,f:'42365581'},{v:'Time Bandits'}]},{c:[{v:new Date
(1985,11,18),f:'12/18/1985'},{v:1.5E7,f:'15000000'},{v:
9929000.0,f:'9929000'},{v:'Brazil'}]},{c:[{v:new Date
(1989,2,10),f:'3/10/1989'},{v:2.35E7,f:'23500000'},{v:
8000000.0,f:'8000000'},{v:'The Adventures of Baron Munchausen'}]},{c:
[{v:new Date(1991,8,20),f:'9/20/1991'},{v:2.4E7,f:'24000000'},{v:
4.2E7,f:'42000000'},{v:'The Fisher King'}]},{c:[{v:new Date
(1996,2,29),f:'3/29/1996'},{v:2.9E7,f:'29000000'},{v:
5.7141459E7,f:'57141459'},{v:'Twelve Monkeys'}]},{c:[{v:new Date
(1998,4,22),f:'5/22/1998'},{v:1.85E7,f:'18500000'},{v:
1.06E7,f:'10600000'},{v:'Fear and Loathing in Las Vegas'}]},{c:[{v:new
Date(2005,7,26),f:'8/26/2005'},{v:8.0E7,f:'80000000'},{v:
3.7899638E7,f:'37899638'},{v:'The Brothers Grimm'}]}]}});";
echo $string;
?>

Thanks!

[Albert]

I think, that when you fetch your data javascript interpretes it as an string type, you can use eval ( 'var jsonobject = yourdata;');  to turn your string into a json object.

There are other ways to do this. But that worked for me.

[ChartMan]

Hi

The Query API is designed to fetch multiple queries and so each outgoing request is assigned an ID. The data source responding to the request assigns the same ID to its response. In your case your data source is static and so it can not assign a dynamic ID. The simplest way to overcome this obstacle is to use a custom response Handler instead of of the default google.visualization.Query.setResponse(). 

Note that this is tailored to your specific static response case and may fail in other scenarios.

function myResponseHandler(response) {

  var data = new google.visualization.DataTable(response['table']);

  return data;

}

HTH

ChartMan