Retrieve all comments

[MrMevs]

Hello Canvas Devs,

I'm looking for any query/existing features that will allow me to retrieve all comments from a given assignment. 

For example, if I left comments on every student's submission of 3.1 homework, is there a way to download them all?

[werner_huysman1]

Hi,

you could try this graphql query on yourcanvasinstance/graphiql:

query MyQuery {
  assignment(id: "68977") {
    submissionsConnection {
      nodes {
        commentsConnection {
          nodes {
            comment
          }
        }
      }
    }
  }
}

If you paste the resulting json here: https://konklone.io/json/ , you get a csv with the comments.

[werner_huysman1]

If you also want the name of the students, you can use this query:

query MyQuery {
  assignment(id: "68977") {
    submissionsConnection {
      nodes {
        commentsConnection {
          nodes {
            comment
          }
        }
        user {
          email
        }
      }
    }
  }
}