Apoc.export.json.query jsonFormat setting doesn't work

[tard_gabriel]

Hello there

I'm using this query to format my data for Keylines.

CALL apoc.export.json.query("MATCH (actor: Actor {name: $nameParam})-[acted:ACTED_IN]->(movie:Movie) MATCH (movie)<--(a:Actor) RETURN movie, actor,count(distinct a) AS degree",null,{config:{jsonFormat:'JSON'}, params:{nameParam:'Johnny Depp'}, stream: true})

I'm trying to use the ARRAY_JSON value for the jsonFormat configuration but whether I use any of them [ARRAY_JSON, JSON, JSON_LINES,JSON_ID_AS_KEYS] the result in the data column doesn't change.

It's like the jsonFormat does nothing, even if the query itself works.

[dana_canzano]

@tard.gabriel
With Neo4j 4.2.1 and APOC apoc-4.2.0.0-core.jar
and
using the dataset from ':play movies' and if I modify your original query to

CALL apoc.export.json.query("MATCH (actor:Person {name: $nameParam})-[acted:ACTED_IN]->(movie:Movie) RETURN movie, actor",null,{config:{jsonFormat:'JSON'}, params:{nameParam:'Tom Hanks'}, stream: true});

I do get expected JSON results and when run via bin/cyphe-shell.

So the apoc.export.json query does work but seems like maybe there is issue with your query

[tard_gabriel]

I fixed it using this syntax:

CALL apoc.export.json.query("MATCH (actor: Actor {name: $name})-[acted:ACTED_IN]->(movie:Movie) MATCH (movie)<--(a:Actor) RETURN movie, actor,count(distinct a) AS degree",null,{jsonFormat:'ARRAY_JSON', params:{name:'Johnny Depp'}, stream: true})

But I feel it doesn't fit with the documentation.

[dana_canzano]

@tard.gabriel
'it doesnt fit with the documentation' ???? can you provide reference so we can address?

[tard_gabriel]

With Neo4j 4.2.3

When I use jsonFormat as a part of the config: {} parameter like you did it doesn't work. Whether I use any of them [ARRAY_JSON, JSON, JSON_LINES,JSON_ID_AS_KEYS] the result in the data column doesn't change. I had to put the jsonFormat like this in the query:

CALL apoc.export.json.query("MATCH (actor: Actor {name: $name})-[acted:ACTED_IN]->(movie:Movie) MATCH (movie)<--(a:Actor) RETURN movie, actor,count(distinct a) AS degree",null,{jsonFormat:'ARRAY_JSON', params:{name:'Johnny Depp'}, stream: true})

But the documentation say that jsonFormat should be a part of config parameter.

I did the test again and indeed with this form "config:{jsonFormat:'ARRAY_JSON'}" the jsonFormat is ignored with Neo4j 4.2.3 and apoc-4.2.0.1.jar

[amirkanan]

I am experiencing the same issue for Apoc.export.json.all.

JsonFormat setting doesn't work!

Neo4j export whole database to ARRAY_JSON Import / Export

I tried to use an APOC procedure from here to export the DB using the following: CALL apoc.export.json.all("all.json",{useTypes:true}) I can successfuly export to JSONL. However, I am not able to change the JSON format to other available formats such as JSON_LINES, ARRAY_JSON, JSON or JSON_ID_AS_KEYS. According to the documentation the following should work but it does not: CALL apoc.export.json.all("all.json",{config:{jsonFormat:'ARRAY_JSON'}}) The result of above procedure is in JSONL but …

[Anonymous · Accepted solution]

stackoverflow.com

Neo4j export whole database to JSON_LINES, ARRAY_JSON, JSON or JSON_ID_AS_KEYS

arrays, json, neo4j, export

answered by &#226;ńōŋŷXmoůŜ on 04:57PM - 26 Mar 21 UTC

This is now fixed in APOC 4.2.0.2. Thanks.

[tard_gabriel]

Yeah! I wasn't crazy! lol

Thanks