Content Store schemas

This section describes the Content Store schemas.

Root schema

Use the root schema to store the starting point of the migration. The kind of the object is ‘ROOT’.

{
  // REQUIRED | STRING | A generated id based on objects metadata, must be unique.
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["ROOT"]
  "kind": "ROOT",
  // REQUIRED | OBJECT | Object containing the data from the target repository.
  "target": {
    // REQUIRED | STRING
    "id": "{{source.id}}",
    // REQUIRED | ARRAY | Path notation of the location of the object. Always starts with a forward slash.
    "hierarchies": ["{{source.hierarchies}}"],
    // REQUIRED | OBJECT
    "name": {
      // REQUIRED | STRING
      "systemName": "{{source.name.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.name.displayName}}"
    },
    // REQUIRED | OBJECT
    "contentType": {
      // REQUIRED | STRING | System name of the content type of the object.
      "systemName": "{{source.contentType.systemName}}",
      // OPTIONAL | STRING | Display name of the content type of the object.
      "displayName": "{{source.contentType.displayName}}"
    }
  },
  // REQUIRED | OBJECT
  "migration": {
    // REQUIRED | STRING | The id of the CONTAINER where the migration starts.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage": {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget": "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

Content Schema

To use the schema set the kind to ‘RECORD’, ‘CONTAINER’.

{
  // REQUIRED | STRING | A generated id based on objects metadata, must be unique.
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["RECORD", "CONTAINER"]
  "kind": "RECORD",
  // REQUIRED | OBJECT | Object containing the data from the source repository.
  "source": {
    // REQUIRED | STRING | The id of the object as it is in the source system.
    "id": "{{source.id}}",
    // REQUIRED | ARRAY | The parent source ids of the object. If there is no parent, the value should be an empty array.
    // The parent should also be stored in the database. If for extraction reasons the parent is not stored in the database (in case of the root for example), it should be treated as if there is no parent.
    "parentIds": ["{{source.parentIds}}"],
    // REQUIRED | ARRAY | Path notation of the location of the object. Always starts with a forward slash.
    "hierarchies": ["{{source.hierarchies}}"],
    // OPTIONAl | ARRAY | The ancestors ids of the object. Ancestors are the parents and the parents of the parents and so on. If there is no parent, the value should be an empty array. Only keep the ancestors that are stored in the database.
    "ancestors": ["{{source.ancestors}}"],
    // REQUIRED | OBJECT
    "name": {
      // REQUIRED | STRING
      "systemName": "{{source.name.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.name.displayName}}"
    },
    // OPTIONAL | STRING
    "description": "{{source.description}}",
    // REQUIRED | OBJECT
    "contentType": {
      // REQUIRED | STRING | System name of the content type of the object.
      "systemName": "{{source.contentType.systemName}}",
      // OPTIONAL | STRING | Display name of the content type of the object.
      "displayName": "{{source.contentType.displayName}}"
    },
    // REQUIRED | OBJECT
    "versionInfo": {
      // OPTIONAL | STRING | Version label of the object, if non existing in the source repository set to ‘1.0’.
      "label": "{{source.versionInfo.label}}",
      // REQUIRED | NUMBER
      "minor": 1,
      // REQUIRED | NUMBER
      "major": 1,
      // REQUIRED | STRING | An identifier that represents the complete set of versions.
      "seriesId": "{{source.versionInfo.seriesId}}",
      // REQUIRED | BOOLEAN | Indicates if the version is the current version.
      "isCurrent": true,
    },
    // REQUIRED | ARRAY | One or more state values, think hidden, archived, deleted, etc. If none, provide an empty list.
    "states": ["{{source.states}}"],
    // OPTIONAL | OBJECT
    "created": {
      // REQUIRED | DATE
      "date": "{{source.created.date}}",
      // OPTIONAL | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.created.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.created.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "lastModified": {
      // REQUIRED | DATE
      "date": "{{source.lastModified.date}}",
      // OPTIONAL | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.lastModified.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.lastModified.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "lastAccessed": {
      // OPTIONAL | DATE
      "date": "{{source.lastAccessed.date}}",
      // OPTIONAL | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.lastAccessed.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.lastAccessed.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "author": {
      // REQUIRED | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.author.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.author.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "owner": {
      // REQUIRED | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.owner.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.owner.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "language": {
      // REQUIRED | STRING
      "systemName": "{{source.language.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.language.displayName}}",
      // REQUIRED | STRING | If the object is the master, reference to itself.
      "masterReference": "{{_id}}"
    },
    // OPTIONAL | OBJECT
    "web": {
      // OPTIONAL | ARRAY | List of environments where the content is published to.
      "publishedTo": "{{source.web.publishedTo}}",
      // REQUIRED | STRING | Full web URL to the object.
      "url": "{{source.web.url}}"
    },
    // OPTIONAL | OBJECT
    "link": {
      // Required | STRING | Full web URL of the destination for the external links or the source.id of the destination object in the content store for the internal links.
      "destination": "{{source.link.destination}}",
      // Required | BOOLEAN | If the link destination is a reference to an internal object.
      "internal": {{source.link.internal}}
    },
    // OPTIONAL | OBJECT | Object containing a copy of the original object. Within target it contains the system specific or custom properties.
    "properties": {},
    // OPTIONAL | ARRAY OF _ID REFERRING TO THE BINARY OBJECTS
    "binaries": [],
    // OPTIONAL | ARRAY OF _ID REFERRING TO THE ACL OBJECTS
    "acls": [],
    // OPTIONAL | ARRAY OF _ID REFERRING TO THE AUDIT LOG OBJECTS
    "auditLogs": []
  },
  // OPTIONAL | OBJECT | HOLDS THE VALUES AFTER TRANSFORMATION, EQUAL STRUCTURE TO SOURCE OBJECT
  "target": {},
  // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage": {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget": "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

note

The first _id in the binaries array is the primary binary.

Binary Schema

Use the binary schema to store binary metadata. The kind of object is ‘BINARY’.

{
  // REQUIRED | STRING
  "_id": "{{source.id}}",
  // REQUIRED | STRING | OPTIONS: ["BINARY"]
  "kind": "BINARY",
  // REQUIRED | OBJECT
  "source": {
    // OPTIONAL | OBJECT
    "name": {
      // REQUIRED | STRING
      "systemName": "{{source.name.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.name.displayName}}"
    },
    // OPTIONAL | STRING | Field to specify a certain binary type, for example if the binary is a rendition.
    "type": "{{source.type}}",
    // REQUIRED | STRING | Field to specify raw extension of binary. Either an empty string or a string starting with a dot.
    "rawExtension": "{{source.rawExtension}}",
    // REQUIRED | STRING | Field to specify extension of binary. Either an empty string or a string starting with a dot.
    "extension": "{{source.extension}}",
    // REQUIRED | NUMBER
    "byteSize": 1,
    // OPTIONAL | STRING | Reference where the binary resides, this can be a URL or a path to a network drive.
    "externalReference": "{{source.externalReference}}",
    // OPTIONAL | STRING | Reference to the local GridFS copy of the binary.
    "localReference": "{{source.localReference}}",
    // OPTIONAL | STRING | Unique hash of the binary (for example SHA256 or SHA512).
    "hash": "{{source.hash}}",
    // OPTIONAL | OBJECT | Object containing a copy of the original object.
    "properties": {}
  },
  // OPTIONAL | OBJECT | FILLING IN ONE OR MORE KEY(S) TRIGGERS VALIDATION AS SOURCE OBJECT
  "target": {},
  // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage" : {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget" : "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

Relation Schema

Use the relation schema to store relation metadata. The kind of object is ‘RELATION’.

{
  // REQUIRED | STRING
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["RELATION"]
  "kind": "RELATION",
  // REQUIRED | OBJECT
  "source": {
    // OPTIONAL | STRING
    "name": "{{source.name}}",
    // OPTIONAL | STRING
    "type": "{{source.type}}",
    // REQUIRED | STRING
    "parentId": "{{source.parentId}}",
    // REQUIRED | STRING
    "childId": "{{source.childId}}",
    // OPTIONAL | OBJECT | Object containing a copy of the original object.
    "properties": {}
  },
  // OPTIONAL | OBJECT | FILLING IN ONE OR MORE KEY(S) TRIGGERS VALIDATION AS SOURCE OBJECT
  "target": {},
  // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage" : {},
    // OPTIONAL | STRING | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget" : "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

Acl Schema

Use the Acl schema to store Acl metadata. The kind of object is ‘ACL’.

{
  // REQUIRED | STRING
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["ACL"]
  "kind": "ACL",
  // REQUIRED | OBJECT
  "source": {
    // OPTIONAL | OBJECT
    "name": {
      // REQUIRED | STRING
      "systemName": "{{source.name.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.name.displayName}}"
    },
    // OPTIONAL | STRING
    "description": "{{source.description}}",
    // OPTIONAL | OBJECT
    "created": {
      // REQUIRED | DATE
      "date": "{{source.created.date}}",
      // OPTIONAL | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.created.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.created.principal.displayName}}"
      }
    },
    // OPTIONAL | OBJECT
    "lastModified": {
      // REQUIRED | DATE
      "date": "{{source.lastModified.date}}",
      // OPTIONAL | OBJECT
      "principal": {
        // REQUIRED | STRING
        "systemName": "{{source.lastModified.principal.systemName}}",
        // OPTIONAL | STRING
        "displayName": "{{source.lastModified.principal.displayName}}"
      }
    },
    // REQUIRED | ARRAY | Array of permissions (STRING).
    "permissions":[],
    // REQUIRED | ARRAY | Array of principal objects.
    "principals": [],
    // OPTIONAL | OBJECT | Object containing a copy of the original object.
    "properties": {}
  },
  // OPTIONAL | OBJECT | FILLING IN ONE OR MORE KEY(S) TRIGGERS VALIDATION AS SOURCE OBJECT
  "target": {},
  // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage" : {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget" : "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

AuditLog Schema

Use the AuditLog schema to store relation metadata. The kind of object is ‘AUDITLOG’.

{
  // REQUIRED | STRING
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["AUDITLOG"]
  "kind": "AUDITLOG",
  // REQUIRED | OBJECT
  "source": {
    // OPTIONAL | OBJECT
    "value": {},
    // OPTIONAL | OBJECT | Object containing a copy of the original object.
    "properties": {}
  },
  // OPTIONAL | OBJECT | FILLING IN ONE OR MORE KEY(S) TRIGGERS VALIDATION AS SOURCE OBJECT
  "target": {},
  // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage" : {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget" : "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}

Principal Schema

Use the Principal schema to store principal metadata. For example, users and groups. The kind of object is ‘PRINCIPAL’.

{
  // REQUIRED | STRING
  "_id": "{{_id}}",
  // REQUIRED | STRING | OPTIONS: ["PRINCIPAL"]
  "kind": "PRINCIPAL",
  // REQUIRED | OBJECT
  "source": {
    // REQUIRED | STRING | The id of the principal as it is in the source system.
    "id": "{{source.id}}",
    // REQUIRED | STRING | OPTIONS: ["USER", "GROUP", "OTHER"] | The type of the principal.
    "type": "{{source.type}}",
    // REQUIRED | OBJECT
    "name": {
      // REQUIRED | STRING
      "systemName": "{{source.name.systemName}}",
      // OPTIONAL | STRING
      "displayName": "{{source.name.displayName}}"
    },
    // ONLY WHEN source.type is set to 'GROUP' | ARRAY | List of members that are part of the group. Refers to the `source.id` (or) of a principal.
    "members": ["{{source.members}}"],
    // OPTIONAL | OBJECT | Object containing a copy of the original object.
    "properties": {}
  },
  // OPTIONAL | OBJECT | FILLING IN ONE OR MORE KEY(S) TRIGGERS VALIDATION AS SOURCE OBJECT
  "target": {},
   // REQUIRED | OBJECT
  "migration": {
    // OPTIONAL | STRING | The id of document after loading into the target repository.
    "id": "{{migration.id}}",
    // REQUIRED | BOOLEAN | Determines if the object will be migrated. If false, the object will not be migrated.
    "migrate": true,
    // OPTIONAL | BOOLEAN
    "failed": false,
    // OPTIONAL | STRING | Holds the message related to to failed state (error message).
    "failedMessage": "",
    // OPTIONAL | OBJECT | Holds custom flags during a migration process. Can be used to keep track off different statuses. Keys must be of type String, values of type Boolean.
    "flags": {
      // OPTIONAL | BOOLEAN
      "anyString": false,
    },
    // OPTIONAL | STRING | Identifier string for load balancer flows.
    "workerId": "",
    // OPTIONAL | STRING | OPTIONS: ["ASSIGNED", "PROCESSING", "DONE", "ERROR"] | The status of an object from the worker perspective.
    "workerStatus": "",
    // OPTIONAL | OBJECT | A copy of the incoming message from the component that generated an error.
    "retryMessage" : {},
    // OPTIONAL | STRING  | The name of the component to target when retrying (depends on the targeted flow).
    "retryTarget" : "",
    // REQUIRED | STRING | Specifies the origin of the document in the Content Store.
    "origin" : "{{migration.origin}}"
  }
}