Conditional statement with string list

[mjarij]

Hi,

In my following code, it is creating Node nodes whichever link is getting BUT I want to create/merge Category nodes if the link[''] value starts with 'Category:' and Node type nodes should be created if link[''] value doesn't start with 'Category:'.

P.S. In this Wikipedia API there is JSON field named as asterisk(*) by default, so don't get confuse with it.

CALL {
MATCH (n:Node { traversed:false })
RETURN n
LIMIT 5
}
CALL apoc.load.json('https://en.wikipedia.org/w/api.php?format=json&action=parse&prop=links&page=' + apoc.text.urlencode(n.name))
YIELD value as result
UNWIND result.parse.links AS link
MERGE (cn:Node {name: link['*']})
ON CREATE SET cn.traversed = false
MERGE (n)-[:Linked]->(cn)
SET n.traversed = true
RETURN 'Total nodes get: ' + count(result)

I have tried several WHERE and FOREACH clauses but these are not working with List type. Please let me know how to do it?

Thanks,
Mustafa

[andrew_bowman · Accepted solution]

Take a look at your options here:

Neo4j Graph Database Platform

Conditional Cypher Execution - Neo4j Graph Database Platform

At some point you’re going to write a Cypher query requiring some conditional logic, where you want different Cypher statements executed depending on the case. At this point in time Cypher does not include native conditional functionality to address...

[mjarij]

Thanks @andrew.bowman, apoc.do.when() worked for me Thanks

[jggomez]

Hi, You could use an APOC

CALL apoc.do.when(Predicate, SENTENCE) YIELD value

Thanks

[mjarij]

Thanks @jggomez , it worked for me Thanks