Jinji and Vladimir, The method using SPServices seems to me too much for something that could be done via QueryObjects (http://code.google.com/intl/pt-BR/apis/ visualization/documentation/reference.html#queryobjects).
I could query the SharepointList's RSS (a plain XML file) via sendMethod='xhr' and send the response to a DataTable: There is a sample in the Code Playground (http://code.google.com/apis/ ajax/playground/?type=visualization#using_the_query_language) but only for GoogleSpreedsheets. I was trying to find out how this would look if i was using a XML file instead. Everything I tryed resulted in a blank screen. function drawVisualization() { var query = new google.visualization.Query('https://<mydomain>/ <my_xml_file>.xml', {sendMethod:'xhr'}); query.send(handleQueryResponse); } function handleQueryResponse(response) { var data = response.getDataTable(); visualization = new google.visualization.LineChart(document.getElementById('visualization')); visualization.draw(data, {legend: 'bottom'}); } Can someone give an insight? Thanks a lot. On 4 set, 17:26, Jinji <[email protected]> wrote: > I'm not really familiar with Sharepoint, but I can say that Google > Visualization API has no native support for it. You'll have to read the data > from Sharepoint using whatever methods Sharepoint provides for reading the > data (or other tools, such as the suggested SPServices library), and then > build a > DataTable<http://code.google.com/apis/visualization/documentation/reference.htm...>from > it yourself. > > On Fri, Sep 3, 2010 at 10:34 PM, João Paulo Alquéres <[email protected]> wrote: > > > > > Hi, > > > I would like to know if it is possilbe to natively load a Sharepoint > > custom list in a GoogleVizApi DataTable to be used later to draw a > > chart. > > > Something like: > > > var dt = new > > google.visualization.DataTable.FetchData("SharepointList";"SharepointView") > > > where FetchData would be a native method to catch the Sharepoint List > > and put it into a DataTable using Columns and Rows as values. > > > A workaround would be to use Sharepoint's native support for RSS (a > > standard xml file). > > Every list in sharepoint has a specific RSS file that could be used to > > load the data like: > > > var dt = new > > google.visualization.DataTable.FetchXML("SharePointList.xml") > > > I dont know if either one of the data sources (sharepoint/xml) are > > natively supported by the Google Visualization API, so I would > > appreciate your help. > > > Best regards, > > Paulo. > > > -- > > 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.
