How to pass python variable to sparql query?

Question

I would expect/hope something like this works:

import requests

my_variable = 'wd:Q1968435'

url = 'https://query.wikidata.org/sparql'
query = """
    SELECT ?item ?itemLabel 
        WHERE 
            {
            ?item wdt:P31 "+my_variable+".
            SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
            }
    """
r = requests.get(url, params= {'format': 'json', 'query': query})
data = r.json()

But this does not work. Is there a simple solution?

Thanks in advance!

Check closely how you're concatenating the `query` string variable. — Marco Aurelio Fernandez Reyes, Mar 25 '22 at 21:24

score 0 · Accepted Answer · answered Mar 25 '22 at 21:35

0

Taking as example this answer, I modified your code for concatenating your multiline string as follows:

import requests

my_variable = 'wd:Q1968435'

url = 'https://query.wikidata.org/sparql'
query = (
    'SELECT ?item ?itemLabel ',
     '   WHERE ',
     '       {',
     '       ?item wdt:P31 '+my_variable+'.', 
     '       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }'
     '       }'
)

# make request: 
r = requests.get(url, params= {'format': 'json', 'query': "".join(query)})
data = r.json()
print("".join(query)) # Here I'm printing the string concatenated as single line.

# Print the result of the request.
print(data)

The result of the previous string concatenation is:

SELECT ?item ?itemLabel    WHERE        {       ?item wdt:P31 wd:Q1968435.       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

answered Mar 25 '22 at 21:35

Marco Aurelio Fernandez Reyes

2,071
2
9
33

1

great! thank you for the answer and the other linked example – MrTree Mar 25 '22 at 21:39
@MrTree you're welcome. BTW, I'm learning Python, so, as advice, I think we should search for the best way to build a mulltiline string - but, I'm glad my solution is good enough for you. – Marco Aurelio Fernandez Reyes Mar 25 '22 at 21:40
I prefere to use f strings ```query = ( f'SELECT ?item ?itemLabel ' ' WHERE ' ' {' ' ?item wdt:P31 {my_variable}.' ' SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }' ' }' )``` – bert wassink Mar 25 '22 at 21:48
@Marco what you mean exactly? – What could be a better way to build a multiline string? – MrTree Mar 25 '22 at 21:50
@MrTree, in the linked answer you can find other alternatives. – Marco Aurelio Fernandez Reyes Mar 25 '22 at 21:52
@Marco I see, but I think your attempt is quite readable and handy ;) There also shouldn't occur performance issues. – MrTree Mar 25 '22 at 22:00

How to pass python variable to sparql query?

1 Answers1

Linked