query-644dfa2ecee2ccafacf20b54d4d33f0b

rq turtle/ttl

(Ainali) Using mwapi to base a query on articles in a Wikipedia category

Use the MediaWiki API to get the articles from a specific category in a specific Wikipedia language version.

Then use this results as usual in a query, in this example a simple query for the gender.

By User:Ainali with the help of User:Dipsacus fullonum 2021-02

SELECT ?item ?itemLabel ?genderLabel WHERE { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "sv.wikipedia.org"; # Set the project here wikibase:api "Generator"; mwapi:generator "categorymembers"; # Selects the content from a category mwapi:gcmtitle "Category:Födda 2001";. # Specifies the category (Born in 2001) ?item wikibase:apiOutputItem mwapi:item. } FILTER BOUND (?item) # Safeguard to not get a timeout from unbound items when using ?item below ?item wdt:P21 ?gender . # Example retrieval of a value SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,sv". }
}

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#(Ainali) Using mwapi to base a query on articles in a Wikipedia category
# Use the MediaWiki API to get the articles from a specific category in a specific Wikipedia language version.
# Then use this results as usual in a query, in this example a simple query for the gender.
# By User:Ainali with the help of User:Dipsacus fullonum  2021-02
SELECT ?item ?itemLabel ?genderLabel WHERE {
  SERVICE wikibase:mwapi {
     bd:serviceParam wikibase:endpoint "sv.wikipedia.org";     # Set the project here
                     wikibase:api "Generator";
                     mwapi:generator "categorymembers";        # Selects the content from a category
                     mwapi:gcmtitle "Category:Födda 2001";.    # Specifies the category (Born in 2001)
     ?item wikibase:apiOutputItem mwapi:item.
  } 
  FILTER BOUND (?item)                                         # Safeguard to not get a timeout from unbound items when using ?item below
  ?item wdt:P21 ?gender .                                      # Example retrieval of a value
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,sv". }    
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?gender") v1("?item"):::projected c12(["mwapi:item"]):::iri c4(["sv.wikipedia.org"]):::literal c8(["categorymembers"]):::literal c2(["bd:serviceParam"]):::iri c10(["Category:Födda 2001"]):::literal c16(["#91;AUTO_LANGUAGE#93;,en,sv"]):::literal c6(["Generator"]):::literal f0[["bound(?item)"]] f0 --> v1 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c2 --"mwapi:endpoint"--> c4 c2 --"mwapi:api"--> c6 c2 --"mwapi:generator"--> c8 c2 --"mwapi:gcmtitle"--> c10 v1 --"mwapi:apiOutputItem"--> c12 end v1 --"wdt:P21"--> v2 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c2 --"mwapi:language"--> c16 end