Versions Compared

Old Version 10

changes.mady.by.user Niharika Singh

Saved on

compared with

New Version Current

changes.mady.by.user Rahul Kumar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColor#fdfdfd
borderStyledashed
titlecertificate_templates

CREATE TABLE IF NOT EXISTS sunbird_courses.certificate_templates (
  courseid text,  // course id
  batchid text,   // batch id, empty if template is applicable for all the course batches
  certificatename name text,  // name of the certificate template
  template text,  // template metadata as a string, contains issuer, signatory and other information
  filters text,  // filters for the certificate
  addedby text,  // user id
  lastupdatedon timestamp, // timestamp of certificate update
  PRIMARY KEY (courseid, batchid, certificatenamename)
);



API Design :

  • Add Certificate Template API


    Code Block
    languagejs
    POST /course/batch/cert/v1/template

Request :      

{
    "params": {
        
    },
    "request": {
        "courseId": "do_12347787978775440",
        "batchId": "2364563546476343",       //optional field
        "certificateNamename": "100PercentCompletionCertificate",
        "filters": {
            "status": "2",
            "assessmentScore": {
                "<": "0.8"
            }
        },
        "template": {
            "issuer": {
                "name": "Gujarat Council of Educational Research and Training",
                "url": "https://gcert.gujarat.gov.in/gcert/",
                "publicKey": [
                    "7",
                    "8"
                ]
            },
            "signatoryList": [
                {
                    "name": "CEO Gujarat",
                    "id": "CEO",
                    "designation": "CEO",
                    "image": "https://cdn.pixabay.com/photo/2014/11/09/08/06/signature-523237__340.jpg"
                }
            ],
            "keys": {
                "id": "9"
            },
            "htmlTemplate": "https://drive.google.com/uc?authuser=1&id=1ryB71i0Oqn2c3aqf9N6Lwvet-MZKytoM&export=download",
            "notifyTemplate": {
                "subject": "Course completion certificate for Course 03092019 Course",
                "stateImgUrl": "https://sunbirddev.blob.core.windows.net/orgemailtemplate/img/File-0128212938260643843.png",
                "regardsperson": "Chairperson",
                "regards": "Minister of Gujarat",
                "emailTemplateType": "defaultCertTemp"
            }
        }
    }   
}



  • Delete  Certificate Template API

    Code Block
    DELETE  /course/batch/cert/v1/template

Request : 
                   {
                     "params": { },
                     "request":{
                             "courseId": "do_12347787978775440",
                             "batchIdname" :  "2364563546476343",          // optional field
                             "certificateName": "Merit-Certificate"
                           }
                   }


                 

  • Get Certificate List API

    Code Block
    POST  /course/batch/cert/v1/template/list
  
Request : 
                   {
                     "params": { },
                     "request":{
                             "courseId": "do_12347787978775440",
                             "batchId" :  "2364563546476343",          // optional field 
                           }
                   }