Zapier integration typo: "insert" -> "upsert"

Hi @Kai_Zhu welcome to the Coda community! :wave:

Upsert is an amalgam of Insert and Update. Its best used when you are uncertain if the row exists.

If you try to Update a row that doesn’t exist, the zap will fail. If you try to Insert a row that already exists, the zap will fail.

Upsert will always work … but sometimes you do want it to fail. It gives you more flexibility depending on the use case.

1 Like

Alright, so this is just a non-English speaker’s misunderstanding.