2

I want to use wikidata reconciliation to translate a column of terms into various languages by fetching the labels in those languages. Using SPARQL, I'd filter a query for label by language (this is the approach suggested in various similar cases). I don't see how to do the same using OpenRefine reconciliation, however.

enter image description here

Maybe the problem is that the wikidata API is language-specific?

Will Hanley
  • 457
  • 3
  • 16

1 Answers1

7

Say that you want to fetch labels in Italian, which has language code it. You can do that by entering Lit in the property input. You can also fetch descriptions with Dit or aliases with Ait. To fetch these terms in other languages, replace it by other language codes.

This is only documented at https://github.com/OpenRefine/OpenRefine/wiki/Reconciliation so far - I acknowledge that we need a more visible documentation for this (ideally it should be easily accessible from OpenRefine's user interface, given that the reconciliation service comes preconfigured in OpenRefine).

pintoch
  • 2,293
  • 1
  • 18
  • 26
  • 2
    where do I add this "property input" @pintoch? I started writing "Les" [for labels in Spanish] in the "Add property" box as shown in @Will Hanley's image above, but I only got "SPARQL: Les" as a suggestion and that led me to an error – silviaegt Nov 30 '20 at 21:05
  • 1
    Just wanted to report that selecting SPARQL: Les seems to give the correct result at the moment. – nikopartanen Mar 11 '22 at 13:54