Hi NoobyOne, The very important documentation you seek is in the "Reference Guide". It is only now available via the Wayback Machine (yay!) at [1]. It was (probably accidentally) removed by Google when re-hosting the spreadsheet API materials from code.google.com to developer.google.com, and they haven't thought it important to put it back yet, although Giacomo notified them a couple of days after the refactoring [2]. I have taken the liberty of filing an issue, and you can vote for it at [3] if (like me) you are a person of character who will engage in futile acts simply because they are the right thing to do.
To answer your particular questions: 1. HTTP, URLs and XML/ATOM: Yep, all the way. 2. No OAuth for public URLS: Right. 3. The SS Key: Can be gotten from the URL of a Spreadsheet when viewing it in the browser. Or from the Documents List API. 4. The Worksheet Key: Can only be gotten by querying and parsing the "worksheets feed" of the spreadsheet. As a hint, if you're on Java, it's worth nutting out the google-api-java-client library [4] ... will save you a lot of hackwork and might put you in a reasonable position when the API changes to v4 at some unspecified date in the future. HTH, David. [1] Wayback Machine's copy of the Reference Guide: http://web.archive.org/web/20100211022141/http://code.google.com/apis/spreadsheets/data/3.0/reference.html [2] Conversation where Giacomo laments the loss of the Reference Guide: https://groups.google.com/d/topic/google-spreadsheets-api/9Sr4hm3QEuw/discussion [3] Issue asking Google to restore the Spreadsheet Reference Guide http://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=3075 [4] The google-api-java-client library http://code.google.com/p/google-api-java-client/ On Thu, May 3, 2012 at 12:48 PM, NoobyOne <[email protected]> wrote: > Hi All! I'm just trying to get started with the spreadsheet API and have a > few ???'s > I read through the > documentation<https://developers.google.com/google-apps/spreadsheets/#adding_a_list_row> > (which > seems to be written for those with a little more experience) but didn't > find some answers. > > 1. I will be using the api at protocol level. If I understand it right > it will be strictly http get and post urls. Right? > 2. I will not be accessing non public spreadsheets so can I completely > bypass all the OAuth stuff? > 3. when structuring my http gets and post how do I tell it what > spreadsheet to access? is "/key/" replaced with the spreadsheet key? > 4. Also how do I tell it which worksheet to access? Is "/worksheetId/" > replaced with the name of the worksheet? > > thanks in advance! >
