/
eTrainu - Status Report

eTrainu - Status Report

etrainu - Public API v2

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

 

 

Related content

eTrainu - Status Report
eTrainu - Status Report
More like this
eTrainu - Retrieve Course List
eTrainu - Retrieve Course List
More like this
eTrainu - Create Participant
eTrainu - Create Participant
More like this
eTrainu - Assign Participant to Course
eTrainu - Assign Participant to Course
More like this