6 replies

How to update the 'phoneVerified' field in authAccounts table after a successful phone verification?

I implemented the Twilio phone provider example as showed here: https://github.com/get-convex/convex-auth-example/blob/main/convex/otp/TwilioVerify.ts

The phone number and later the code (OTP) verification is working without an issue and a user (if not existing) and also an account are successfully created.

However I've noticed that in the

authAccounts

authAccounts

table, the

phoneVerified

phoneVerified

remains to be set to

unset

unset

value, which of course it shouldn't be, because I made sure that the phone is verified.

I have tried using the following code to update, but it only updates the

user

user

table accordingly:

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });

    const { user } = await createAccount(ctx, {
      provider: "phone",
      account: {
        id: phone,
      },
      profile: {
        phone,
        isAnonymous: false,
        phoneVerificationTime: Date.now(),
      },
      shouldLinkViaPhone: true,
    });