How to convert mongodb response array from javascript object to JSON string

Question

I have written a javascript API which returns all the data from mongodb database on request. However it is sending the data s an array of objects and I want to get the simple json string. The statement returning the objects is

return db.collection('variants').find().toArray();

Do I need to append another function like JSON.stringify()? but I think that work for single object but not for array of objects as in my case.

var fetch = require('graphql-fetch');
const API_URL = `http://localhost:4000/graphql`
const query = `
{
  variants{
    VARIANT_ID
    CHROM
  }
}
`
fetch(API_URL)(query).then(data => console.log(data))

It's not JSON, it's BSON. And it's a JavaScript Object because you are using JavaScript. Of course you need to parse.\ — Neil Lunn
– Neil Lunn, Commented Jun 9, 2017 at 11:53
Well in you server program connecting to MongoDB. If you are using express then there is res.json(). Also it it's nodejs then .toArray() requires a callback or promise resolution. — Neil Lunn
– Neil Lunn, Commented Jun 9, 2017 at 12:09
I am using express and setup graphql API. The API in its GraphiQL windows respond fine but when I tried to fetch from client side I got an error. Let me add the fetch code too. Probably it will make more sense however ideally I would like to do it on server so that clients dont go through it — drmaa
– drmaa, Commented Jun 9, 2017 at 12:15

flup · Accepted Answer · 2017-06-18 12:20:10Z

4

Okay I found the solution. All I need is JSON.stringify(data).

var fetch = require('graphql-fetch');
const API_URL = `http://localhost:4000/graphql`
const query = `
{
  variants{
    VARIANT_ID
    CHROM
  }
}
`
fetch(API_URL)(query).then(data => console.log(JSON.stringify(data)))

edited Jun 18, 2017 at 12:20

flup

27.2k8 gold badges56 silver badges75 bronze badges

answered Jun 11, 2017 at 19:53

drmaa

3,74411 gold badges53 silver badges78 bronze badges

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

1 Comment

Daksh Over a year ago

Sometimes... The simplest answer is the one you already know ;)

socrateisabot · Accepted Answer · 2017-06-16 22:00:16Z

0

The following snippet will works properly.

fetch('/users.json')
.then(function(response) {
    return response.json()
}).then(function(json) {
    console.log('parsed json', json)
}).catch(function(ex) {
    console.log('parsing failed', ex)
})

answered Jun 16, 2017 at 22:00

socrateisabot

8472 gold badges10 silver badges28 bronze badges

Comments

Nino Matos · Accepted Answer · 2017-06-09 11:59:16Z

-3

You can use mongoexport.

In order to perform this operation you need read access to the database.

Eg: mongoexport --db database [--collection traffic] --out file.json

answered Jun 9, 2017 at 11:59

Nino Matos

1291 silver badge13 bronze badges

Collectives™ on Stack Overflow

How to convert mongodb response array from javascript object to JSON string

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related