UNWIND error when I try to import a JSON

[gorkasalauniversidad (Gorka)]

@andrew_bowman

If you have any ability to reformat the data, I'd recommend pulling those up, such that components isn't a list of 3 mismatched objects, but is a map with keys for actioner, actioned, and time

Okay, I understand what you say.

But I can't reformat the data, so what I've been thinking is to delete null values in a WHERE sentence:

CALL apoc.load.json("example.json") YIELD value AS json
UNWIND json.objects AS objects
UNWIND objects.part2.components as component
WITH *, component.actioner AS actioner WHERE component.actioner IS NOT NULL
return actioner.text

But I can do it once, if I do the same with actioned I get no results:

CALL apoc.load.json("example.json") YIELD value AS json
UNWIND json.objects AS objects
UNWIND objects.part2.components as component
WITH *, component.actioner AS actioner WHERE component.actioner IS NOT NULL
WITH *, component.actioner AS actioner WHERE component.actioner IS NOT NULL
return actioner.text