[SOLVED] Aggregate call requires masterKey

Moralis General
#6

this doesn’t work: const result = await query.aggregate(pipeline, {useMasterKey: true}); ?

#7

I get

error - ParseError: unauthorized: master key is required

when I call (after the usual Moralis.start and other queries work nicely)

    const pipeline = [
        {match: {day: 190}} //{gt: 190, lt: 202}}}
    ]

    return await query.aggregate(pipeline, {useMasterKey: true})// , {useMasterKey: true})

Edit: Note my first post that I’m using import Moralis from "moralis/node". Is it maybe not ported to the server side backend implementation for node?

#8

did you add the master key to Moralis.start ?

#9

yes I did add it to moralis.Start (Note that other queries work, also typescript does not type hint the option key)

#10

and if you use that syntax from a cloud function, I guess that it works

1 Like
#11

It seems that I can’t use Moralis.Cloud.define from a moralis/node context. For prototyping a bit cumbersome if I have to move my code definition in another location.

I can try it with the client side of things for the sake of trying, but from what I understood with Cloud code from the parse-server it should work since it defaults to using the master key.

#12

you still need to use that syntax with master key as parameter in cloud code

#13

moralis/node has this signature for query.aggregate
aggregate<V = any>(pipeline: Query.AggregationOptions | Query.AggregationOptions[]): Promise<V>;

and AggregationOptions is missing the Scopeoptions which includes interface ScopeOptions extends SessionTokenOption, UseMasterKeyOption {}

So it seems it never is included there. I assume it was forgotten to update? :thinking:

Yes I also think that it is still necessary to use the option in the Moralis.Cloud context, I’m however not very eager to move to Moralis.Cloud just for that function. I’m now making a more expensive server side computation on my end instead. Would have been nice to use the aggregation pipeline. Well, hopefully in a future release it will be available.

#14

you could call a cloud function with specific parameters and get the result back, as a workaround for now

#15

Please see above post that mentions the lack of Moralis.Cloud.define in the moralis/node.

I would have to create a client side admin page to maintain or update these sort of functions or define it without version control in the console/Moralis dashboard, which seems very cumbersome for my code base. It’s not really an attractive work around for my situation. I explored it a bit before and appreciate the recommendation though :+1:

#16

I still don’t understand what this means

you can create a cloud function, upload it to a Moralis Server, and call it there, or you can connect directly to mongo db and run the query there

#17

TypeError: moralis_node__WEBPACK_IMPORTED_MODULE_1___default(...).Cloud.define is not a function

#18

yes, I don’t expect that to work, I didn’t want to say to use that on your server

#19

Yes, and I’m saying that I want to contain my code base under version control in the vicinity of feature development. I don’t want to manually move to another admin page or use the moralis dashboard manually and update the query whenever I change something :+1:

Again, thank you for the recommendation, it just isn’t the right fit for my situation.

#20

accessing mongo db directly doesn’t work for you?

#21

There was the problem with whitelisting IPs, since I have a server that rotates IP addresses, so the automatically regenerating backend will at some point not be able to connect to the database since I can’t whitelist a DNS address.

#22

can you give a minimal complete code example with .aggregate that I could also test if it works?

#23 

import Moralis from `moralis/node`

const testMoralis = async () => {
Moralis.start({
appId: ...
serverUrl: ...
masterKey: ...
})
const pipeline = [
{match: {someField: "fieldValue"}}
]
const result = await (new Moralis.Query("SomeCollection")).aggregate(pipeline, {useMasterKey: true})
}

Something like this

#24

this works fine for me:


x = async () => {
    const  Moralis = require('moralis/node')
    console.log(Moralis.CoreManager.get("VERSION"))
    await Moralis.start({ serverUrl: "https://afasdf:2053/server", appId: "sdgasdg", masterKey: "sfgsdfg" });

    const pipeline = [
        {match: {username: "Gn6Px7RUd9JkiJLVTdEMD4cen"}}
    ]
    const result = await (new Moralis.Query("User")).aggregate(pipeline, {useMasterKey: true})
    console.log(result);

    }

x();
1 Like
Web3Api.initialize failed: initialize with apiKey or serverUrl error
Get user's personal data with aggregation
#25

It seems that the queries I made before were all on default public fields so they never triggered this error. I had multiple Moralis initialiser definitions with different environment variables for each different test server. The masterkey was passed to the Moralis.start in this case, but it was a copy paste error from another server`s initialiser that only had the correct URL and app id.

Thanks for your help in resolving this. Much appreciated!

1 Like