JSON data from google spreadsheet
I'm not sure about the way you're doing it but it can be accomplished a different way. Please see this fiddle using your example data, and below for the code.
Basically you call the JSON data from your spreadsheet with the below HTML script tags.
<script src="http://spreadsheets.google.com/feeds/list/0An1-zUNFyMVLdEFEdVV3N2h1SUJOdTdKQXBfbGpNTGc/1/public/values?alt=json-in-script&callback=importGSS"></script>
Please note I'm linking to a copy of your spreadsheet as it requires it to by published
Then the you can handle the data with the below script.
function importGSS(json){ for(var i = 0; i < json.feed.entry.length; i++){ var entry = json.feed.entry[i]; $('#departments').append('<option>' + entry.gsx$subdivision.$t + '</option>'); $('#subject').append('<option>' + entry.gsx$section.$t + '</option>'); $('#services').append('<option>' + entry.gsx$station.$t + '</option>'); }}
You can obviously adapt to your own needs.