Example of Python/Jython script to extract Wikipedia sitelink from values reconcilied with Wikidata in OpenRefine

wikidata_api_refine.py

import json
import urllib2

langs = ["fr", "en", "de", "nl"]  # ordered list of languages you want to try until there is a match

value = cell.recon.match.id

for lang in langs:

    wiki = lang + "wiki"

    url = ("https://www.wikidata.org/w/api.php?action=wbgetentities&format=json&props=sitelinks/urls&ids=" +
           value +
           "&sitefilter=" +
           wiki)
 
    response = urllib2.urlopen(url)

    if response:
        data = json.loads(response.read())

        for i in data['entities'].values():
            try:
                return i['sitelinks'][wiki]['url']
            except:
                pass

Example