Upsert Cant Update Multiple

[CathyC]

I am receiving the following error

Should an upsert be able to update multiple?

I think we built this to update one, but its a cleanup service and is supposed to mark it inactive so if there are multiple the right action is to mark all inactive. Wondering if theres a use case where it'd be bad to allow upsert to update multiple and thats why the restriction is in place

[SteveCap]

We did have an internal discussion about this. At the time we decided that Upsert should only really be used to update/insert a single record which is why we kept the keys instead of replacing it with the where clause builder.