Nested Array Implementation in Relational MongoDb Migrator 1.4.4

Working with Data Developer Tools
,
1

Hi Dear Community,

We are trying to use MongoDb Relational Migrator in order to migrate relational data to TM Forum document data model.

There are multiple nested array fields like the following that we were not able to implement the mapping:

"relatedParty": [
    {
      "_id": "objectId",
      "role": "Agent",
      "name": "Mostafa",
      "validFor": [
        {
          "startDateTime": {
            "$date": "2023-12-31T11:48:27.859Z"
          },
          "endDateTime": {
            "$date": "2023-12-31T11:48:27.859Z"
          }
        }
      ],
      "contactMedium": [
        {
          "medium": {
            "emailAddress": "email@email.com",
            "type": "EmailAddress",
            "verified": false,
            "_class": "model.Email"
          },
          "type": "EmailAddress",
          "preferred": false
        }
      ],
      "referredType": "mainUser"
    },
    {
      "_id": "objectId",
      "role": "Customer",
      "name": "Alireza",
      "engagedParty": {
        "_id": "idnumber_table_x",
        "name": "company-name",
        "referredType": "Organization"
      },
      "referredType": "Customer",
      "externalSystem": [
        {
          "_id": "objectId_table_x",
          "system": "systemName",
          "type": "Info"
        }
      ]
    }
  ]

By adding synthetic one-to-many foreign key, it is possible to build one level of the embedded array but for the next levels we have difficulties for mapping.

Thank you in advance for sharing thoughts and experiences.
Cheers.