How can I insert json string to MongoDB?

Question

I have a json string. Like this:

"{"http_requests":[{"http_requests":{"code":"400","method":"PUT","value":89}},{"http_requests":{"code":"200","method":"PUT","value":45}}]}"

I want to insert this json to mongodb. But I have error in my code. The error is "cannot transform type string to a BSON Document: WriteString can only write while positioned on a Element or Value but is positioned on a TopLevel"

func insertJson(json_value string) {
   client, err := mongo.NewClient(options.Client().ApplyURI("mongodb+srv://abc:[email protected]/?retryWrites=true&w=majority"))
   if err != nil {
      log.Fatal(err)
   }
   ctx, _ := context.WithTimeout(context.Background(), 10*time.Second)
   err = client.Connect(ctx)
   if err != nil {
      log.Fatal(err)
   }
   defer client.Disconnect(ctx)

   myDatabase := client.Database("my_db")
   myCollection := myDatabase.Collection("my_collection")
   myResult, err := myCollection.InsertOne(ctx, json_value)
   if err != nil {
      log.Fatal(err)
   }
   fmt.Println(myResult.InsertedID)
}

How do I insert this json string to mongodb?

vague · Accepted Answer · 2022-11-01 04:22:08Z

First thing's first: Add a ping to check if connection is succeeding after defer client.Disconnect(ctx).

if err = client.Ping(ctx, readpref.Primary()); err != nil {
    log.Fatalf("ping failed: %v", err)
}

If that doesn't throw an error, you can unmarshal your JSON string as explained in stackoverflow: How to insert a json object array to mongodb in golang. However, in this case, use interface{} instead of slice as follows:

var v interface{}
if err := json.Unmarshal([]byte(json_value), &v); err != nil {
    log.Fatal(err)
}

Pass v to InsertOne.

Note: This is one way of solving the problem. However, the recommended way to go about it is to unmarshal the JSON to go struct with json and bson tags, and pass the struct instance(s) to InsertOne.

Some references:

Cozer · Accepted Answer · 2022-10-31 23:38:28Z

0

The insertOne() method has the following syntax:

db.collection.insertOne(
   <document>,
   {
      writeConcern: <document> (optional)
   }
)

all you have to do is

myCollection.insertOne(json_metrics)

edited Oct 31, 2022 at 23:38

answered Oct 31, 2022 at 23:18

Cozer

258 bronze badges

3 Comments

Rachel A Over a year ago

when i just give json_string to input i get these errors: 1. Not enough arguments in call to 'myCollection.InsertOne' 2. Cannot use 'json_value' (type string) as the type (context.Context, interface{}, *options.InsertOneOptions) or context.Context

Cozer Over a year ago

try this myCollection.insertOne(json_metrics) (a lowercase i)

Rachel A Over a year ago

unfortunately the error persists: Unresolved reference 'insertOne'

Collectives™ on Stack Overflow

How can I insert json string to MongoDB?

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related