如何将MongoDB文档转换为JSON对象 [英] How to convert a MongoDB document to JSON Object

问题描述

我正在尝试使用find查询返回的MongoDB文档作为NodeJS中的请求正文进行发布请求，但是在服务器上却出现错误消息:JSON无效.以下是我要发布的文档

I am trying to make a post request with the MongoDB document returned from find query, as the request body in NodeJS.But on the server I'm getting the Error : Invalid JSON. Below is the document that I'm trying to POST

{
    "_id" : ObjectId("5739a6bf3f1b41477570dc89"),
    "taskCount" : 2,
    "study" : "cod",
    "phase" : "mansa2",
    "rhimeTaskId" : "5739a6bec4567f6e737fd3db",
    "recordId" : "5726f3cfc4567f6e737fc3ab",
    "recordStudy" : "codstudy",
    "recordPhase" : "mansa2",
    "recordLanguage" : "Punjabi",
    "recordScript" : "Latin",
    "_state" : "CodingComplete",
    "tasks" : [
        {
            "physician" : ObjectId("5739a6bd3f1b41477570dc78"),
            "stage" : "Coding",
            "result" : {
                "cod" : "C15",
                "feedback" : {
                    "narrativeLength" : "Adequate",
                    "positiveSymptomsIncluded" : "Only Positive",
                    "certainty" : "High"
                },
                "keywords" : [
                    "52 yr male, died of food pipe cancer, suffered pain upper abdomen, investigated,FNAC confirmed Cancer, Put on Chemotherapy, multiple cycles, died at home, had fever with chills occasionally"
                ]
            }
        },
        {
            "physician" : ObjectId("5739a6bd3f1b41477570dc79"),
            "stage" : "Coding",
            "result" : {
                "cod" : "C15",
                "feedback" : {
                    "narrativeLength" : "Inadequate",
                    "positiveSymptomsIncluded" : "Only Positive",
                    "certainty" : "High"
                },
                "keywords" : [
                    "severe pain abdomen, ultrasonography revealed food pipe cancer, chemotherapy given, died"
                ]
            }
        }
    ],
    "__v" : 2
}

这是我编写的用于发出POST请求的代码

and here is the code that I wrote to make the POST request

var MongoClient = require('mongodb').MongoClient;
var request = require('request');
var assert = require('assert');
var cmeprovisioning= 'mongodb://localhost:27017/cmeprovisioning';

MongoClient.connect(cmeprovisioning, function(err, db) {
  assert.equal(null, err);
  var count=0;
  console.log("Connected to cmeprovisioning");

         var cursor =db.collection('rhimeReport').find(
                    {"study":"cod","phase":"mansa2","recordStudy":"codstudy",
                     "recordPhase":"mansa2","_state":"CodingComplete"
                    });


                 cursor.each(function(err, doc) {
                      assert.equal(err, null);
                      if (doc != null) {
                         console.dir(doc);
                         count=count+1;
                         request({url: "http://cme.host.net:8081/cme-provisioning/update",
                                  method: "POST",json: true,
                                  headers: {"content-type": "application/json"},
                                  json: doc
                                 },function(e,r,b){

                                       console.log("POST Error "+count+" "+e)
                                       console.log("POST Response "+count+" "+r)
                                       console.log("POST BODY "+count+" "+b)
                                 });


                      } else {
                         console.log("Some Error : "+err)
                      }
                   });
});

我也尝试使用JSON.stringify(doc)，但仍然收到Invalid JSON错误.有没有一种方法可以使用find查询返回的mongo文档并将其转换为JSON以发出POST请求.

I also tried using JSON.stringify(doc), but still got the Invalid JSON error. Is there a way I can use mongo document returned by the find query and convert it to JSON to make the POST request.

我认为这些ObjectID使其成为无效的JSON文档.

I think those ObjectID is what making it an invalid JSON document.

推荐答案

您需要将对象ID转换为字符串，即.

you need to convert object id to string ie.

var result = {
  "_id": ObjectId("5739a6bf3f1b41477570dc89"),
  "taskCount": 2,
  "study": "cod"
};
//now convert to string 
result=result._id.toString();
//now you can use the result

这篇关于如何将MongoDB文档转换为JSON对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！