that page is out of date On Thursday, July 11, 2013 7:05:49 PM UTC+1, trybka wrote: > > Here's a little more info on using Spreadsheets as a DataSource URL: > https://developers.google.com/chart/interactive/docs/spreadsheets > > Thomas Rybka | Software Engineer | [email protected] <javascript:> | > Google > > > On Thu, Jul 11, 2013 at 12:44 PM, asgallant > <[email protected]<javascript:> > > wrote: > >> Sorry, I screwed up that post. The key for that spreadsheet is >> "0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE". I think I used two >> different sources when putting that post together, and apparently didn't >> reconcile them. >> >> >> On Thursday, July 11, 2013 1:43:57 AM UTC-4, Tim Noell wrote: >>> >>> Sorry for my ignorance, but I have an obvious question. In asgallant's >>> answer, the example URL given is: >>> https://docs.google.com/**spreadsheet/ccc?key=0AiFfbdok-** >>> kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE#gid=0<https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0> >>> >>> but then he says the "key" parameter from that URL is: >>> pCQbetd-CptGXxxQIG7VFIQ >>> >>> However, I don't see the string "pCQbetd-CptGXxxQIG7VFIQ" anywhere in >>> the key=<string> part of the original URL. >>> Rather, I see: >>> key=0AiFfbdok-**kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE<https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0> >>> >>> What am I missing? >>> T. >>> >>> >>> On Tuesday, May 7, 2013 8:13:15 PM UTC-4, asgallant wrote: >>>> >>>> What you actually need from the gadget is the key to your spreadsheet, >>>> which is in the spreadsheet's URL; using a gadget is a wholly unnecessary >>>> extra step. As an example, to query this spreadsheet: https://docs.** >>>> google.com/spreadsheet/ccc?**key=0AiFfbdok-** >>>> kQKcENRYmV0ZC1DcHRHWHh4UUlHN1Z**GSVE#gid=0<https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0>, >>>> >>>> you pull out the "key" parameter ("pCQbetd-CptGXxxQIG7VFIQ" in this case) >>>> and plug it into the data query url >>>> (http://spreadsheets.google.**com/tq?key=<key >>>> here> <http://spreadsheets.google.com/tq?key=%3Ckey+here%3E>). In >>>> this example, you would have a url that looks like this: >>>> https://spreadsheets.**google.com/tq?key=pCQbetd-**CptGXxxQIG7VFIQ<https://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ>. >>>> >>>> You don't need to use a gadget at all. >>>> >>>> On Tuesday, May 7, 2013 8:02:36 PM UTC-4, Paul wrote: >>>>> >>>>> Hello. I noticed that gadgets are being deprecated Without gadgets, >>>>> what is the recommended way to retrieve a "query data source URL" to use >>>>> as >>>>> a Google Charts data source? This documentation: >>>>> >>>>> https://developers.google.com/**chart/interactive/docs/** >>>>> spreadsheets#Google_**Spreadsheets_as_a_Data_Source<https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source> >>>>> >>>>> instructs the user to temporarily install a gadget in order to >>>>> retrieve the URL. Once gadgets are gone, what is the best way to >>>>> accomplish the same goal? >>>>> >>>>> Thank you! >>>>> >>>>> - Paul >>>>> >>>> -- >> You received this message because you are subscribed to the Google Groups >> "Google Visualization API" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]<javascript:> >> . >> To post to this group, send email to >> [email protected]<javascript:> >> . >> Visit this group at >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > >
-- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
