Hello forum,

I am tasked with parsing a document in MongoDB that has a number of nested arrays or elements of data - the number of the nested elements can be any so I cannot preset it manually on the MongoDB Input Transformation Component to a certain number (e.g. as $.Sensors[0].Value then $.Sensors[1].Value and so forth), hence I attempted to operate on the JSON variable coming out of the Mongo Input.

However, it appears actually not JSON complaint, but raw BSON instead (unlike specified in the Mongo Input component).
Therefore I have an issue parsing it using the JSON Path in a JavaScript Task for it being not JSON valid (using a library as helper).
Stripping the BSON metadata bits appears UN-reliable (for parasites in data).

I am curious if anyone has a BSON Path or BSON parser to extract the nested elements.