How to omit the incorrect datatype when use apoc.convert.fromJsonList?

Neo4j Graph Platform
,
#1

Is it possible to omit the incorrect datatype when use apoc.convert.fromJsonList?
Because when I load the JsonList some of the lists are incorrect data format and show the error.

The normal list is like:

[{"scent":"T48","drops":"8","color":"#E86FA2","userFeeling":["清香"]},{"scent":"MA55","drops":"5","color":"#E9423C","userFeeling":["甜甜的"]},{"scent":"BA56","drops":"8","color":"#0097B5","userFeeling":["清爽"]}]

The incorrect one is :

[{"scent":"M10","drops":"2","color":"#E5127F","userFeeling":["

It is not the correct data format apparently.
Should I use "CASE THEN" to ignore those incorrect data?
But when I load those data I need to use apoc.convert.fromJsonList firstly.

#2

I think it would make more sense to run your data through a JSON checker/lint and fix the problems before trying to process the data in Neo4J.

See:

Or if it's a rather simple, systematic problem, write a script to find and fix the errors.

#3

Thanks for your help! :slight_smile: