I need a way to correct a few fields in a very embedded MongoDB schema (alteryx appinfos for further context). We need to use pymongo as we’re creating an Alteryx asset to fix database corruptions.
Below is a screenshot of the schema. I’ve outlined in red what needs to be updated.
The name field sits in the MetaInfo object of the Applications array, which is inside the Revisions array.
I can calculate the exact array indices, but don’t know how to get the pymongo to use those for the update.
Can we even correct something so deeply embedded? Or do we need to replace the contents of the entire ObjectId whenever we want to make a correction?
Thank you. Cheers!
Esther