//Comments and unnecessary optional parameters need to be removed before saving the Json editor
{
  "collector": {
    "workflowSpaceId": "", // GUID, (mandatory)
    "variables": [ // optional
      {
        "name": "",
        "parameterName": "", // optional - by default has the same value as name
        "dbType": "", // values from DbType enum
        "value": "",
        "comparisonOperator": "", // expected values: eq/gt/lt/gte/lte/isnull/isnotnull
        "logicalOperator": "" // expected values: and/or/none
      }
    ],
    "completedAfter": "", // date. optional
    "olderThan": {
      "amount": 1, // integer
      "timeUnit": "d" // expected values: d/m/y,  (mandatory)
    },
    "archiveWhenOpenChildrenExists": false, // optional - false by default
    "archiveAsStandAlone": false, // optional - false by default
    "childWorkflowSpaceIdsToExclude": [] // optional GUID array
  },
  "archive": {
    "defaultArchiveGroup": "explicit", //"all / explicit",
    "tables": [
      {
        "schema": "dbo", // The SQL schema where this table exists (mandatory)
        "name": "Table1", // The SQL table name (mandatory)
        "alias": "Alias1", // The alias for this table to be used in the retrieved data file.
        "masterInstanceColumnName": "myKey", // The column name in this table to match with the master instance workflow Id (mandatory)
        "columns": [ { "name": "myCol","alias": "myAlias" } ], // List of aliases for columns in this table to be used in the retrieval.
        "indexColumns": [ { "name": "myCol","indexColumnName": "myIndexName" } ], // List of columns in this table to be used as an index for the retrieval filtering.  
        "action": "Archive" // Expected values: Archive | Delete |Exclude (mandatory)
      }
    ],
    "simulationMode": false, //  (mandatory)  - false by default
    "moveFilesToFilesArchiveStorage": true // optional - true by default, when true the actual files (blobs) are moved to the archive file storage, otherwise the actual files are left on the current file storage
  }
}