0

Query via Python REST-APi enter image description here message: Invalid input: ':' enter image description here

Hello, i am starting a query via my Python-Neo4j-Api. But the code ist not working, resulting in the the error message above. But the same query is working in the Neo4J Desktop App. Why is it working in the Neo4j Desktop App, but not via my Api Query. Why is the : before param a Problem?

I am new to Python and Neo4j, please help. King regards.

Trying to query via a Python-Neo4j-RestAPI.

jose_bacoy
  • 12,227
  • 1
  • 20
  • 38
Tim
  • 35
  • 4
  • This is a common error when you think that the syntax on using parametarized query in neo4j desktop is the same with neo4j python driver, which is not the same. – jose_bacoy Feb 06 '23 at 13:57

2 Answers2

0

I see that you have been working with the database though the browser application. So commands that are prefixed with ":" like :params or :connect are browser commands and is not valid cypher. Instead, in python pass your parameters as the second argument to your to your session.run() function or transaction. Then use variable substitution to in your cypher query.

params = {"name": "Tom Hanks" }
with driver.session as session:
    result = session.run ("MATCH (p:person) where p.name = $name return p", params)
Max Andersson
  • 11
  • 3
0

Below is the syntax on passing parameters in neo4j python driver. Unfortunately, you cannot use labels or relationship types in the parameter. If you need to pass labels (like Human:Moviestar) then you can use string function in python like this: passing parameters in neo4j using python

name = "Tom Cruise"
placeOfBirth = "Syracuse, New York, United States" 
query = "Create (n:Human:Moviestar { name: $name, placeOfBirth: $placeOfBirth})"
session = driver.session()
result = session.run(query, name=name, placeOfBirth=placeOfBirth)
jose_bacoy
  • 12,227
  • 1
  • 20
  • 38
  • Thank you very much, i have posted a similiar question here, maybe you can help me here as well, would be very kind: https://stackoverflow.com/questions/75398155/neo4j-python-fastapi-fstrings – Tim Feb 09 '23 at 11:49