xcode - Getting JSON from google spreadsheets -


i want json of google spreadsheet. published to app @ this url. after researching,i tried retrieving json using code

nsstring *theurl = @"https://spreadsheets.google.com/feeds/list/1gnmdd6l0pcmo-zdulf8wy3xwcmrqbxmzrfi5l06j38u/od6/public/full?alt=json"; nsstring *thefile = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:theurl] encoding:nsutf8stringencoding error:nil]; nslog(@" %@",thefile); 

however didn't work. getting null. not sure if wrong code or url. if there wrong code please correct me. if wrong url tell me how right url.

edit

this new link json. however, not getting values in sheet. getting other random stuff. how values sheet?

ahh yes know how this! however, google apps script. app script can call code access spreadsheet remotely. using:

var spreadsheet = spreadsheetapp.openspreadsheetbyid("your id"); 

then have ability edit , view data want on spreadsheet


Comments

Popular posts from this blog

python - Healpy: From Data to Healpix map -

c - Bitwise operation with (signed) enum value -

xslt - Unnest parent nodes by child node -