Running 3.5.3 with latest APOC.
If I run this with the "FOREACH" line commented out, it runs just fine. If I leave the FOREACH in I receive this error:
Neo.DatabaseError.Statement.ExecutionFailed: Expressions need to be registered with it's owning Pipe, so the profiling knows where to report db-hits
Here's the cypher:
MATCH (n:Clientdomain)--(a:Company {name:'Some Company'})--(kba:Knowbe4account)
OPTIONAL MATCH (cnp:Contact {name:'None Provided'})
WITH a,kba,cnp,"super-secret-token" as token,"https://us.api.knowbe4.com/v1/users" as url
CALL apoc.load.jsonParams(url,{Authorization:"Bearer "+token,Accept:"application/json"},null) yield value
OPTIONAL MATCH (c:Contact)--(a) where toLower(trim(value.email)) = toLower(trim(c.email))
OPTIONAL MATCH (c2:Contact)--(a) where toLower(trim(c.name)) = toLower(trim(value.first_name))+' '+toLower(trim(value.last_name))
FOREACH (ignoreMe in CASE WHEN not((kba)--(c)) and exists(c.acctrecid) THEN [1] ELSE [] END | MERGE (kba)-[:KNOWBEFORE_USER]-(c))
return c,kba
I know this ran properly in a previous version (not sure which exactly)
