How do I create a JSON string from data stored in Google Firebase

Question

I need my Google Firebase Database Data converted to a JSON string.

The desired outcome should be as follows:

var dataSet =[
{arr:"test",des:"DMM",eta:"17 Feb 2018 11:00",etd:"17 Feb 2018 13:30",gate:"S92", inbound:"RT456", org:"ARN", outbound:"RT678", remarks:"CHARTER", sta:"17 Feb 2018 11:00", std:"17 Feb 2018 13:30", whs:"T11"},
{arr:"test",des:"ESB",eta:"17 Feb 2018 09:00",etd:"17 Feb 2018 15:30",gate:"S94", inbound:"SD941", org:"JNB", outbound:"SD942", remarks:"", sta:"17 Feb 2018 09:00", std:"17 Feb 2018 15:30", whs:"T11"}
             ];

I'm new to this and have therefore no clue how to accomplish this.

Animesh Kumar · Accepted Answer · 2018-03-02 07:37:15Z

1

First get the DataSet-schedule object and then iterate for each of the objects inside it :

dbRef.child("DataSet-schedule").once("value").then(
    function(snapshot){
        var dataSetObj = snapshot.val(), text= "";
        for(x in dataSetObj){
            text += JSON.stringify(dataSetObj[x]);
            text+= "--";  //separator
        }
    var result = text.split("--");
    result.pop();
    }

);

edited Mar 2, 2018 at 7:37

answered Mar 1, 2018 at 10:14

Animesh Kumar

2373 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

MK01111000 Over a year ago

Thanks for trying. I get an error on the first line Uncaught ReferenceError: dbRef is not defined I tried changing it into firebase.database().ref("DataSet-Schedule").once("value").then( but then turns into another error message Uncaught (in promise) TypeError: JSON.Stringify is not a function

Animesh Kumar Over a year ago

@MK01111000 There's a slight typo in my code. The function's name is JSON.stringify() and not JSON.Stringify(). So, the code will work if you write JSON.stringify(dataSetObj[x])

Animesh Kumar Over a year ago

Also after you do result = text.split("--"); make sure you pop the last element of the result array because it contains empty string. So your code would look like var result = text.split("--"); result.pop();

MK01111000 Over a year ago

Thanks, that was what I was looking for

Anuraag Baishya · Accepted Answer · 2018-03-01 10:10:00Z

1

The JSON data is available at https://your-project.firebaseio.com/.json. You can obtain this by sending a GET request to this url. If you have classes in your data and would like to get the data for a particular class instead, use https://your-project.firebaseio.com/your-class.json

You can test this by using curl https://your-project.firebaseio.com/.json For better readability you can use curl https://your-project.firebaseio.com/.json?print=pretty

Refer: https://firebase.google.com/docs/database/rest/retrieve-data

answered Mar 1, 2018 at 10:10

Anuraag Baishya

8842 gold badges11 silver badges26 bronze badges

1 Comment

MK01111000 Over a year ago

@Anuuraag Baishya, thats very helpful indeed. Only thing is that I need the data without the push-keys, like in the "desired outcome" mentioned in my first post

Collectives™ on Stack Overflow

How do I create a JSON string from data stored in Google Firebase

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related