Hello, I am trying to do a PUT request with an ups...
# orm-help
j
Hello, I am trying to do a PUT request with an upsert and am getting the following error
Argument id: Got invalid value NaN on prisma.upsertOneUsers. Provided Float, expected Int.
How do I get it to automatically generate an id if id does not exist?
Copy code
put: async (req, res) => {
    try {
      const { id, email, first_name, last_name } = req.body
      const result = await prisma.users.upsert({
        where: { id: Number(id) },
        update: {
          email: email,
          first_name: first_name,
          last_name: last_name
        },
        create: {
          email: email,
          first_name: first_name,
          last_name: last_name
        }
      })
      res.json(result)
    } catch (e) {
      console.warn(e)
      return res.status(400).send('Failed to post Users')
    }
  }
r
Hey @Jane 👋 Your query looks correct, but I think the
id
that you are passing is not a number where I guess the
Number(id)
is failing. Could you test by providing a correct number/string and check?