search

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
234 stars 46 forks source link

Only exports the last row of my sheet? #117

Closed rowe-morehouse closed 4 years ago

rowe-morehouse commented 4 years ago

Cool add-on, thanks for making this.

Trying to export to JSON, and your add-on formats it how I want it, but it only exports the last row in the sheet?

settings: JSON, Current Sheet, Nested Elements

Here is the sheet:

https://docs.google.com/spreadsheets/d/1IM-0ouC3-t3QbeCh2iBJW6fhSbLNLdCgAWe5kMauLIg/edit?usp=sharing

I read all the docs, but still no clue what I am doing wrong! thank you for having a look.

Synthoid commented 4 years ago

I duplicated your initial tab and added the NA_ prefix to its name. If you visualize the data does it look like what you need?

The issue you are seeing is a common one with Nested Elements. Basically each row of the sheet is overwriting the previous row due to key formatting issues.

rowe-morehouse commented 4 years ago

Nice one! … you just made my day a lot better! thank you.

Synthoid commented 4 years ago

Glad I could help!