I can't authenticaticate in Wikimedia Commons Query Service
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Podbrushkin
	Feb 17 2025, 1:27 PM

Description

I'm trying to access SparQL endpoint from Powershell - https://commons-query.wikimedia.org/ , but I'm getting HTML Login page instead of query results even if I provide "wcqsSession" token in my request.

This SO answer provides following snippet:

import sys
import requests

ENDPOINT = "https://wcqs-beta.wmflabs.org/sparql"
QUERY = """
SELECT ?file WHERE {
  ?file wdt:P180 wd:Q42 .
}
"""

r = requests.get(
    ENDPOINT,
    params={"query": QUERY},
    headers={"Accept": "application/sparql-results+json", "wcqsSession": "<token retrieved after logging in"}
)


print(r.text)

I've replaced <token retrieved after logging in with wcqsSession token I've got from browser (73 chars), but still I'm getting HTML instead of json.

This is a Pwsh alternative:

#$endpoint = 'https://commons-query.wikimedia.org/sparql'
$endpoint = 'https://wcqs-beta.wmflabs.org/sparql'
#$endpoint = 'https://commons-query.wikimedia.org/'

Invoke-RestMethod -Uri $endpoint -Method Get -Headers @{
  Accept = "application/sparql-results+json"
  wcqsSession = $wcqsSession
} -Body @{query=$sparql; format='json'}

It returns HTML as well (regardless of which endpoint url was used).

I wonder if I'm doing something wrong or is there another way to query WCQS with SparQL from Powershell?

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Stalled		None	T376979 Figure out the future of Wikimedia Commons Query Service (WCQS)
		Resolved		dcausse	T386638 I can't authenticaticate in Wikimedia Commons Query Service

Event Timeline

Podbrushkin created this task.Feb 17 2025, 1:27 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 17 2025, 1:27 PM

I'm not sure that wcqsSession is a header that WCQS will inspect. It should work if set as a cookie:
(also please use https://commons-query.wikimedia.org/sparql directly)

import requests

wcqsSession = "my wcqsSession cookie"

resp = requests.get("https://commons-query.wikimedia.org/sparql", params={"query": "SELECT * { ?s ?p ?o } LIMIT 1", "format": "json"}, cookies={"wcqsSession": wcqsSession})
resp.raise_for_status()
print(resp.json())

Gehel added a parent task: T376979: Figure out the future of Wikimedia Commons Query Service (WCQS).Feb 17 2025, 4:14 PM

@Arrbee : could you give us guidance on the priority of this?

In T386638#10557064, @dcausse wrote:

It should work if set as a cookie

Thank you, it works. Here is how it looks with Powershell:

$wcqsSession = Get-Clipboard # Get this token from browser headers

$wcqsSparql = [System.Uri]'https://commons-query.wikimedia.org/sparql'
$sparql = 'SELECT * { ?s ?p ?o } LIMIT 1'

$wcqsCookie = New-Object System.Net.Cookie
$wcqsCookie.Name = "wcqsSession"
$wcqsCookie.Value = $wcqsSession
$wcqsCookie.Domain = $wcqsSparql.DnsSafeHost

$WebSession = New-Object Microsoft.PowerShell.Commands.WebRequestSession
$WebSession.Cookies.Add($wcqsCookie)

$wcqsHeaders = @{ Accept = "application/sparql-results+json" }
Invoke-RestMethod -Uri $wcqsSparql.AbsoluteUri -Method Get -Headers $wcqsHeaders -Body @{query=$sparql} -WebSession $WebSession -OutVariable resp

dcausse moved this task from needs triage to 2025.02.10 - 2025.02.28 on the Discovery-Search board.Feb 18 2025, 7:45 AM

dcausse edited projects, added Discovery-Search (2025.02.10 - 2025.02.28); removed Discovery-Search.

@Podbrushkin thanks for confirming that it works and for adding a correct answer to SO.
I'm closing this ticket but feel free to re-open if you think I missed something.

Gehel moved this task from Done to Reported on the Discovery-Search (2025.02.10 - 2025.02.28) board.Feb 21 2025, 1:16 PM

I can't authenticaticate in Wikimedia Commons Query ServiceClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

I can't authenticaticate in Wikimedia Commons Query Service
Closed, ResolvedPublic
Actions

Related Objects
Search...