s/worksheetId=0/od6 and you should be good
-Vic On Tue, Feb 15, 2011 at 2:29 PM, Joe <[email protected]> wrote: > I'm no perl/python/php whiz; I develop mostly in AppleScript (a bit of > JavaScript & XSLT here & there). I'm trying to access the contents of a > published spreadsheet using a curl -G (GET) command. > > Accessing the entire sheet works great. I can do, for example: > > *set* myScript *to* "curl -G ' > https://spreadsheets.google.com/pub?key=0At...key truncated > here...BLNEE&hl=en&single=true&gid=0&output=html'" > > *set* myData *to* (*do shell script* myScript) > > ...and get a dump of the the spreadsheet HTML. > > However, if I try, for example: > > *set* myScript *to* "curl -G ' > https://spreadsheets.google.com/feeds/list/key=0At...key truncated > here...BLNEE/worksheetId=0/public/basic/rowID=3'" > > *set* myData *to* (*do shell script* myScript) > > > ...I get the error > > > The spreadsheet at this URL could not be found. Make sure that you have the > right URL and that the owner of the spreadsheet hasn't deleted it. > > > Is what I'm trying possible/feasible? Any suggestions? > > Thanks! >
