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!
