rest api not returning data from mongodb

Question

I'm working on a rest api that will get premade data from mongodb, but for some reason it is not getting data that is already in mongodb. When I type in localhost:3000/film, it doesn't return any data at all. It returns [ ] and that's it. I have checked mongodb and the data is already there.

the commands i used are:

mongo

use FilmTest

show collections

db.Film.find()

It return all the data that is in it in json format, so the test data is already there but the rest api isn't returning it when I look in /film when starting up the node server.js

server.js

var express = require('express');
var mongoose = require('mongoose');
var cors = require('cors');

mongoose.connect('mongodb://localhost:27017/FilmTest')

var filmSchema = ({
    categoryId: String,
    genre: String,
    title: String,
    releaseDate: String,
    rating: Number,
    director: String,
    cast: String,
    production: String,
    description: String,
    plot: String,
    opinion: String,
    isSpecial: String,
    imageS: String,
    imageL: String
});

var Film = mongoose.model('Film', filmSchema, 'film')

var app = express()
app.use(cors());



app.get('/film', function(req, res) {
    Film.find(function (err, doc) {
        res.send(doc);
    })
})

app.listen(3000);

Steve Holgado · Accepted Answer · 2017-06-22 17:26:36Z

1

Try this:

var express = require('express');
var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var cors = require('cors');

mongoose.connect('mongodb://localhost:27017/FilmTest')

var filmSchema = new Schema({
    categoryId: String,
    genre: String,
    title: String,
    releaseDate: String,
    rating: Number,
    director: String,
    cast: String,
    production: String,
    description: String,
    plot: String,
    opinion: String,
    isSpecial: String,
    imageS: String,
    imageL: String
});

var Film = mongoose.model('Film', filmSchema, 'film')

var app = express()
app.use(cors());

app.get('/film', function(req, res) {
    Film.find({}, function (err, doc) {
        res.send(doc);
    })
})

app.listen(3000);

edited Jun 22, 2017 at 17:26

answered Jun 22, 2017 at 17:18

Steve Holgado

12.1k4 gold badges26 silver badges34 bronze badges

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

5 Comments

Steve Holgado Over a year ago

I've updated my answer to define the schema as 'new Schema' and declare Schema at the top. Hopefully this should now work. Sorry, on my phone so can't test at the moment.

Jason Tran Over a year ago

mongoimport --db FilmTest --collection Film --jsonArray data.js this is the way I import data into mongodb. Is there any mistake with the way imported the data?

Steve Holgado Over a year ago

You have specified your collection as 'Film' with a capital 'F' but it is 'film' with a lowercase 'f' in your mongoose schema option

Jason Tran Over a year ago

oh my god, thank you that was the problem all along.

Steve Holgado Over a year ago

No problem. Easy to miss. Glad I could help.

Collectives™ on Stack Overflow

rest api not returning data from mongodb

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related