Bash - Convert MONGODB BSON to JSON

Question

I have a shell command that calls a MongoDB command and produces a BSON output. I then want to parse that output with jq so I need to convert the BSON to JSON using jq's tojson.

echo "db._adminCommand({replSetGetStatus : 1})" | /path/to/mongo

How do I implement tojson is it as simple as doing this say:

echo "db._adminCommand({replSetGetStatus : 1})" | /path/to/mongo | jq '[.[]|tojson]'

I haven't put jq on my server yet as I have to prove it works before I can get it released.

When I try .[]|tojson in the online demo it doesn't work but I wasn't sure if this was a demo limitation?

EDIT

So I managed to get "jq" on a test server running mongodb and tried this:

echo "db._adminCommand({replSetGetStatus : 1})" | /path/to/mongo | ./jq '.members[] | {Server: .name, State: .stateStr}'

The error I received was this:

parse error: Invalid numeric literal at line 1, column 8

So it would appear that "jq" can not parse the data from replSetGetStatus.

In the mean time as I sit back scratching my head, waiting for the Change Management Death Squads to turn up, if anyone has some ideas they would be greatly appreciated.

Answer 1

You can use bsondump utility coming with mongodb:

bsondump yourfile.bson | head