I don't want to hardcode this data. It is coming from a Google Spreadsheet and needs to be generic so any spreadsheet can be read from. I'm really just using the Visualization API as an easy way to get the data from the spreadsheet. Not building a visualization with it at all.
On Dec 20, 4:30 am, ChartMan <[email protected]> wrote: > So now I realize that you are using a structure that is not completely > aligned with the data table model. > Try the following > > var data = new google.visualization.DataTable(); > data.addColumn('timeofoday', 'startTime'); > data.addColumn('timeofoday', 'endTime'); > data.addColumn('string', 'title'); > data.addColumn('string', 'location'); > data.addRows([[ [8, 30, 0], [14, 0, 0], "CASE District VI Board > Meeting", "Pershing > Place North"], > [ [8, 45, 0], [14, 30, 0], "CASE District VII Board > Meeting", "Pershing Place South"]]); > > Then you can use data.toJSON() like stated above. > > ChartMan > > > > > > > > On Sun, Dec 19, 2010 at 5:59 PM, Peppi <[email protected]> wrote: > > Thanks. That will do in a pinch, but the property names that toJSON > > generates aren't very intuitive. Is there a way to convert this: > > > json.rows[0].c[0].f > > json.rows[0].c[1].f > > > to this: > > > json.rows[0].startTime.value > > json.rows[0].endTime.value > > > Thanks. > > > On Dec 19, 9:46 am, ChartMan <[email protected]> wrote: > > > The data table toJSON method returns a Json object in its string format. > > > If you want to get the object for that string you can use > > eval(jsonString) > > > or the safer method JSON.parse(jsonString) > > > > ChartMan > > > > On Fri, Dec 17, 2010 at 11:29 PM, Peppi <[email protected]> wrote: > > > > Hi, > > > > > I'm using the Visualization API to pull data from a Google > > > > Spreadsheet. I then need to turn the DataTable that is returned into > > > > JSON. I tried using the toJSON() function, but after I do this, I > > > > can't seem to access any members of the JSON object. I don't think > > > > this function works, and I don't really want to use it anyway. I would > > > > prefer to use the labels (column headings) as property names. > > > > > I want to be able to create a JSON object with the following format, > > > > but startTime, endTime etc. would change depending on the spreadsheet > > > > that I am reading from. I don't want this to be tied to a specific > > > > spreadsheet or format. > > > > > { > > > > "rows": [ > > > > { > > > > "startTime": "8:30 AM", > > > > "endTime": "2:00 PM", > > > > "title": "CASE District VI Board Meeting", > > > > "location": "Pershing Place North" > > > > } > > > > { > > > > "startTime": "8:30 AM", > > > > "endTime": "2:00 PM", > > > > "title": "CASE District VI Board Meeting", > > > > "location": "Pershing Place North" > > > > } > > > > ] > > > > } > > > > > How can I create this from the DataTable? > > > > > Thanks. > > > > > -- > > > > 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]<google-visualization- > > > > api%[email protected]><google-visualization- > > api%[email protected] <api%[email protected]>> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/google-visualization-api?hl=en. > > > -- > > 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]<google-visualization- > > api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. -- 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.
