Skip to content
This repository has been archived by the owner on Feb 5, 2024. It is now read-only.

Empty Response #34

Closed
localjo opened this issue Dec 5, 2013 · 2 comments
Closed

Empty Response #34

localjo opened this issue Dec 5, 2013 · 2 comments

Comments

@localjo
Copy link

localjo commented Dec 5, 2013

I copied the simple example shown in the examples directory. It works fine with the included public_spreadsheet_url, but as soon as I replace that with the URL of my spreadsheet, https://docs.google.com/spreadsheet/pub?key=0Alz1sw-5qPXHdGRyWTNsZmNsSG9MVjdlN2dmSUtDV0E&output=html, the alert says that 0 rows have been processed, and the console.log shows an empty object.

I double checked that the spreadsheet is public, and I tested the spreadsheet URL in an incognito window too just to be sure.

I've been scouring this project's docs on GitHub looking for an answer, but I've got nothing. Any ideas?

@jengalas
Copy link

jengalas commented Dec 5, 2013

It looks like your first two rows are empty. According to the readme:

Empty rows are trouble. If you have a row that's completely empty, Google doesn't return any rows after the empty row. As a result, you need to make sure every line in your spreadsheet has data in it.

Try removing those empty rows and see if it works then.

@localjo
Copy link
Author

localjo commented Dec 5, 2013

That was it! I totally missed that! Sorry! And thanks!

@localjo localjo closed this as completed Dec 5, 2013
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants