JSON File: TrackGrandDetailsExample.json

{
  "departmentinfo": {
    "identity": "70c86603-983b-4bd9-adbc-259436e43cbd",
    "version": 1,
    "platform": "Platform A",
    "mapping-method": 0,
    "dataobject": {
      "name": "d_department",
      "meta-columns": [
        {
          "name": "DepartmentID",
          "index": 0,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "Name",
          "index": 1,
          "datatype": "string",
          "nullable": 1
        },
        {
          "name": "Budget",
          "index": 2,
          "datatype": "decimal",
          "nullable": 1
        },
        {
          "name": "StartDate",
          "index": 3,
          "datatype": "datetime",
          "nullable": 1
        },
        {
          "name": "Administrator",
          "index": 3,
          "datatype": "long",
          "nullable": 0
        }
      ],
      "primary-rows": [
        {
          "row-status": 3,
          "columns": {
            "DepartmentID": [ 10 ],
            "Name": [ "test depart" ],
            "Budget": [ 1 ],
            "StartDate": [ "2018-12-12 00:00:00", 1, null ],
            "Administrator": [ null ]
          }
        }
      ]
    }
  },
  "courseinfo": {
    "identity": "70c86603-983b-4bd9-adbc-259436e43cbd",
    "version": 1,
    "platform": "Platform A",
    "mapping-method": 0,
    "dataobject": {
      "name": "d_course",
      "meta-columns": [
        {
          "name": "CourseID",
          "index": 0,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "Title",
          "index": 1,
          "datatype": "string",
          "nullable": 1
        },
        {
          "name": "Credits",
          "index": 2,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "DepartmentID",
          "index": 3,
          "datatype": "long",
          "nullable": 1
        }
      ],
      "primary-rows": [
        {
          "row-status": 3,
          "columns": {
            "CourseID": [ 8001 ],
            "Title": [ "Test Course" ],
            "Credits": [ 4 ],
            "DepartmentID": [ 10 ]
          }
        }
      ]
    }
  },
  "coursestudent": {
    "identity": "70c86603-983b-4bd9-adbc-259436e43cbd",
    "version": 1,
    "platform": "Platform A",
    "mapping-method": 0,
    "dataobject": {
      "name": "d_studentgrade",
      "meta-columns": [
        {
          "name": "EnrollmentID",
          "index": 0,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "CourseID",
          "index": 1,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "StudentID",
          "index": 2,
          "datatype": "long",
          "nullable": 1
        },
        {
          "name": "Grade",
          "index": 3,
          "datatype": "decimal",
          "nullable": 0
        }
      ],
      "primary-rows": [
        {
          "row-status": 3,
          "columns": {
            "EnrollmentID": [ null ],
            "CourseID": [ null ],
            "StudentID": [ 1 ],
            "Grade": [ 90 ]
          }
        },
        {
          "row-status": 3,
          "columns": {
            "EnrollmentID": [ null ],
            "CourseID": [ null ],
            "StudentID": [ 2 ],
            "Grade": [ 100 ]
          }
        }
      ]
    }
  }
}