Hi everyone, I'm trying to invite people via email with 'inviteUserByEmail'. The function I use goes through an array of email addresses:

data.forEach(async (invite) => {
        const { error, status } = await supabaseServer.auth.api.inviteUserByEmail(
            invite.invitee_email,
            {
                data: invite
            }
        )

        if (error) {
            console.log('error :>> ', error)
            return {
                status,
                body: { error }
            }
        }
    })

supabaseServer is created as follows:

import { createClient } from '@supabase/supabase-js'

const supabaseUrl = process.env.VITE_PUBLIC_SUPABASE_URL
const supabaseKey = process.env.SUPABASE_SERVICE_ROLE_KEY

console.log('supabaseUrl, supabaseKey :>> ', supabaseUrl, supabaseKey)

export const supabaseServer = createClient(supabaseUrl, supabaseKey)

Env variables are correctly passed, but when I run the invite function I get the following error:

error :>>  { message: 'Database error saving new user', status: 500 }

. Any ideas why this could happen?

Do you have a trigger setup on your

auth.users

table?

yes whenever a new user is added, it adds a profile.

The issue is to do with the trigger

ah, I see, so it works when I sign up since I pass seemingly all the necessary info but not when I run the invite, correct?

Correct

Ok, thanks again, will double check what data I pass

An invite is creating a record inside of the

auth.users

table, this will then start off the trigger you created because it is triggered when a new record is added to the

auth.users

table

ok, but weirdly non of the fields in my profiles are nullable (besided the id, which get generated)

The db side can be seen in the migrations directory, the schemas, functions and trigger creation code is there

ah, missed that, thanks!

What does the

invite

object contain in your

data: invite

part of the code?

they don't match up, I just saw that you check for in your code if full_name is there: values (new.id, new.raw_user_meta_data->>'full_name', ...

You're welcome