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 -~----------~----~----~----~------~----~------~--~---
