Hey everyone. I am doing a series of nested UNWINDS on a very large dataset. The data is being imported from Google Drive API's. There are some inconsistencies in datetime fields from their end. I got the following error:
{code: Neo.ClientError.Statement.SyntaxError} {message: Text cannot be parsed to a DateTime
"27043-08-14T04:24:54.000Z"
^}
This is obviously because the following insert is trying to be run from my code (I'm unwinding a large JSON list of files as 'file')
"f.modifiedTime = datetime(file.modifiedTime), "
My question is, how do I handle these sort of errors. I cant control the data that's coming in from Google. Is there something like a COALESCE of sorts that can insert a null/'NOT SET' value into the db if a query of this sort fails.
I'm using Neo4j Community 4.2.1 with the apoc plugin installed. It's being driven by python, with the official module.
