User not being updated by API consistently

Problem statement

We are unable to delete a field in the app_metadata section in one of our connections DB. We get a successful message, but it is not really deleted.

Cause

The tenant has users with identical user_id.

Solution

The user_id field should be considered ‘unique’ per tenant. This can be circumvented with a Custom Database connection, which allows the flexibility to import user_id from an external system without constraint. However, this causes problems for many API endpoints calling user_id, which includes the metadata delete action.

Removing duplicate user_id fields will allow the normal operation of all APIs to be restored.