I need to replicate the effect of SQL “REPLACE INTO” query with the REST verbs.
REPLACE INTO does what INSERT INTO does, except it will overwrite an existing matching record.
We’ve got GET, POST, PUT, PATCH, DELETE. I have tried testing POST, PUT, and PATCH in API Docs but none have achieved the “insert with overwrite” effect so far. POST fails on existing record, PUT and PATCH fail if there is nothing to overwrite.
How do I achieve that insert with overwrite effect?