Learning Resource Assignment

This document shows the operations that you need to perform for viewing and assinging Learning resources to people in your company on SkillsDB.

Get/List People Learnings (IDP)

On the legacy API access the used to an API which list all learnings (IDPs) which are assigned to peoples. The below API:
- GET - {{baseURI}}/IDP/{{companyID}}?part={{part}}

On the new GraphQL API use the below query to list/get people learnings (IDPs)


query GetAllPeopleLearningSummary {
    getAllPeopleLearningSummary(
        input: { limit: 20, offset: 0, where: { emailAddress: { _like: "" } } }
    ) {
        count
        data {
            PersonId
            FirstName
            LastName
            EmployeeId
            MgrPersonId
            MgrFirstName
            MgrLastName
            MgrEmailAddress
            LearningId
            ReferenceId # LearningPlanActivityIDOutsideSystem on the legacy API
            LearningTitle
            Status
            PercentComplete # LearningPlanPercentComplete on the legacy API
            DateStarted # LearningPlanStartDate on the legacy API
            DateCompleted # LearningPlanEndDate on the legacy API
        }
    }
}

Get/List Learnings(IDPs) for Person with Email Address

On the legacy API there used to be an API to get learnings/IDPs for specific person by Email Address.
On the new GraphQL API we'll use the above getAllPeopleLearningSummary query by using email filter as below, for more on filtering please check out Filtering documentation.
```
where: { emailAddress: { _eq: "email@domain.com" }
```

Create and Assign Learning to a Person

On the legacy API there used to be an API to create IDP record and assign to a person at the same time. Which is:

POST- {{baseURI}}/CreateIDPRecord/{{companyID}} with the below payload:


{
    // Learning plan (course) outside Id used in other system (if there is), So it can be referenced. OPTIONAL, But good to have field.
    "LearningPlanActivityIDOutsideSystem":"SDB62540021",
    // Person email address to assign or update the learning plan current status. REQUIRED
    "EmailAddress": "tadesse@skillsdb.com",
    // Short Title for the learning plan, if this learning plan doesn't exists in the system, it will be created. REQUIRED
    "LearningPlanTitle": "NEST AND GRAPHQL INTEGRATION",
    // Long description of the learning plan, OPTIONAL
    "LearningPlanDescription":"Programming",
    // The duration that will take to complete this course. OPTIONAL
    "LearningPlanDurationHours":10,
    // A url in which the learning plan (course) could be redirected. OPTIONAL
    "LearningPlanURL":"https://www.sampleurl.com/pathtothecourse",
    // A unique Id of learning plan types which is generated by skillsdb system, you can get those ids from SkillDb web app. If you don't want to use Id you can use learning plan type Name. OPTIONAL
    "LearningPlanTypeId": 15,
    // This is a learning plan type name in which the system will take the Id based on this name. New learning plan type will be created if there is no learning plan type with the given name. Please make sure you are using the exact names of existing learning plan types (to avoid unneccesary duplicates). OPTIONAL
    "LearningPlanTypeName":"Sample Learning Plan Type",
    // Percentage representation of the course(learning plan) completion. OPTIONAL, but Reuired if you want to score with this API.
    "LearningPlanPercentComplete": 100,
    // The time when this course(learning Plan) started by an employee.The Date Format shuld be (dd.MM.yyyy). OPTIONAL
    "LearningPlanStartDate": "15.06.2023",
    // The time when this course(learning plan) gets completed by an employee. The Date Format shuld be (dd.MM.yyyy). OPTIONAL
    "LearningPlanEndDate": "30.12.2023"
}

On the new GraphQL API we'll use the below mutation to create and assign learning/IDP to a person using email address:


mutation AddAndAssignlearningComposite {
    addAndAssignlearningComposite(
        input: {
            EmailAddress: "tadesse@skillsdb.com"
            Title: "NeW Updated Learning" # title of the learning plan
            Description: null # any description
            DurationInHours: 12 # leaning plan duration (master data level) when this learning gets assigned to other person, this duration will be used
            OverrideDurationHours: 23 # this will override the above learning plan duration for this person
            PercentageCompleted: 50 # percentage completed
            StartDate: "2025-01-15" # start date of the learning
            EndDate: "2025-06-20" # percentage should be 100% to log this
            ReferenceId: "LNOPS-11222" # reference Id to other system (for your reference) LearningPlanActivityIDOutsideSystem equivalent from legacy system 
            LearningPlanURL: "htts://learn.domain.com/lnops-11222" # url of the learning plan
        }
    ) {
        success
        message
        rowsAffected
    }
}

Update Person learning (IDP)

On the legacy API there used to be an update API for persons learning plan (IDP). Which is:

POST - {{baseURI}}/skills/{{companyID}} with the below json


{
    "LearningPlanActivityIDOutsideSystem": "SDB62540021",
    "EmailAddress": "emial@domain.com",
    "LearningPlanPercentComplete": "85",
    "LearningPlanStartDate": "15.06.2023",
    "LearningPlanEndDate": "15.06.2023"
}

On the new GraphQL API we'll use the above addAndAssignlearningComposite mutation with the below payload:


mutation AddAndAssignlearningComposite {
    addAndAssignlearningComposite(
        input: {
            EmailAddress: "email@domain.com"
            ReferenceId: "LNOPS-11222" # reference Id to other system (for your reference) LearningPlanActivityIDOutsideSystem equivalent from legacy system 
            PercentageCompleted: 100 # percentage completed
            StartDate: "2025-01-15" # start date of the learning
            EndDate: "2025-06-20" # percentage should be 100% to log this
          
        }
    ) {
        success
        message
        rowsAffected
    }
}