Import JSON data into Google Spreadsheet

Posted by Jeremy Petzold on Stack Overflow See other posts from Stack Overflow or by Jeremy Petzold
Published on 2010-04-17T15:50:52Z Indexed on 2010/04/17 15:53 UTC
Read the original article Hit count: 580

Filed under:

google-app-engine

|

google-spreadsheet

|

google-apps-script

|

JavaScript

I am pulling data down from a webservice and it is formated as JSON. I am writing a google apps script for google spreadsheet that will populate the data form me. my problem is, I can't seem to get it to parse out.

doing:

var dataset = myJSONtext;
Browser.msgbox(dataset.item[0].key);

errors out, saying item[0] is not defined.

Is there some built in way I should be doing this?

Any help would be apreciated.

© Stack Overflow or respective owner

Related posts about google-app-engine

unittest import error with virtualenv + google-app-engine-django

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working with google-app-engine-django + zipped django. Just running "python manage.py test" succeeded without error. But with virtualenv, test was failed with "import unittest error". same error with Django 1.1. - OSX 10.5.6 - google-app-engine-django (r101 via svn) : r100 was failed with launcher… >>> More
Could not import Django settings into Google App Engine

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all you Google App Engine experts, I have used Django a little before but am new to Google App Engine and am trying to use it's development web server with Django for the first time. I don't know if this is relevent but I previously had Django 1.1 and Python 2.6 on my Windows XP and even… >>> More
How does Google App Engine precompile Java ?

as seen on Stack Overflow - Search for 'Stack Overflow'
App Engine uses a "precompilation" process with the Java bytecode of an app to enhance the performance of the app in the Java runtime environment. Precompiled code functions identically to the original bytecode. Is there any detailed information what this does? >>> More
Creating a session scoped bean in Google App Engine using Spring 2.5

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to create a session bean in spring mvc. I am having the following error message when I run my google app engine server in my local box: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'siteController' defined in ServletContext resource [/WEB-INF/springapp-servlet… >>> More
Google App Engine UI Widgets

as seen on Stack Overflow - Search for 'Stack Overflow'
Are there any UI widgets available to the python side of Google App Engine? I'd like something like the collapsed/expanded views of Google Groups threads. Are these type things limited to the GWT side? >>> More

Related posts about google-spreadsheet

Run Google-apps-script on Google-Spreadsheet event?

as seen on Stack Overflow - Search for 'Stack Overflow'
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don't know if Google spreadsheet supports any events. For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way… >>> More
Google Spreadsheet multiple column filter using OR

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Google Spreadsheet with 3 columns which are either blank or have a value. I want to get the count of the number of rows that has A and either B or C populated. If I were writing a SQL query it would be select count(*) from Table where A is not null and (B is not null or C is not null) But… >>> More
Google Apps Script - Sending Google Spreadsheet Row to Email

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to write a script using Google Apps Script (Javascript) for a Google spreadsheet. I am trying to do the same thing that is shown in this tutorial [http://www.google.com/google-d-s/scripts/sending_emails.html][1], but each row in my spreadsheet has 24 columns. I would like to send… >>> More
Using Google Spreadsheet API on Blackberry

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to build a Google spreadsheet synchronization feature on a blackberry application that I am building. Not being a pro I was hunting for some sample code to get a grasp of the flow but I could not. When I am using the API from Google to access spreadsheets, it suggests to use the SpreadsheetService… >>> More
Where is the script editor in google spreadsheet?

as seen on Super User - Search for 'Super User'
Hello I just stumbled upon this link and wanted to try it out. Yet, if I open a google spreadsheet, I have no scripts submenu under the tools menu. This was with firefox 3.0.15 and IE 7. Unfortunately, I didn't find anything that indicated why there wouldn't be such menus with my spreadsheets. Does… >>> More