Firebase RealtimeDatabase jsonTree
Opened this issue · 2 comments
How can I map this json tree example to Google Sheets? So that ExportSheetData imports the same json?
"questions": {
"game_of_thrones": {
"1": {
"answer1": "Elia Martell",
"answer2": "Catlyn Stark",
"answer3": "Cersei Lannister",
"answer4": "Lyanna Stark",
"correctAnswer": 4,
"question": "Wer ist Jon Schnees Mutter?"
},
"2": {
"answer1": "Viserys",
"answer2": "Daario",
"answer3": "Rhaego",
"answer4": "Rhaegar",
"correctAnswer": 3,
"question": "Wie heißt Daenerys verstorbenes Kind?"
},
"3": {
"answer1": "Haus Targaryen",
"answer2": "Haus Stark",
"answer3": "Haus Lannister",
"answer4": "Haus Mormont",
"correctAnswer": 1,
"question": "Aus welchem Haus stammt Jorah?"
},
"4": {
"answer1": "7",
"answer2": "9",
"answer3": "6",
"answer4": "5",
"correctAnswer": 1,
"question": "Wie viele Staffeln gibt es bisher?"
},
"5": {
"answer1": "Jorah Mormont",
"answer2": "Jon Schnee",
"answer3": "Daario Naharis",
"answer4": "Khal Drogo",
"correctAnswer": 4,
"question": "Wen hat Daenerys geheiratet?"
}
},
"sesame_street": {
"1": {
"answer1": "Wer, wie, was",
"answer2": "Wieso, weshalb, warum",
"answer3": "Der, die, das",
"answer4": "Bla, Bla, Bla",
"correctAnswer": 3,
"question": "Wie beginnt der Titelsong der Sesamstraße?"
},
"2": {
"answer1": "Rumpel",
"answer2": "Elmo",
"answer3": "Kermit",
"answer4": "Mülli",
"correctAnswer": 1,
"question": "Wer wohnt in der Mülltonne?"
},
"3": {
"answer1": "am 8. Januar 1973",
"answer2": "am 7. Februar 1963",
"answer3": "am 6. März 1953",
"answer4": "am 8. Dezember 1984",
"correctAnswer": 1,
"question": "Wann wurde die Sesamstraße zum ersten Mal in Deutschland gezeigt?"
},
"4": {
"answer1": "Australien",
"answer2": "England",
"answer3": "USA",
"answer4": "Ireland",
"correctAnswer": 3,
"question": "Aus welchem Land kommt die Sesamstraße ursprünglich?"
},
"5": {
"answer1": "Eule Buh",
"answer2": "Wolf vom Wörtersee",
"answer3": "Felicitas",
"answer4": "Christian",
"correctAnswer": 2,
"question": "Wer ist der neueste Mitbewohner der Sesamstraße?"
}
}
}
Can you give me a Google Sheets example like this:
This sounds like a job for Nested Elements. I'd recommend looking at the documentation for Nested Elements for now, and I'll see if I can get a quick example of how your keys should be formatted later if you haven't already come up with a solution.