Get student progress for a Course - Creatora

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id
    name
    aggregatedStats {
      studentsOwningCourse {
        id
        fullName
        email
        coursesOwned {
          id
          progress {
            percentage
            isCompleted
          }
        }
      }
    }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Introduction to Drawing",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "progress": {
                  "percentage": 0.75,
                  "isCompleted": false
                }
              }
            ]
          }
        ]
      }
    }
  }
}

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id
    name
    aggregatedStats {
      studentsOwningCourse {
        id
        fullName
        email
        coursesOwned {
          id
          progress {
            percentage
            isCompleted
          }
        }
      }
    }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Introduction to Drawing",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "progress": {
                  "percentage": 0.75,
                  "isCompleted": false
                }
              }
            ]
          }
        ]
      }
    }
  }
}

Replace the example Course ID with yours. This request returns every Student who currently has access to the Course, excluding Administrators.

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id
    name
    aggregatedStats {
      studentsOwningCourse {
        id
        fullName
        email
        coursesOwned {
          id
          progress {
            percentage
            isCompleted
          }
        }
      }
    }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Introduction to Drawing",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "progress": {
                  "percentage": 0.75,
                  "isCompleted": false
                }
              }
            ]
          }
        ]
      }
    }
  }
}

Use the result

Each Student’s coursesOwned can include other Courses. Select the entry matching the requested Course ID. percentage is a value from 0 to 1: 0.75 means 75%. Use isCompleted for the completion status. For example, after receiving a response without errors and a non-null courseById:

const course = response.data.courseById;
const rows = course.aggregatedStats.studentsOwningCourse.map(student => {
  const progress = student.coursesOwned
    .find(item => item.id === course.id)?.progress;
  return {
    name: student.fullName,
    email: student.email,
    completionPercent: progress ? Math.round(progress.percentage * 100) : null,
    isCompleted: progress?.isCompleted ?? null
  };
});

The roster is current access, including direct grants and Offer acquisitions. Students whose access has been removed are excluded. There is no list limit. Course Reference