You don't have to use the JSON format. You can use the datatable methods addColumns (to define the table columns) and addRow for each data row Ref for that you can find here: http://code.google.com/apis/chart/interactive/docs/reference.html#DataTable
On 4 בנוב 2011, at 21:55, jim <[email protected]> wrote: I'm trying to migrate a report to Google's chart api. I'm having a beginner JS issue with JSON's that I haven't been able to find a solution for. I'm using a server side scripting page that will pass the results of a retrieve object request. The results are in JSON format similar to this. {"0":[{"SendID":1185402,"EmailName":"SomeName0","EmailCount":0}]} Google's data example wants this information to look like this in the Row: {"rows": [{"c":[{"v":"someString0"},{"v":"someString1"},{"v":0}]}]} I've solved the "col" format, but manipulating the "retrieve" data to fit the "row" format has me stumped. So ideally I would like to insert the value of SendID into someString0, value of EmailName into someString1, and the value of EmailCount into 0 Thanks for any advice, I hope this provided enough detail. -- 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. -- 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.
