eTrainu - Status Report

Scheduled service to retrieve the status of Contact Training Courses.

SAMPLE REQUEST

curl --location 'https://api.etrainu.com/lms/v2/reports/status' \
--header 'Content-Type: application/json' \
--header 'token: 3055F647-04C6-422A-A537-49DE4CD26825' \
--header 'Accept: application/json' \
--header 'x-api-key: The API key provided to you' \
--data '{
    "offset": 0,
    "trainingID": "1EF1CD2D-FC7C-4C80-9E6B-22A989F884D6",
    "participantID": "The ID of the participant to be reported on. (Optional)",
    "completionFromDate": "2019-11-01 00:00:00.00",
    "completionToDate": "2019-12-01 00:00:00.00",
    "status": "Return only training that has the specified status.  Valid values are: COMPLETE, DEACTIVATED, NOT STARTED, IN PROGRESS.",
    "allocationFromDate": "Course allocation from date. (Optional)",
    "allocationToDate": "Course allocation to date. (Optional)"
}'

REQUEST BUILDER

Scheduled service which runs every night and a Quick Action on a Training Course record.

ETRAINU	REQUEST ATTRIBUTE	NOTES

ETRAINU	REQUEST ATTRIBUTE	NOTES
`trainingID`		Iterate through all `Training Courses` where `Status = Active`.
`participantID`		Iterate through all Participants where `Start Date < TODAY AND (Employment End Date > TODAY OR Employment End Date = NULL)`
`completionFromDate`		Not sure if we need this.
`completionToDate`		Not sure if we need this.
`status`		Not sure if we need this.
`allocationFromDate`		Not sure if we need this.
`allocationToDate`		Not sure if we need this.

SAMPLE RESPONSE

[
  {
    "participantID": "12468FD3-D007-4ED4-BF72-C4B26BE52299",
    "Firstname": "Adam",
    "Surname": "Bishop",
    "DateOfBirth": "2000-01-01",
    "CourseName": "Safeguarding for Sport",
    "Courseid": "6B3F81A9-0E08-4472-AE43-1554D493735A",
    "trainingInstanceID": "D0171D15-A4C5-7C67-A380-266AAD8E851F",
    "CourseAssignedDate": "2019-11-13 08:54:40.367",
    "Status": "COMPLETE",
    "CompletionDate": "2019-11-18 11:19:36.367",
    "Progress": "100% (1 of 1)",
    "Suborganisation": "Demo Participants",
    "Department": "Demo"
  },
  {
    "participantID": "2BCC8FDE-4B1D-4585-9222-08A72637CA7C",
    "Firstname": "David",
    "Surname": "Bell",
    "DateOfBirth": "2000-01-01",
    "CourseName": "Safeguarding for Sport",
    "Courseid": "6B3F81A9-0E08-4472-AE43-1554D493735A",
    "trainingInstanceID": "D0171D15-A4C5-7C67-A380-266AAD8E851F",
    "CourseAssignedDate": "2019-11-07 13:43:21.197",
    "Status": "COMPLETE",
    "CompletionDate": "2019-11-14 13:31:09.477",
    "Progress": "100% (1 of 1)",
    "Suborganisation": "Demo Participants",
    "Department": "Demo"
  },
  {
    "participantID": "74689A11-ADDF-4D5F-BEDE-FB6BF6D3612E",
    "Firstname": "Greg",
    "Surname": "Maher",
    "DateOfBirth": "2000-01-01",
    "CourseName": "Safeguarding for Sport",
    "Courseid": "6B3F81A9-0E08-4472-AE43-1554D493735A",
    "trainingInstanceID": "D0171D15-A4C5-7C67-A380-266AAD8E851F",
    "CourseAssignedDate": "2019-10-29 17:05:32.28",
    "Status": "COMPLETE",
    "CompletionDate": "2019-11-11 12:25:51.85",
    "Progress": "100% (1 of 1)",
    "Suborganisation": "Demo Participants",
    "Department": "Demo"
  }
]

MAPPING

Map to Contact_Training_Course__c

ETRAINU	SALESFORCE	NOTES

ETRAINU	SALESFORCE	NOTES
`participantID`	Contact__r.Etrainu_ID__c	Not sure if we need this for mapping.
`Firstname`		Not needed.
`Surname`		Not needed.
`DateOfBirth`		Not needed.
`CourseName`		Not needed.
`Courseid`	Training_Course__r.External_ID__c	Not sure if we need this for mapping.
`trainingInstanceID`	External_ID__c
`CourseAssignedDate`	Course_Assigned_Date__c
`Status`	Status__c
`CompletionDate`	Completion_Date__c
`Progress`	Progress__c
`Suborganisation`	Suborganisation__c
`Department`	Department__c

My Supports Knowledge

eTrainu - Status Report

Analytics

SAMPLE REQUEST

REQUEST BUILDER

SAMPLE RESPONSE

MAPPING

Related content