Re: JSON output of private spreadsheet?

[Ken Ficara]

If there is, I haven't figured it out.  There doesn't seem to be a way 
to use the get method APIs with oauth.

My answer was to pull the data via the normal API, and then turn it into 
JSON. the Google data table object goes to JSON fairly easily. good luck.

On 11/2/12 11:02 , Fernando Troya wrote:
Hi,

I'm experiencing a similar problem. Is there any way to get a given
sheet in JSON format authenticating with OAuth in Google Spreasheets API v3?

Thanks

El viernes, 18 de marzo de 2011 12:31:20 UTC-3, Vic Fryzel escribió:

    It only works for public sheets because public sheets can be
    accessed without authorization.  You're not authorizing when pulling
    the /private URL, and thus a 404 is returned.

    A 404 is returned even though authorization is required so that
    unauthorized people cannot tell if a spreadsheet of a given key
    exists or not.

    Thanks,
    -Vic



    On Tue, Mar 15, 2011 at 7:31 PM, Ken Ficara <k...@harmoni.ca
    <javascript:>> wrote:

        I want to get a values feed for a worksheet in a private
        spreadsheet. I'm authenticated using AuthSub.

        This URL returns 404:

        
https://spreadsheets.google.com/feeds/worksheets/tWtWxA6yuPfjq7WaRhHfhdQ/private/values/od6?alt=json
        
<https://spreadsheets.google.com/feeds/worksheets/tWtWxA6yuPfjq7WaRhHfhdQ/private/values/od6?alt=json>

        This URL returns JSON (this particular spreadsheet is public,
        but the ones I want to work with are not):

        
https://spreadsheets.google.com/feeds/worksheets/tWtWxA6yuPfjq7WaRhHfhdQ/public/values/od6?alt=json
        
<https://spreadsheets.google.com/feeds/worksheets/tWtWxA6yuPfjq7WaRhHfhdQ/public/values/od6?alt=json>

        Why does the JSON output only work for public spreadsheets? Or
        am I doing something wrong?




--
Ken Ficara | Harmonica, LLC
718.513.9486 | www.harmoni.ca