Query gives an error

[Josephine Kamp]

Hi,

If I do a query at the sparql endpoint i get following error 'The connection was reset', see picture below.
I use this query.

select?x?id?gvpLabel ?prefNl (group_concat(?alt; separator="; ")as?altNl)?noteNl{
  ?x gvp:broaderExtended aat:300209261;
     dc:identifier ?id;
     gvp:prefLabelGVP [xl:literalForm ?gvpLabel].
optional{?x xl:pfreflabel [dct:language gvp_lang:nl;xl:literalForm ?prefNI]}
optional{?x xl:altlabel [dct:language gvp_lang:nl; xl:literalForm ?alt]}
optional{?x xl:skos:scopeNote [dct:language gvp_lang:nl; rdf:value ?noteNI]}
} group by ?x ?id ?gvpLabel ?prefNI ?noteNI

Example queries from the site: some work, others don't and picture the same error. Any clues?
Thanks in advance for your time and help. 

Josephine

[Getty Vocabularies LOD]

This problem has been there since the Getty web site moved to AWS hosting. The security provided by the service thinks there is some kind of SQL injection happening with a few of the queries and blocks them. It is only tripped when functions such as group_concat() are used.

There are workarounds, if you are interested, although we realize that many people use the sample queries to begin learning SPARQL and the Vocabularies Linked Data implementation. First of all, you can run the queries using an HTTP POST method rather than the GET method the query form uses:

curl -X POST --data-binary 'query=select ?x ?id ?gvpLabel ?prefNl (group_concat(?alt; separator="| ")as?altNl) ?noteNl{ ?x gvp:broaderExtended aat:300209261; dc:identifier ?id; gvp:prefLabelGVP [xl:literalForm ?gvpLabel]. optional{?x xl:pfreflabel [dct:language gvp_lang:nl;xl:literalForm ?prefNl]} optional{?x xl:altlabel [dct:language gvp_lang:nl; xl:literalForm ?alt]} optional{?x xl:skos:scopeNote [dct:language gvp_lang:nl; rdf:value ?noteNI]} } group by ?x ?id ?gvpLabel ?prefNl ?noteNl' http://vocab.getty.edu/sparql.json

Or, you could simplify the query by taking out the group_concat() function that is making the blocking happen:

select ?x ?id ?gvpLabel ?prefNl ?noteNl{

  ?x gvp:broaderExtended aat:300209261;
     dc:identifier ?id;
     gvp:prefLabelGVP [xl:literalForm ?gvpLabel].
optional{?x xl:pfreflabel [dct:language gvp_lang:nl;xl:literalForm ?prefNI]}

optional{?x xl:skos:scopeNote [dct:language gvp_lang:nl; rdf:value ?noteNI]}

} group by ?x ?id ?gvpLabel ?prefNl ?noteNl

Hopefully we can solve the blocking issue soon. We are sorry for the inconvenience.

Gregg Garcia

Getty Digital

[Josephine Kamp]

With your suggested queri i don't get the scope notes in the result. 
So instead i use this url http://vocab.getty.edu/sparql?query=%0D%0Aselect+%3Fx+%3Fid+%3FgvpLabel+%3FprefNl+%3Falt+%3FnoteNl+%7B%0D%0A++%3Fx+gvp%3AbroaderExtended+aat%3A300212963%3B%0D%0A++++dc%3Aidentifier+%3Fid%3B%0D%0A++++gvp%3AprefLabelGVP+%5Bxl%3AliteralForm+%3FgvpLabel%5D.%0D%0A++optional+%7B%3Fx+xl%3AprefLabel+%5Bdct%3Alanguage+gvp_lang%3Anl%3B+xl%3AliteralForm+%3FprefNl%5D%7D%0D%0A++optional+%7B%3Fx+xl%3AaltLabel+%5Bdct%3Alanguage+gvp_lang%3Anl%3B+xl%3AliteralForm+%3Falt%5D%7D%0D%0A++optional+%7B%3Fx+skos%3AscopeNote+%5Bdct%3Alanguage+gvp_lang%3Anl%3B+rdf%3Avalue+%3FnoteNl%5D%7D%0D%0A%7D+&_implicit=false&implicit=true&_equivalent=false&_form=%2Fsparql

I hope you can solve this blocking issue, however this url workaround works fine too.

Op donderdag 11 april 2019 23:25:41 UTC+2 schreef Getty Vocabularies LOD:

[Vladimir Alexiev]

I inspected a page of results and it seems those concepts have only 1 altLabel@nl, so you are better off without group_concat.

I checked http://vocab.getty.edu/doc/queries/ and only 1 query has group_concat. Josephine, which queries give "Connection reset" to you?

PS: it's a pity AWS thinks that group_concat has something to do with SQL injection... On the other hand, a SQL injection is claimed to have lead to a leak of personal data of about 90% of Bulgarians, so that's serious stuff: https://twitter.com/hashtag/НАПЛийкс