search

Synthoid / ExportSheetData

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

Firebase RealtimeDatabase jsonTree #65

Open Russel1 opened 6 years ago

Russel1 commented 6 years ago

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: bildschirmfoto 2018-05-16 um 12 17 09

Synthoid commented 6 years ago

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.

Russel1 commented 6 years ago

I tried it, but unfortunately I could not solve the problem yet. thanks for your help @Synthoid.