Page MenuHomePhabricator

QueryService Allow List: Updated the URL of the WikiPathways SPARQL endpoint
Open, Needs TriagePublic

Description

see: https://github.com/wbstack/queryservice/pull/113

Requested by a user on telegram

Event Timeline

@EgonWillighagen this is now shipped; please let us know if it's now doing what you need

I cannot confirm it working online yet, tho. The following SPARQL should work:

sparql
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
SELECT ?lipid ?wpLipid ?lmIRI WHERE {
  ?lipid wdt:P2063 ?lmid .
  BIND (iri(concat("https://identifiers.org/lipidmaps/", str(?lmid))) AS ?lmIRI)
  SERVICE <https://sparql.wikipathways.org/sparql> {
    ?wpLipid wp:bdbLipidMaps ?lmIRI .
  }
}

But I get this error message:

image.png (119×796 px, 9 KB)

Maybe "shipped" means part of the dev version and will be part of the next release? But I hope the query can be used as a test.

Interestingly I think service is working fine (both wikibase.cloud staging and production) for me. I tested this with the following query:

https://coffeebase.wikibase.cloud/query/#PREFIX%20wp%3A%20%3Chttp%3A%2F%2Fvocabularies.wikipathways.org%2Fwp%23%3E%0ASELECT%20%3FwpLipid%20%3FlmIRI%20WHERE%20%7B%0A%20%20SERVICE%20%3Chttps%3A%2F%2Fsparql.wikipathways.org%2Fsparql%3E%20%7B%0A%20%20%20%20%3FwpLipid%20wp%3AbdbLipidMaps%20%3FlmIRI%20.%0A%20%20%7D%0A%7D%0A

this is simpler than your query and run on a wiki I know (I wasn't sure which wiki to run your query on)?

Could you try it and let me know if I'm missing something?

Ah, thanks. I was running it on the Wikidata query service. I guess it was just not rolled out there. I really appreciate that this was picked up!

Thanks for the PR. Unfortunately changes here won't automatically feed into the wikidata deployment. I made a ticket for it :)