Member since
07-17-2024
1
Post
1
Kudos Received
0
Solutions
07-24-2024
07:55 PM
1 Kudo
When I use the GETMONGO processor to read source data from MongoDB with the output format set to Standard JSON, it converts the original date value to the local timestamp. However, when using the Extended JSON format, the original date value appears but in a different format. I need one of the following solutions: 1. Original date value in Standard JSON format: The date should appear as "createdAt": "2012-08-27T22:32:56Z". 2. Date format in Extended JSON: The date should appear as {"createdAt": "2012-08-27T22:32:56Z"}. 3. Transformation: Convert the Extended JSON format from "createdAt": {"$date": "2012-08-27T22:32:56Z"} to {"createdAt": "2012-08-27T22:32:56Z"}. Here are examples of the outputs: **Standard JSON output:** [ { "_id": "629f3a565f65e119263fa79e", "id": "46dd1621-910f-4eb6-91a0-5ae609a77b10", "firstName": "kelly", "createdAt": "2012-08-28T10:32:56Z", "modifiedAt": "2024-07-01T18:17:29Z", "suspended": false, "linkedAccounts": [ { "accountNumber": "100000000", "accountType": "SAV", "linkedAt": "2012-08-28T10:36:58Z" } ], "auth0Id": "46dd1621-910f-4eb6-91a0-5ae609a77b10", "gender": "FEMALE" } ] **Extended JSON output:** [ { "_id": {"$oid": "629f3a565f65e119263fa79e"}, "id": "46dd1621-910f-4eb6-91a0-5ae609a77b10", "firstName": "kelly", "createdAt": {"$date": "2012-08-27T22:32:56Z"}, "modifiedAt": {"$date": "2024-07-01T06:17:29.467Z"}, "suspended": false, "linkedAccounts": [ { "accountNumber": "100000000", "accountType": "SAV", "linkedAt": {"$date": "2012-08-27T22:36:58Z"} } ], "auth0Id": "46dd1621-910f-4eb6-91a0-5ae609a77b10", "gender": "FEMALE" } ] Thanks for the help.
... View more