How to Update MongoDB Document without Error Message?

user-1 · May 10, 2023, 4:05pm

This topic was automatically generated from Slack. You can find the original thread here.

Hello everyone! I’m trying to update a MongoDB document but this message is appearing. What am I doing wrong? Thanks!

user-1 · May 10, 2023, 4:05pm

Hi Victoria, Thanks for reaching out. Happy to help!

Can you please provide the configuration of your MongoDb Update Document step?

user-1 · May 10, 2023, 4:05pm

The error message is helpful, but without knowing the props you’ve defined it’s hard to tell what the issue could be.

user-1 · May 10, 2023, 4:05pm

Hi Pierce, sure!
This is the first part

user-1 · May 10, 2023, 4:05pm

for the document I fill the field with a variable I get from the previous step

user-1 · May 10, 2023, 4:05pm

in the prev step I find the doc and I use the id to update the doc

user-1 · May 10, 2023, 4:05pm

I think the _id field in particular is what the issue is. The underlying action is missing the new prefix to the constructor:

github.com

PipedreamHQ/pipedream/blob/a2b64bf32ab56af9ce6698a683322e34a62860c4/components/mongodb/mongodb.app.mjs#L109


      
            const client = await this.getClient();
            const collection = this.getCollection(client, databaseName, collectionName);
            const doc = await collection.insertOne(data);
            await client.close();
            return doc;
          },
          async updateDocument(databaseName, collectionName, _id, data ) {
            const client = await this.getClient();
            const collection = this.getCollection(client, databaseName, collectionName);
            const doc = await collection.updateOne({
              _id: ObjectID(_id),
            }, {
              "$set": data,
            });
            await client.close();
            return doc;
          },
          async deleteDocumentById(databaseName, collectionName, _id) {
            const client = await this.getClient();
            const collection = this.getCollection(client, databaseName, collectionName);
            const doc = await collection.deleteOne({

user-1 · May 10, 2023, 4:05pm

Could you open a bug report and tag me? @ctrlaltdylan I can describe this bug to the developers:

user-1 · May 10, 2023, 4:05pm

But in the meantime, you can use the Use any MongoDb API with Node.js to scaffold a Node.js version of this step and write the query

user-1 · May 10, 2023, 4:05pm

Ok! I’m opening the report. Thanks for your help!