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

Post a Comment

Popular posts from this blog

amazon web services - S3 and apache mod_proxy with basic authentication -

-
i'd redirect s3 bucket in ssl basic authentication of files (apk files) apache mod_proxy. ssl , mod_proxy work, basic authentication ignored. <virtualhost *:443> servername resources.mydomain.jp <filesmatch "\.apk$"> order deny,allow setenvif user-agent ".*android.*" allow_ag options followsymlinks allow env=allow_ag deny authtype basic authname "secret zone" authuserfile /etc/httpd/.htpasswd require user xxx_customer </filesmatch> sslengine on sslproxyengine on sslprotocol -all +sslv3 +tlsv1 sslciphersuite all:!adh:rc4+rsa:+high:+medium:-low:-sslv2:-exp sslcertificatefile conf.d/xxx.cer sslcertificatekeyfile conf.d/xxx.key sslcacertificatefile conf.d/xxx.cer proxypass / http://resources.mydomain.jp.s3-website-ap-zone-1.amazonaws.com/ proxypa...
Read more

How to install ruby on rails -

-
i newbie ruby on rails, here trying install ruby on rails on windows 7 64 bit. installed ruby installer , installed rails. , created new app files. when start rails server showing following errors. how can rid of these errors , start developing ruby application? c:\users\walnut\desktop > bundle install fetching gem metadata https://rubygems.org/............ fetching version metadata https://rubygems.org/... fetching dependency metadata https://rubygems.org/.. resolving dependencies................. using rake 10.4.2 using i18n 0.7.0 installing json 1.8.3 native extensions gem::installerror: 'json' native gem requires installed build tools. please update path include build tools or download devkit 'http://rubyinstaller.org/downloads' , follow instructions @ 'http://github.com/oneclick/rubyinstaller/wiki/development-kit' error occurred while installing json (1.8.3), , bundler cannot continue. make sure `gem install json -v '1.8.3'` succeeds be...
Read more

powershell - This solution contains one or more assemblies targeted for the global assembly cache -

-
Image
i having sharepoint site deployed through sharepoint powershell. wsp build through visual studio 2013. all projects in solution not signed assemblies(project->right click->properties->signing->sign assemblies check box unchecked). taking wsp of solution publishing , deploying sharepoint using sharepoint powershell. when try this, getting following error: when googled solution. many of them suggesting check 'sign assemblies' check box. don't want do, because facing other issues packages install through nugget. sign libraries of solution go properties of project click signing tab , check sign libraries options , create new strong name file or without password , rebuild , deploy.
Read more