OXIAE / VIDEOIllustrative example

API integration: one repeated message must not create two orders

An illustrative CRM request shows how an API integration handles repeated messages, invalid fields and a timeout whose outcome has not yet been established.

By Produced by OXIAEPublished

With narration and captions. Playback starts when you choose it.

Read along

Transcript

The spoken explanation, organised by chapter.

0:00Same message, same order

This accompanies our article on API integration. What if a system resends a message after the first order was created?

0:09Two deliveries, one request

A fictional approved CRM request goes to an administration system. Its message arrives twice. Without a stable reference, two draft orders could represent exactly the same request.

0:22Carry a stable reference

Assign an immutable source reference and store it in the destination. A mapping table connects the customer reference with the correct existing customer number in the administration system.

0:33Agree the data contract

Only approved requests proceed. Validate required text, customer mapping and date format. A missing match or invalid date stops processing and receives an explicit error reason for follow-up.

0:47A lookup alone is insufficient

Searching first does not prevent duplicates when messages run concurrently. The destination must enforce a unique external reference even when two processing attempts start at the same time.

0:59A timeout proves little

After a timeout, the order may exist. Check the destination using that reference first. If the outcome remains unknown, request human review before attempting to create another order.

1:11Keep processing traceable

Record source reference, processing status and error reason. An administrator needs to identify completed work and outstanding exceptions without blindly repeating the whole integration from the beginning.

1:24Test beyond successful delivery

Test repeated and concurrent messages, missing fields and uncertain outcomes. Check current source status too: an old message must not reverse a newer state in the destination.

1:36Design the recovery route

A dependable integration needs more than a successful transfer. Our source article on API integration explains data agreements, error responses and controlled reprocessing in greater detail.