Synthoid/ExportSheetData

Infinite compiling ?

Closed this issue · 6 comments

elTRexx commented

Hi, I try to have this Json

{
  "MarieCurie": {
    "Win": [
      {"FR": "Super !!",
      "US": "Great !!!"},
      {"FR": "Bravo",
      "US": "Wonderfull"}
    ],
    "Lose": [
      "FR": "Nul !",
      "US": "You sux !"
    ]
  }
}

from this simple google sheet : https://docs.google.com/spreadsheets/d/1f8jilee_U0nh1DvsD2jXdeLskFjgdEEeOALDdAFqIcA/edit?usp=sharing

capture d ecran 2

But When I try to export or visualise the Json, I get infinite compile window (like in screenshot).

It is happening when I use the {#ROW} in key formatting.

Synthoid commented

Well an infinite compile loop is never fun. Are there any errors in your web console?

elTRexx commented

I created a new google sheet, and it works on it ! Strange...

Here is the error of the console web on my (corruped?) original google sheet 👍
capture d ecran 3

elTRexx commented

with expanded error log :
capture d ecran 4

Synthoid commented

Interesting... Wonder if the add-on was just installed oddly for that sheet? In any case, the new sheet works and is exporting your data as expected?

elTRexx commented

Yep

Synthoid commented

Hmm, well for now I'll mark the issue as closed and I'll look into why the original sheet didn't export properly. Thanks for posting some screens of your console to help debug the issue!