Vladimir Alexiev
I am a metadata librarian at Iowa State University Library and I am reaching out to you with a question regarding the Getty Vocabulary ontology and the LOD sample queries (http://vocab.getty.edu/doc/queries/) published on the Getty website and authored by you.
I am trying to use the GVP LOD as a reconciliation service for openrefine following the workaround worked out by Inge van Stokkom and that you included on these sample queries (http://vocab.getty.edu/doc/queries/#OpenRefine_Reconciliation_Service). I am having a problem with one of the instructions and I am reaching out to you with the hopes that you could throw some light on what the issue is and if it is something I am doing wrong or a flaw of the system. Please apologize for contacting you directly, but I wasn’t sure who I should direct this question too and the getty website doesn’t provide a contact info for the use of the GVP (or at least I haven’t been able to find it).
I have a list of genre terms as my starting point. For my testing, I am just using 5 terms that I have already verified exist on the AAT vocabulary. I am able to fetch a url based on the column that contains the terms using the sparql query http://vocab.getty.edu/sparql.json?query=select+distinct*{?x+skos:inScheme+aat:;(xl:prefLabel|xl:altLabel)/gvp:term"' + escape(value, 'url') + '"@en}, parse the json to obtain the url and parse the identifier out of the url.
Then I try the second proposed query to fetch the prefLabelGVP based on the identifier, but the system doesn’t retrieve anything. I have tested one of the queries (http://vocab.getty.edu/sparql.json?query=select*where{?x+gvp:prefLabelGVP[skosxl:literalForm ?label];dc:identifier"300312057"}) directly on the browser and it does download the json file, but when I try it from openrefine with the command add a column by fetching url, the resulting column is blank.
I am not sure why the openrefine command “add column by fetching url” works for the first query and creates a new column with the json content, but not with the second query creating a blank column as a result.
Any help will be greatly appreciated.
Many thanks! Paloma
Paloma Graciani Picardo
Metadata Librarian
Iowa State University
Vladimir Alexiev
Maybe try "+" instead of " " in the second query, since " " is not valid in a URL. I.e. try this:
http://vocab.getty.edu/sparql.json?query=select*where{?x+gvp:prefLabelGVP[skosxl:literalForm+?label];dc:identifier"300312057"}
p.graciani
Hi Vladimir,