Skip to content

Queries for M&E Data Export

Moses Okemwa edited this page Nov 24, 2020 · 3 revisions

Create a user in the system /api/v1/users

{
  "username": "string",
  "password": "string",
}

Use the login credentials for the created user to get a token response for use in subsequent queries /api/v1/auth/

POST user credentials in the body to get a token response

{
    "token": "json_web_token"
}

Get total learners and learner with 2 completed chapters /api/v1/dashboard/learners

{
  "total": "4752",
  "quarterly": [
    {
      "count": "7",
      "quarter": "2017.Q4"
    },
    {
      "count": "98",
      "quarter": "2020.Q3"
    },
    {
      "count": "68",
      "quarter": "2020.Q4"
    }
  ]
}

Get chapters with more than 2 completion status /api/v1/dashboard/completed/

{
  "total": "339",
  "completed": [
    {
      "quarter": "2020.Q2",
      "count": "1"
    },
    {
      "quarter": "2020.Q4",
      "count": "6"
    },
    {
      "quarter": "2020.Q3",
      "count": "266"
    },
    {
      "quarter": "2017.Q4",
      "count": "66"
    }
  ]
}

Number of content creators and content creators with more than 10 chapters created /api/v1/dashboard/creators/

{
  "total": 30,
  "with_10_chapters": 45
}
Clone this wiki locally