Cosmos DB Query Works in Data Explorer But Not Node.js

Question

I am trying to run the following query against my cosmos db using Node.js.

const querySpec = {
    query: "SELECT * FROM Users u WHERE u.id = @email",
    parameters: [
        {
            name: "@email",
            value: "[email protected]"
        }
    ]
};

const { result: results } = client.database(databaseId).container(containerId).items.query(querySpec).toArray();
if (results.length == 0) {
    throw "No matching user";
} else if (results.length > 1) {
    throw "Account found";
}

const user = results[0];
console.log(user);

however I keep getting the error TypeError: results is undefined. The query works just fine in the data explorer. databaseId and containerId print the values I need them to if I use console.log.

Why might i be getting this error?

Gaurav Mantri · Accepted Answer · 2019-05-16 06:37:48Z

2

I believe the reason you're getting this error is because query is an async method and you're not awaiting it. Can you try by changing the following line of code:

const { result: results } = client.database(databaseId).container(containerId).items.query(querySpec).toArray();

to:

const { result: results } = await client.database(databaseId).container(containerId).items.query(querySpec).toArray();

and see if that takes care of the issue.

answered May 16, 2019 at 6:37

Gaurav Mantri

137k17 gold badges247 silver badges282 bronze badges

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

1 Comment

DMop Over a year ago

I had to put query inside an async function as well then call it, but this worked. Thank you!

Collectives™ on Stack Overflow

Cosmos DB Query Works in Data Explorer But Not Node.js

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related