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 ClicRDVexternId
, then store the ClicRDV identifier created in clicrdvId
Synchronisation ClicRDV -> DB :
externId
, modify the fiche in the DBexternId
of the ClicRDV fiches.This process can then be executed at regular intervals (for example by a cron), usually once a day.
The ClicRDV externId
field must be an integer. If your identifiers are not integers, you can use a custom field instead.