NiFi Processor: Save ISO format date into mongoDb using PutMongo Processor
I am trying to insert a flow file into MongoDb which has a createdAt date key record as an attribute.
When I inserted that flow file into MongoDb using PutMongo processor, it saves the "createdAt" attribute as a string. I want this to be saved as an ISO date object in mongoDB.
When I inserted flow file by sending "2020-08-26T04:00:00.000Z" PutMongo Processor inserts as a string.
When I sent like this “ISODate("2020-08-26T04:00:00.000Z”)” it also inserts same string as it is into mongo.
When I tried like this ISODate("2020-08-26T04:00:00.000Z”) without double quotation it throws error invalid object.
I need output as :
{
“createdAt”: ISODate("2020-08-26T04:00:00.000Z”)
}
Kindly help if there is any way to do so.


