Purpose

The Reconciliation API or Reconciliation Endpoint provides the ability to reconcile data inOpenRefine with that from a VIVO and prepare it for import into VIVO. 

OpenRefine describes itself as a “powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data”. One use case of OpenRefine is to match tabular data with data in a VIVO, export it as RDF and then import it into a VIVO.

Specification

URL: 

[vivo]/reconcile

Example:

 https://openvivo.org/reconcile

Usage with OpenRefine

1. Click on “Start reconciling” in OpenRefine
   
   
2. Click on “Add Standard Service”
   
   
3. Enter the url of the reconciliation service and click on Add Service
   
   
4. The VIVO Reconciliation Service should now show up in OpenRefine.
   
   

In the menu you can choose the type in VIVO, against which you want to reconcile your data. Click on the button “Start reconciling” to process the matching.

Configuration of the VIVO Reconciliation API

A list of types that are delivered via the API can be configured in the runtime properties. For instance, the property Vitro.reconcile.defaultTypeList can be configured as follows:

http://vivoweb.org/ontology/core#Role, core:Role; http://vivoweb.org/ontology/core#AcademicDegree, core:Academic Degree; http://purl.org/NET/c4dm/event.owl#Event, event:Event; http://vivoweb.org/ontology/core#Location, core:Location; http://xmlns.com/foaf/0.1/Organization, foaf:Organization; http://xmlns.com/foaf/0.1/Person, foaf:Person; http://purl.obolibrary.org/obo/IAO_0000030, obo:IAO_0000030