img/favicon.ico" />
MyNew Technologies

How to stop an integration from creating duplicate records

Retries after a time-out can create a second record if the first request succeeded but its reply was lost.

What to do

  1. Choose a stable source identifier, such as the store and order number together.
  2. Have the receiving workflow look up or enforce uniqueness for that identifier before creating a record.
  3. In a test environment submit the same item twice, including after a simulated time-out, and verify the destination contains a single record.

Reference: IETF HTTP Semantics, idempotent methods.

Related MyNew service: System Integration.