Course Enrollment Report
...
Course Timespent Report
Background
Purpose of this report is to show average time spent on the courses at district level.
Proposed Solution:
Report title: Time Spent Report by District
...
Code Block | ||
---|---|---|
| ||
{"id":"api.report","ver":"1.0","ts":"2019-04-26 13:42:33:912+0530","params":{"resmsgid":"0b835780-67fb-11e9-a849-43872b42b8e5","msgid":null,"status":"success","err":null,"errmsg":null},"responseCode":"OK","result":{"data":{"District":["East Godavari","West Godavari","Krishna"],"Avergae Time spent":["0","500","1000","1500"]}}} |
ScreenShot:
Sunbird platform api details:
Api details to generate reports data:
1.
Code Block | ||||
---|---|---|---|---|
| ||||
Method : POST
URI: {{host}}/course/v1/batch/list
Description : This api will provide all associated batch details for provided courseId. This is a search api, you can call this with different request param combination.
Request body :
{
"request": {
"filters": {
"courseId": [
"do_21266334005810790415935",
"do_2125734183857930241202"
]
},
"fields": [ // list of fields which you need
"identifier",
"courseAdditionalInfo",
"courseId",
"id"
]
}
}
Sample Data for one course batch:
{
"identifier": "01266334273421312013",
"createdFor": [
"0125683555607347207"
],
"courseAdditionalInfo": {
"courseName": "My creation",
"leafNodesCount": "7",
"description": "Enter description for Course",
"courseLogoUrl": "https://ntpstagingall.blob.core.windows.net/ntp-content-staging/content/do_21266334005810790415935/artifact/download_1540471112504.thumb.png",
"tocUrl": "https://ntpstagingall.blob.core.windows.net/ntp-content-staging/content/do_21266334005810790415935/artifact/do_21266334005810790415935toc.json",
"status": "Live"
},
"endDate": null,
"countIncrementDate": "2018-12-26 09:54:00:047+0000",
"description": "",
"countDecrementDate": null,
"updatedDate": null,
"completedCount": 0,
"countIncrementStatus": true,
"createdDate": "2018-12-26 09:53:59:919+0000",
"reportUpdatedOn": "2019-04-26T11:38:54Z",
"createdBy": "d32e170d-010b-4bc5-ae55-3ac5e547e35b",
"courseCreator": "d32e170d-010b-4bc5-ae55-3ac5e547e35b",
"hashTagId": "01266334273421312013",
"participantCount": 1,
"mentors": [
"fe1785ab-7c28-4322-bd7c-c7e926d39147"
],
"countDecrementStatus": false,
"name": "Batcxh",
"id": "01266334273421312013",
"enrollmentType": "invite-only",
"courseId": "do_21266334005810790415935",
"startDate": "2018-12-26",
"status": 1
}
|
2. Once you have batch Id you can make call of download reports api, which will provide you enrolled user details, progress etc.
Code Block | ||||
---|---|---|---|---|
| ||||
Method: GET
URI : {host}/dashboard/v1/progress/course/{batchId}/export?period=fromBegining&format=csv
|