google.visualization.Query is to query servers that implement a "data source", which is not your case. You can read the XML file using regular JavaScript ways, and write some JS code that would build the DataTable from the XML content.
Alternatively you could build a server that will implement<http://code.google.com/apis/visualization/documentation/dev/implementing_data_source_overview.html>a data source. It's more complicated, but it gives you more power (which may or may not be relevant in your case). On Sun, Sep 5, 2010 at 3:54 AM, João Paulo Alquéres <[email protected]> wrote: > 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]><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.
