Here we take the example of a bi-directional synchronisation between ClicRDV and a business software or another database called DB herebelow.
The synchronisation requires that each of the softwares can keep a reference to the identifier used on the other Information System (
clicrdvId for example), and a timestamp of the last modification (
updated_at on ClicRDV). The ClicRDV API proposes a field
externId, free to use, which allows you to store the identifier of a fiche on an external system.
Synchronisation DB -> ClicRDV :
clicrdvId, modify the fiche on ClicRDV
externId, then store the ClicRDV identifier created in
Synchronisation ClicRDV -> DB :
externId, modify the fiche in the DB
externIdof the ClicRDV fiches.
This process can then be executed at regular intervals (for example by a cron), usually once a day.
externId field must be an integer. If your identifiers are not integers, you can use a custom field instead.