How to get specific JSON data from REST API using Nodejs?

Question

I want to get JSON data of a particular lets say match=2 data from all matches. I am not able to get required data which is stored in MongoDB.

JSON response:

{
    "_id": "5a63051735aaddd30d1d89cc",
    "id": 1,
    "season": 2008,
    "city": "Bangalore",
    "team1": "Kolkata Knight Riders",
    "team2": "Royal Challengers Bangalore",
    "toss_winner": "Royal Challengers Bangalore",
    "toss_decision": "field",
    "result": "normal",
    "dl_applied": 0,
    "winner": "Kolkata Knight Riders",
    "win_by_runs": 140,
    "win_by_wickets": 0,
    "player_of_match": "BB McCullum",
    "venue": "M Chinnaswamy Stadium",
    "umpire1": "Asad Rauf",
    "umpire2": "RE Koertzen",
    "umpire3": ""
  }

I am able to get all JSON data of 577 total matches using below code.

app.get('/api/matches', (req, res) =>{

    matches.find({}).then(eachOne => {

        res.json(eachOne);

    });

});

But now I do not want to get JSON data of all matches instead I want to get JSON data of match having id:2 how can I get that I tried using below code but it gets JSON data of all matches.

app.get('/api/matches/:match_id', (req, res) =>{

    let match = req.params.id;

    matches.find({match}).then(eachOne =>{

        res.json(match);
    });

});

In matches.js:

const mongoose = require('mongoose');

let Schema = mongoose.Schema;

const matchSchema = new Schema({

    match_id:{
        type:Number,
        required:true
    },

    season:{
        type:Number,
        required:true
    },

    city:{
        type:String,
        required:true
    },

    date:{
        type:Number
    },

    team1:{
        type:String,
        required:true
    },

    team2:{
        type:String,
        required:true
    },


    toss_winner:{
        type:String,
        required:true
    },

    toss_decision:{
        type:String,
        required:true
    },

    dl_applied:{
        type:Number
    },

    winner:{
        type:String,
        required:true
    },

    win_by_runs:{
        type:Number,
        required:true
    },

    win_by_wickets:{
        type:Number,
        required:true
    },

    player_of_match:{
        type:String,
        required:true
    },

    venue:{
        type:String,
        required:true
    },

    umpire1:{
        type:String,
        required:true
    },

    umpire2:{
        type:String,
        required:true
    },

    umpire3:{
        type:String
    }

});

const matches = mongoose.model('matches', matchSchema);

module.exports = matches;

ema · Accepted Answer · 2018-01-21 09:34:24Z

1

Your code is almost right. You just need to specify the right query:

app.get('/api/matches/:match_id', (req, res) =>{
    let match = req.params.match_id;
    matches.findOne({id: parseInt(match)}).then(m =>{
        res.json(m);
    });
});

Also consider that match_id from url is a string, so you need to check it and convert to number (I used parseInt)

edited Jan 21, 2018 at 9:34

answered Jan 21, 2018 at 7:52

ema

5,7931 gold badge28 silver badges32 bronze badges

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

20 Comments

stone rock Over a year ago

Why parseInt(match) it is already I number see matches.js ?

stone rock Over a year ago

Your code works even if I use match_id: match instead of match_id: ParseInt(match)

ema Over a year ago

Ah! Yes! I forgot that you are using mongoose...it convert it in number for you.

stone rock Over a year ago

I am new to mongodb so does mongoose convert string into number by default.

ema Over a year ago

Mongoose does it

|

Himanshu sharma · Accepted Answer · 2018-01-21 07:50:36Z

0

You must be using bodyparser by default .

You are doing wrong.

app.get('/api/matches/:match_id', (req, res) =>{



    // instead of req.params.id write req.params.match_id
   let match = req.params.match_id;

    // when you write {match} there is nothing {id : match}

    matches.find({match_id : match}).then(eachOne =>{

        res.json(eachOne);
    });

});

edited Jan 21, 2018 at 7:50

answered Jan 21, 2018 at 7:24

Himanshu sharma

8,0436 gold badges48 silver badges82 bronze badges

13 Comments

stone rock Over a year ago

My matches.js i.e matches schema is like this imgur.com/a/PFeas

stone rock Over a year ago

The field in JSON response is id but in matches.js Schema I have named it as match_id in mongodb is it allowed to name them different or do I need to use same name for fields.

Himanshu sharma Over a year ago

add full image or file , it is half image. or add the match.js in question.

stone rock Over a year ago

check it out I have added matches.js

stone rock Over a year ago

In JSON response I have just added only 1 JSON object but it gives around 577 objects

|

Collectives™ on Stack Overflow

How to get specific JSON data from REST API using Nodejs?

2 Answers 2

20 Comments

13 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

20 Comments

13 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related