Reading date using textractjsonfield

Hi All,
I have created tmongoinput to read the collection from the source MongoDb. The collection has a datearray, Inorder to read this array I have used textractJsonfield component. I am reading by JsonPath , jsonfield i have given as DateArray, and in the loop I have give it as “$.[*]” mapping json query i have given it as “testdate1”. The sample JSON field is shown below. The output that I should get is the date value : 2016-04-05T23:00:00.000Z, but I am getting it as {"$date":“2016-04-05T23:00:00.000Z”}. Is there way in textractjsonfield that i can remove the $date value and read the value alone. Can you please help me in this.

“DateArray” : [
{
“testdate1” : ISODate(“2016-04-05T23:00:00.000Z”),
“testDate2” : ISODate(“2016-04-29T23:00:00.000Z”),
}
},
{
“testdate1” : ISODate(“2016-05-05T23:00:00.000Z”),
“testdate2” : ISODate(“2016-05-30T23:00:00.000Z”)
}
]

This topic was automatically closed after 70 days. New replies are no longer allowed.