search

BiologicalRecordsCentre / ABLE

Assessing ButterfLies in Europe project repository
2 stars 3 forks source link

General two-way integration across databases through API #424

Open larspett opened 2 years ago

larspett commented 2 years ago

Following issue #192 , wee might want to generalize this further than just to Observation.org so that there is a versatile API to API connection that enables two-way dataflow between the source database (Indicia) and other databases mirroring the Indicia data. We (Sweden) are pulling the FIT Count data to our national database and will want to pull Butterfly Count data in the near future. It would be good to be able to supply site (including spatial data) and volunteer information both ways too, i.e. supplying new or updated site information (including spatial information) and volunteer information to Indicia as well as being able to sync data back to the synchronized local database. Sites could be updated in Indicia and then those changes will need to be flagged and brought back to synchronized databases.

johnvanbreda commented 2 years ago

@larspett such an API already exists - we can provide access via an API to simple Darwin Core formatted occurrences, or pull the same format from elsewhere. In practice though we find that many of the other systems we need to integrate with already have some form of API and would prefer that we write code to integrate with their API as it is less effort for them.

DavidRoy commented 2 years ago

Also, part of this requirement is a two-way exchange for a return journey of record annotations (e.g. verification assessments)