Link Search Menu Expand Document

OpenRefine Reconciliation Service

Our API also has an endpoint to use the OpenRefine Reconciliation Service API as well as OpenRefine’s Data Extension API.

Contents:

Set up data.slub-dresden.de as reconciliation service

  • Open an arbitrary project
  • select ReconcileStart reconciliation … in the head of a column
  • In the new window: Press Add Standard Service …
  • Insert our /reconcile endpoint as https://data.slub-dresden.de/reconcile

Example

Using the prepared file painter_born.json which only contains painter’s names and date of birth we want to enrich these persons by:

  • their place of birth (birthPlace)
  • date of death (deathDate)
  • GND-ID (contained in sameAs)

Usage of the OpenRefine Reconciliation and Data Extension API

Import example file

  • open a new project in OpenRefine
  • copy the file’s URL https://data.slub-dresden.de/assets/files/painter_born.json into OpenRefine’s Web Addresses (URLs)
  • Uncheck [ ] Preserve empty strings in order for the json file to be parsed correctly. The preview in the top part of your window should now show a table with two columns: One for the name and one with the birth date.
  • Continue with Create Project >>

    Reconciliation

  • Select ReconcileStart reconciliation … in the head of the name column

    Screenshot-reconcile-1

  • Insert https://data.slub-dresden.de/reconcile/ as additional Standard Service and select it

    Screenshot-reconcile-2

  • Select “Person” as entity and inclue the “--born” column as birthDate (See Data Type details for Persons). Eventually, press Start Reconciling

    Screenshot-reconcile-3

  • Not-matched data have to be matched manually by choosing the right dataset.

    Screenshot-reconcile-4

Add new columns based on reconciled values

  • Based on the reconciled values we now can add new value with the API’s content
  • Choose again the column where the reconciliation took place and select Edit columnAdd columns from reconciled values …

    Screenshot-reconcile-5

  • Here we search and add new properties: birthPlace, deathDate, and sameAs. Finally, apply the addition by pressing OK.

    Screenshot-reconcile-6