How to grab nested data in a firebase realtime database?

Question

I've made a small website for family and friends to guess after name, gender, date of birth, etc of our next baby. I have used vue in combination with firebase's real time database. Now I want to write a console app in c# to validate all the bets and point a winner. The problem is the way I set up the database:

-Users
    -Davy vettorato
        -posts
            -M5HuYYaUuKgqpD9qdVT
                date: "2020-09-23"
                gender: "Meisje"
                weight: "2550"
                length: "52"
                name: "Nele"
                extra_question: "11:00"
    -Dries
        -posts
            -MAerWe2LjQHGM6vEVur
                date: "21/9/2020"
                gender: "Meisje"
                weight: "4,200"
                length: "55"
                name: "Elise"
                extra_question: "11:45"
           -MAerhMgLbAe_sUyg5AE
                date: "21/9/2020"
                gender: "Jongen"
                weight: "4,200"
                length: "55"
                name: "Thibaut"
                extra_question: "11:46"

I'm able to get each user, but then I get stuck. I want to betting objects for each user derived from the db. This is what I've allready started with

        IFirebaseConfig config = new FirebaseConfig
        {
            AuthSecret = "//",
            BasePath = "https://babyproject-fb0.firebaseio.com/"
        };
            IFirebaseClient client = new FireSharp.FirebaseClient(config);

            if (client != null)
            {
                Console.WriteLine("Connected");
            }

            FirebaseResponse response = client.Get("");
            

            var json = response.Body;
            var result = JObject.Parse(json);

Does anybody knows how i can get all the seperate bets of each user? I've tried with selectTokens, without any succes..

I'd expect something like `client.Get("User")` and after that you'll have to loop over the `JObject.ChildrenTokens`: https://www.newtonsoft.com/json/help/html/P_Newtonsoft_Json_Linq_JObject_ChildrenTokens.htm or the `Descendants` list: https://www.newtonsoft.com/json/help/html/M_Newtonsoft_Json_Linq_JContainer_Descendants.htm — Frank van Puffelen, Sep 21 '20 at 18:10
Thanks for your answer. I figured it out with the .children method. Then I could get the user as a JProperty. I've put all my users in a list which I used to build my next path. This method helps me again to go further in the nested json. — Nilson, Sep 24 '20 at 18:25

score 1 · Answer 1 · answered Sep 24 '20 at 18:28

 var json = response.Body;
        var result = JObject.Parse(json);

        foreach (var user in result.Children())
        {
            Better better = new Better();

            if (user is JProperty)
            {
                var prop = user as JProperty;
                better.Name = prop.Name.ToString();
                userBetList.Add(better);

                var userPosts = result[better.Name]["posts"].Children();

                foreach (var post in userPosts)
                {
                    var userPost = post as JProperty;
                    var betId = userPost.Name.ToString();
                    var betsOfId = result[better.Name]["posts"][betId].Children();
                    Bet generatedBet = new Bet();

                    foreach (var madeBet in betsOfId)
                    {
                        var bet = madeBet as JProperty;
                        if (bet.Name.ToString() == "datum")
                        {
                            generatedBet.Datum = DateTime.Parse(bet.Value.ToString());
                        }

This is the example of how I fixed the problem. I think there must be an easier way, but it did the job.

How to grab nested data in a firebase realtime database?

1 Answers1