Yes, changed it and now it seems to work. I have a related question about passing data along with the datatable, will create a new thread about it.
Thanks. On May 11, 1:58 pm, VizGuy <[email protected]> wrote: > So indeed in the last change we remove some support for an old format that > was used before the protocol was published.While we do promise long time > support for documented versions, we can not support cases like this (we did > for a while, but we can't guarantee, and there was enough time to update the > in-house code). > > The change you have to do is quite simple, in fact: > requestId is now reqId. > In addition, please looks at the public protocol docs, to see tthat the > structure of each row was changed: Before, each row was an array of cells. > Now each row is an object, with a property of 'c' that is mapped to the same > array as before (the array that used to be the whole row). This was done to > support row custom properties (among other reasons). > > In addition, please add the version field to the response (you don't have to > at the moment, but it intentionally a part of the protocol, to support later > changes). > > These changes should set you. > > Please try, and let us know if there are still any issues. > > Regards, > VizGuy > > On Mon, May 11, 2009 at 1:11 PM, Kemal <[email protected]> wrote: > > > It's not working for me either, here's a sample JSON: > > > google.visualization.Query.setResponse > > ({requestId:'0',status:'warning',signature:'1242036218',table: > > {cols:[{id:'Z',label:'Label1',type:'s',pattern:'H:00'}, > > {id:'G',label:'Label2',type:'n'},{id:'T',label > > :'Label3',type:'n'},{id:'O',label:'Label4',type:'n'}, > > {id:'M',label:'Label5',type:'n'},{id:'Ma',label:'Label6' > > ,type:'n'}],rows:[[{v:new Date(2009,4,11,0,0,0),f:'0:00'},{v: > > 103257,f:'103,257'},{v:291,f:'291'},{v:0 > > .28182108719,f:'% 0.28'},{v:0.37053251266479492188,f:'0.37'},{v: > > 107.82499694824218750000,f:'107.80 > > '}],[{v:new Date(2009,4,11,1,0,0),f:'1:00'},{v:77137,f:'77,137'},{v: > > 153,f:'153'},{v:0.198348393119 > > ,f:'% 0.19'},{v:0.42410126328468322754,f:'0.42'},{v: > > 64.88749694824218750000,f:'64.80'}],[{v:new > > Date(2009,4,11,2,0,0),f:'2:00'},{v:44598,f:'44,598'},{v:65,f:'65'},{v: > > 0.145746446029,f:'% 0.14'},{v > > :0.31922999024391174316,f:'0.32'},{v: > > 20.75000000000000000000,f:'20.70'}],[{v:new Date(2009,4,11 > > ,3,0,0),f:'3:00'},{v:37736,f:'37,736'},{v:40,f:'40'},{v: > > 0.105999576002,f:'% 0.10'},{v:0.40093749761581420898 > > ,f:'0.4'},{v:16.03750038146972656250,f:'16.00'}],[{v:new Date > > (2009,4,11,4,0,0),f:'4:00'},{v:17224 > > ,f:'17,224'},{v:24,f:'24'},{v:0.139340455179,f:'% 0.13'},{v: > > 0.43333250284194946289,f:'0.43'},{v:10 > > .39999961853027343750,f:'10.30'}],[{v:new Date > > (2009,4,11,5,0,0),f:'5:00'},{v:13569,f:'13,569'},{v > > :14,f:'14'},{v:0.103176357875,f:'% 0.10'},{v: > > 0.30892750620841979980,f:'0.31'},{v:4.32499980926513671875 > > ,f:'4.30'}],[{v:new Date(2009,4,11,6,0,0),f:'6:00'},{v: > > 12409,f:'12,409'},{v:26,f:'26'},{v:0.209525344508 > > ,f:'% 0.20'},{v:0.42355749011039733887,f:'0.42'},{v: > > 11.01249980926513671875,f:'11.00'}],[{v:new > > Date(2009,4,11,7,0,0),f:'7:00'},{v:24916,f:'24,916'},{v:59,f:'59'},{v: > > 0.236795633328,f:'% 0.23'},{v > > :0.36355873942375183105,f:'0.36'},{v: > > 21.45000076293945312500,f:'21.40'}],[{v:new Date(2009,4,11 > > ,8,0,0),f:'8:00'},{v:54949,f:'54,949'},{v:202,f:'202'},{v: > > 0.367613605343,f:'% 0.36'},{v:0.33960375189781188965 > > ,f:'0.34'},{v:68.59999847412109375000,f:'68.50'}],[{v:new Date > > (2009,4,11,9,0,0),f:'9:00'},{v:28829 > > ,f:'28,829'},{v:222,f:'222'},{v:0.770057927781,f:'% 0.77'},{v: > > 0.34752249717712402344,f:'0.35'},{v > > :77.15000152587890625000,f:'77.10'}],[{v:new Date > > (2009,4,11,10,0,0),f:'10:00'},{v:1974,f:'1,974'} > > ,{v:142,f:'142'},{v:7.19351570415,f:'% 7.19'},{v: > > 0.47975251078605651855,f:'0.48'},{v:68.12500000000000000000 > > ,f:'68.10'}],[{v:new Date(2009,4,11,11,0,0),f:'11:00'},{v:0,f:'0'},{v: > > 0,f:'0'},{v:0,f:'0'},{v:0,f > > :'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,12,0,0),f:'12:00'},{v: > > 0,f:'0'},{v:0,f:'0'},{v:0,f:'0'},{v:0 > > ,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,13,0,0),f:'13:00'},{v: > > 0,f:'0'},{v:0,f:'0'},{v:0,f:'0'},{v > > :0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,14,0,0),f:'14:00'},{v: > > 0,f:'0'},{v:0,f:'0'},{v:0,f:'0'} > > ,{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,15,0,0),f:'15:00'},{v: > > 0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,16,0,0),f:'16:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,17,0,0),f:'17:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,18,0,0),f:'18:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,19,0,0),f:'19:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,20,0,0),f:'20:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,21,0,0),f:'21:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,22,0,0),f:'22:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}],[{v:new Date(2009,4,11,23,0,0),f:'23:00'}, > > {v:0,f:'0'},{v:0,f:'0'},{v:0,f:'0' > > },{v:0,f:'0'},{v:0,f:'0'}]]},message:'{\"totals\":\"some html here\", > > \"s1\":\"1241989200\",\"e1\":\"1241989200\",\"s2\":\"1241902800\",\"e2 > > \":\"1241902800\",\"cty\":\"\",\"ty\":\"h\",\"z1\":\"Monday\",\"z2\": > > \"Saturday\"}'}); > > > This is pre-0.5 (I came up with the format examining how google docs > > did it, before you guys made it public) but it was working until last > > night's update. > > > On May 11, 12:45 pm, VizGuy <[email protected]> wrote: > > > Thanks for the info.We are looking, and will be soon back. > > > > VizGuy > > > > On Mon, May 11, 2009 at 12:06 PM, viz-adict <[email protected] > > >wrote: > > > > > Thanks for your response > > > > Unfortunately I have no public link... > > > > > I'm working with > > > > >http://code.google.com/p/google-visualization-php-api/source/browse/t. > > .. > > > > to generate the JSON data > > > > > I paste it here one of the results: > > > > google.visualization.Query.setResponse({version: '0.5',reqId: > > > > '12',sig: '12e87735a77d808155063a9d7326feac',status: 'ok',table: {cols: > > > > [{id: 'fecha',label: 'Fecha',type: 'date'},{id: 'blog',label: > > > > 'Bloc',type: 'number'},{id: 'book',label: 'Book',type: 'number'},{id: > > > > 'course',label: 'Curs',type: 'number'},{id: 'label',label: > > > > 'Etiqueta',type: 'number'},{id: 'lesson',label: 'Lesson',type: > > > > 'number'},{id: 'resource',label: 'Recurs',type: 'number'}],rows:[{c: > > > > [{v: new Date(2008, 8, 19)},,,,{v: 43},,{v: 123}]},{c:[{v: new Date > > > > (2008, 8, 26)},,,,{v: 255},,{v: 1315}]},{c:[{v: new Date(2008, 9, 3)},, > > > > {v: 8},,{v: 189},{v: 4},{v: 1403}]},{c:[{v: new Date(2008, 9, 10)},, > > > > {v: 1},,{v: 179},{v: 3},{v: 1170}]},{c:[{v: new Date(2008, 9, 17)},, > > > > {v: 8},,{v: 123},{v: 3},{v: 1064}]},{c:[{v: new Date(2008, 9, 24)},, > > > > {v: 1},,{v: 122},,{v: 970}]},{c:[{v: new Date(2008, 9, 31)},,{v: 4},, > > > > {v: 100},{v: 1},{v: 987}]},{c:[{v: new Date(2008, 10, 7)},,{v: 3},,{v: > > > > 97},{v: 2},{v: 967}]},{c:[{v: new Date(2008, 10, 14)},,{v: 5},,{v: > > > > 85},,{v: 897}]},{c:[{v: new Date(2008, 10, 21)},,{v: 3},,{v: 100},,{v: > > > > 865}]},{c:[{v: new Date(2008, 10, 28)},,,,{v: 76},,{v: 754}]}]}}); > > > > > And this is what FireBug 1.3.3 gives me > > > > ---------------------------------------------------- > > > > missing ) in parenthetical > > > > ;) > > > > ----------------------------------------------------- > > > > (No changes were made in my code for the past 6 days...) > > > > > :-( > > > > > On May 11, 10:27 am, VizGuy <[email protected]> wrote: > > > > > Hi, > > > > > Can you please provide some more info? > > > > > We did push to production last night a few minor changes that were on > > the > > > > > test version for a few days. > > > > > This should have no affect on users, but if it did cause any > > undesired > > > > > impact please provide more details, like the errors you get, and if > > > > > possible, some links to the application (only if public, of course). > > > > > > Regards, > > > > > VizGuy > > > > > > On Mon, May 11, 2009 at 10:54 AM, viz-adict < > > [email protected] > > > > >wrote: > > > > > > > Help! > > > > > > > My application doesn't work today!!! > > > > > > > Firebug launches errors on line 232, 263 of > > >http://www.google.com/uds/api/visualization/1.0/28bfe89c82011ce9762b7. > > > > .. > > > > > > > any idea???? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
