excellent find Erica!
My sheet is fed by the importData function from another web page:
=ImportData("http://ichart.finance.yahoo.com/table.csv?s=
%5EDJI&a=09&b=1&c=2008&d=11&e=15&f=2008&g=d&ignore=.csv")
i.e. yahoo historic stock index data.
hope that helps
On Dec 31, 3:48 am, EricaJoy <[email protected]> wrote:
> Hi Rutherford,
>
> I ran into the same problem today and started fiddling with the
> worksheet id. For some reason it accepts 1 as a value as opposed to 0
> (which is what gdata claims is the ID of the worksheet when asked).
>
> So I poked at your url and replaced 'Data' with 1 and it looks like it
> works.http://spreadsheets.google.com/feeds/list/pX2uQnZhNMk_s3GJCJq6bXA/1/p...
>
> By chance is your sheet fed by a form? Mine is and I'm wondering if
> thats whats causing it to misbehave.
>
> -Erica
>
> On Dec 24, 5:59 am, rutherford <[email protected]> wrote:
>
>
>
> > Thanks for the response, please keep me posted.
>
> > I renamed the first worksheet to 'Data' so this is why I use 'Data' in
> > the url instead of 'default', and the query string '?alt=json' as that
> > is ultimately how I want to get my data via the api.
>
> > On Dec 23, 2:12 am, Trevor Johns <[email protected]> wrote:
>
> > > On 2008-12-22 18:08:20 -0800, Trevor Johns <[email protected]> said:
>
> > > > On 2008-12-19 10:07:28 -0800, rutherford <[email protected]> said:
>
> > > >> What does the returned error message "Invalid query parameter value
> > > >> for grid-id" mean when I try to query my public doc?
>
> > > >> I try to lookup
> > > >>http://spreadsheets.google.com/feeds/list/pX2uQnZhNMk_s3GJCJq6bXA/Dat...
>
> > > directly
>
> > > in
>
> > > >> my browser and then I get that message. Why am I not
> > > >> getting a json object?
>
> > > > Hi Rutherford,
> > > > Sorry for the delay in responding.
>
> > > > That is odd. I'm not sure how to debug that, so I'll need to consult
> > > > with some of the engineers from the Spreadsheets team. However, due to
> > > > the upcoming Christmas/New Years holidays, that might take some time.
>
> > > > I'll post a followup here once I hear anything.
>
> > > On second thought, where did you get that URL? It doesn't look quite
> > > right.
>
> > > Try this
> > > instead:http://spreadsheets.google.com/feeds/list/pX2uQnZhNMk_s3GJCJq6bXA/def...
>
> > > --
>
> > > Trevor Johns- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" 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-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
