[SOLVED] Cloud function can't find user by ethAddrress

Moralis General
#1

Iā€™m calling a Cloud function from one of my API routes and Iā€™m having an issue where itā€™s not finding the ethAddress of user. Iā€™m trying to switch a userā€™s ā€œemailVerifiedā€ value but getting "error": "user.set is not a function" returned from the route.

It looks like .find() isnā€™t matching anything but it should.

The logger results below:
Logs.. shows:

Logs...{"params":{"_ApplicationId":"XPL7i7UbHjQQINxEFpY8eRLk7LM2EtdoyF8Vdhdq","ethAddress":"0x9396c0fed2af8257f59437f461de1c8ff7b066301","changeVerified":"true","unsetVerifyToken":"true"},"master":false,"functionName":"switchUserVerified","context":{}}

ethAddress... returns the correct address

User | Query: {"where":{"ethAddress":"0x9.......01"}}
User: []

Not sure where Iā€™m going wrong here?

Moralis.Cloud.define('switchUserVerified', async (request) => {
  const logger = Moralis.Cloud.getLogger();

  logger.info('Logs...' + JSON.stringify(request));
  logger.info('ethAddress...' + JSON.stringify(request.params.ethAddress));

  const User = Moralis.Object.extend('_User');
  const query = new Moralis.Query(User);
  query.equalTo('ethAddress', request.params.ethAddress);
  logger.info(`User | Query: ${JSON.stringify(query)}`);

  const user = await query.find({ useMasterKey: true });
  logger.info(`User: ${JSON.stringify(user)}`);

  user.set('emailVerified', changeVerifiedBool);
  user.unset('verifyToken');

  logger.info('Saving user...');
  await user.save(null, { useMasterKey: true });
});

This is how Iā€™m calling the Cloud function from Next.js API route:

const response = await fetch(
          `https://46664sqdmacoh.usemoralis.com:2053/server/functions/switchUserVerified?_ApplicationId=${appId}&ethAddress=${address}&changeVerified=${changeVerifiedBool}&unsetVerifyToken=${changeVerifiedBool}`,
          {
            method: 'POST',
          }
        );
const data = await response.json();
[SOLVED] How to get and change the value of an array from a moralis database?
#2

this may return an array, you may also have to use lowercase for the address

#3

Ya it returns an empty array but it should be finding my user.

Not sure why its not working.

#4

if you try it without that equalTo then it works as expected as in to return all the users?

#5

@cryptokid - Ya it does find all

#6

can you try by searching by another field, like username, just to see if it works?

#7

@cryptokid - yup using the username works

#8

maybe there are some invalid rows in that table for ethAddress?

#9

oh man, sorry, I had a number 1 added in the route in Postman after the address. Mustā€™ve been a typo.

Thanks for helping!

1 Like
#10

@cryptokid - actually the query looks good now but when it gets to user.set() or user.save()` itā€™s returning:

"data": {
  "code": 141,
  "error": "user.save is not a function"
}

"data": {
  "code": 141,
  "error": "user.set is not a function"
}

user.set('emailVerified', false); 
await user.save(null, { useMasterKey: true });

Any idea?

#11

user has to be an object, not an array

#12

Oh right. Thanks for your help!