How to get currentUser.id on PaymentUpdate()?

Ask the community
,
1

Hi

I need to update a column in a table ( MemberCoinBalance) on PaymentUpdate event for a user ID that made the payment and then insert that user ID into another table (Orders). The wixUsers.currentUser.id in the backend code below does not seem to work, instead returning my (site Admin) user ID. Any suggestions on how to make it work?

Thank you!

event.js


import wixData from 'wix-data';
import wixUsers from 'wix-users-backend';

export function wixPay_onPaymentUpdate(event) {
 let paymentId = event.payment.id;
 let amount = event.payment.amount;
 let paymentCurrency = event.payment.currency;
 let newTransactionStatus = event.status;
 let transactionId = event.transactionId;
 let firstName = event.userInfo.firstName;
 let lastName = event.userInfo.lastName;
 let country = event.userInfo.country;
 let phone = event.userInfo.phone;
 let email = event.userInfo.email;
 let subPlan = event.payment.items[0].name;
 let creditsAmount = event.payment.items[0].creditsAmount;
 let quantity =  event.payment.items[0].quantity; // total purchased

wixData.query("MemberCoinBalance") 
 .eq('_owner', wixUsers.currentUser.id)
  .find() 
  .then( (results) => { 
let item = results.items[0];
   item.coinBalance = item.coinBalance + quantity
        wixData.update("MemberCoinBalance", item);

        }
  )

 let toInsert = {
 "paymentId": paymentId,
 "amount1": amount,
 "currency": paymentCurrency,
 "transactionStatus": newTransactionStatus,
 "transactionId": transactionId,
 "creditPackageName": subPlan,
 "quantity": quantity,
 "firstname": firstName,
 "lastName": lastName,
 "country": country,
 "phone": phone,
 "email": email,
 "creditsAmount": creditsAmount,
 "userId": wixUsers.currentUser.id
  };
  wixData.insert("Order", toInsert)
}