SAP Litmos Support

Getting Started
Knowledgebase
Community

Articles in this section

See more

Date Range API's

Avatar
Steve Cunha
  • Updated
Follow

Included here is a set of API's that will return a list of associated records within a given date range. The date range difference must be equivalent to or less than 7 days. 

Important Notes: The date range format will be 'YYYY-MM-DD HH:MM:SS' for the "since" and "to" parameters, and in response, all records that were created/updated between 'YYYY-MM-DD HH:MM:SS' to 'YYYY-MM-DD HH:MM:SS' will be returned. When using date 'YYYY-MM-DD' only, the "to" date must be in the future to return results for today. 

By default, all API responses will return 100 results. You can return up to 1,000 records by adding the 'limit' query parameter to your URI. Please visit our 'Overview Developer API' documentation and refer to the 'Search & Paging Parameters' section for pagination, and other query parameters you can use. 

Get User Details 

Returns a list of people including 'active' and 'inactive' people that have been created or updated within a given date range.

Request Uri

GET /org/users/details?source=MY_APP&since=[DATE]&to=[DATE]

Response

<Users>
 <User>
 <Id></Id>
 <UserName></UserName>
 <FirstName></FirstName>
 <LastName></LastName>
 <FullName></FullName>
 <Email></Email>
 <AccessLevel></AccessLevel>
 <DisableMessages></DisableMessages>
 <Active></Active>
 <Skype i:nil="true"/>
 <PhoneWork></PhoneWork>
 <PhoneMobile i:nil="true"/>
 <LastLogin/>
 <LoginKey></LoginKey>
 <IsCustomUsername></IsCustomUsername>
 <TimeZone></TimeZone>
 <SalesforceId i:nil="true"/>
 <OriginalId></OriginalId>
 <Street1></Street1>
 <Street2 i:nil="true"/>
 <City></City>
 <State></State>
 <PostalCode></PostalCode>
 <Country></Country>
 <CompanyName i:nil="true"/>
 <JobTitle></JobTitle>
 <CustomField1 i:nil="true"/>
 <CustomField2 i:nil="true"/>
 <CustomField3 i:nil="true"/>
 <Culture></Culture>
 <CustomField4 i:nil="true"/>
 <CustomField5 i:nil="true"/>
 <CustomField6 i:nil="true"/>
 <CustomField7 i:nil="true"/>
 <CustomField8 i:nil="true"/>
 <CustomField9 i:nil="true"/>
 <CustomField10 i:nil="true"/>
 <SalesforceContactId i:nil="true"/>
 <SalesforceAccountId i:nil="true"/>
 <CreatedDate></CreatedDate>
 <UpdatedDate></UpdatedDate>
 <CreatedBy></CreatedBy>
 <UpdatedBy></UpdatedBy>
 <Brand></Brand>
 <ManagerId></ManagerId>
 <ManagerName/>
 <EnableTextNotification></EnableTextNotification>
 <Website/>
 <Twitter/>
 <ExpirationDate/>
 </User>
 <User>
 ..........
 </User>
</Users>

Get Results

Returns a list of all user course results that have changed during the specified interval. You can GET 1000 results using the “limit” parameter.

Request Uri

GET /org/results/details?source=MY_APP&since=[DATE]&to=[DATE]

Response

<UserResults>
 <UserResult>
 <UserId></UserId>
 <Id></Id>
 <OriginalUserId></OriginalUserId>
 <OriginalCourseId></OriginalCourseId>
 <Active></Active>
 <CreatedDate></CreatedDate>
 <UpdatedDate></UpdatedDate>
 <StartedDate></StartedDate>
 <Completed>true/false</Completed>
 <PercentageComplete></PercentageComplete>
 <CompletedDate></CompletedDate>
 <UpToDate>true/false</UpToDate>
 <Overdue>true/false</Overdue>
 <CompliantTillDate i:nil="true"/>
 </UserResult>
 <UserResult>
 ..........
 </UserResult>
</UserResults>

Get Achievements

Returns a list of all users that have earned achievements within a given date range.

Request Uri

GET /org/achievements?source=MY_APP&since=[DATE]&to=[DATE]

Response

<Achievements>
 <Achievement>
 <UserId></UserId>
 <Id></Id>
 <OriginalUserId></OriginalUserId>
 <OriginalAchievementId></OriginalAchievementId>
 <Title></Title>
 <Description/>
 <AchievementDate></AchievementDate>
 <CourseId></CourseId>
 <OriginalCourseId></OriginalCourseId>
 <CompliantTillDate i:nil="true"/>
 <Score/>
 <Result></Result>
 <Type></Type>
 <CertificateId></CertificateId>
 <CreatedDate></CreatedDate>
 <UpdatedDate></UpdatedDate>
 <CreatedBy></CreatedBy>
 <UpdatedBy></UpdatedBy>
 </Achievement>
 <Achievement>
 ..........
 </Achievement>
</Achievements>

Get Courses

Returns all the courses in your organization that were created or updated within a given date range.

Request Uri

GET /org/courses?source=MY_APP&since=[DATE]&to=[DATE]

Response

<Courses>
 <Course>
 <Id></Id>
 <Code/>
 <Name></Name>
 <Active></Active>
 <ForSale></ForSale>
 <OriginalCourseId></OriginalCourseId>
 <Description></Description>
 <EcommerceShortDescription></EcommerceShortDescription>
 <EcommerceLongDescription></EcommerceLongDescription>
 <CourseCodeForBulkImport></CourseCodeForBulkImport>
 <Price></Price>
 <AccessTillDate i:nil="true"/>
 <AccessTillDays i:nil="true"/>
 <CourseTeamLibrary>true/false</CourseTeamLibrary>
 <CreatedDate></CreatedDate>
 <UpdatedDate></UpdatedDate>
 <CreatedBy></CreatedBy>
 <UpdatedBy></UpdatedBy>
 </Course>
 <Course>
 ..........
 </Course>
</Courses>

Get Learning Paths

Returns all learning paths that were created/updated within a given date range.

Request Uri

GET /org/learningpaths?source=MY_APP&since=[DATE]&to=[DATE]

Response

<LearningPaths>
 <LearningPath>
 <Id></Id>
 <Name></Name>
 <Description></Description>
 <Active></Active>
 <OriginalId></OriginalId>
 <ForSale>true/false</ForSale>
 <Price></Price>
 <EcommerceShortDescription/>
 <EcommerceLongDescription/>
 <AccessTillDate i:nil="true"/>
 <AccessTillDays i:nil="true"/>
 <CreatedDate></CreatedDate>
 <UpdatedDate></UpdatedDate>
 <CreatedBy></CreatedBy>
 </LearningPath>
 <LearningPath>
 ..........
 </LearningPath>
</LearningPaths>

Get Courses and Modules

Returns all modules under each course within a given date range.

Request Uri

GET /org/courses/modules?source=MY_APP&since=[DATE]&to=[DATE]

Response

<CourseModules>
 <CourseModule>
  <CourseId></CourseId>
  <Id></Id>
  <OriginalCourseId></OriginalCourseId>
  <OriginalModuleId></OriginalModuleId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </CourseModule>
 <CourseModule>
 ..........
 </CourseModule>
</CourseModules>

Get Courses and Learning Paths

Returns all courses that are assigned to a specific learning path within a given date range.

Request Uri

GET /org/learningpaths/courses?source=MY_APP&since=[DATE]&to=[DATE]

Response

<LearningPathCourses>
 <LearningPathCourse>
  <LearningPathId></LearningPathId>
  <Id></Id>
  <OriginalLearningPathId></OriginalLearningPathId>
  <OriginalCourseId></OriginalCourseId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </LearningPathCourse>
 <LearningPathCourse>
  ..........
 </LearningPathCourse>
</LearningPathCourses>

Get User Course Assignments

Returns all courses assigned to users within a given date range.

Request Uri

GET /org/users/courses?source=MY_APP&since=[DATE]&to=[DATE]

Response

<UserCourses>
 <UserCourse>
  <UserId></UserId>
  <ID></ID>
  <OriginalUserId></OriginalUserId>
  <OriginalCourseId></OriginalCourseId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </UserCourse>
 <UserCourse>
 ..........
 </UserCourse>
</UserCourses>

Get User Learning Path Assignments

Returns all learning-paths assigned to users within a given date range.

Request Uri

GET /org/learningpaths/users?source=MY_APP&since=[DATE]&to=[DATE]

Response

<LearningPathUsers>
 <LearningPathUser>
  <LearningPathId></LearningPathId>
  <Id></Id>
  <OriginalLearningPathId></OriginalLearningPathId>
  <Active>true/false</Active>
  <OriginalUserId></OriginalUserId>
  <CreatedBy></CreatedBy>
  <CreatedDate></CreatedDate>
  <UpdatedBy></UpdatedBy>
  <UpdatedDate i:nil="true"/>
 </LearningPathUser>
 <LearningPathUser>
 ..........
 </LearningPathUser>
</LearningPathUsers>

Get Teams

Returns all teams that were created or modified within a given date range.

Request Uri

GET /org/teams?source=MY_APP&since=[DATE]&to=[DATE]

Response

<Teams>
 <Team>
  <Id></Id>
  <Name></Name>
  <OriginalTeamId></OriginalTeamId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
  </Team>
 <Team>
  ..........
 <Team>
</Teams>

Get Team Users Assigned

Returns all user team assignments that were created or modified within a given date range. 

Request Uri

GET /org/teams/users?source=MY_APP&since=[DATE]&to=[DATE]

Response

<TeamUsers>
 <TeamUser>
  <TeamId></TeamId>
  <Id></Id>
  <OriginalTeamId></OriginalTeamId>
  <OriginalUserId></OriginalUserId>
  <Active>true/false</Active>
  <IsTeamLeader>true/false</IsTeamLeader>
  <IsTeamAdmin>true/false</IsTeamAdmin>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </TeamUser>
 <TeamUser>
 ..........
 </TeamUser>
</TeamUsers>

Get Team and Courses Assigned

Returns all team course assignments that were created or modified within a given date range. 

Request Uri

GET /org/teams/courses?source=MY_APP&since=[DATE]&to=[DATE]

Response

<TeamCourses>
 <TeamCourse>
  <TeamId></TeamId>
  <Id></Id>
  <OriginalCourseId></OriginalCourseId>
  <OriginalTeamId></OriginalTeamId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </TeamCourse>
 <TeamCourse>
 ..........
 </TeamCourse>
</TeamCourses>

Get Team Learning Paths Assigned

Returns all team learning-paths that were created or modified within a given date range. 

Request Uri

GET /org/teams/learningpaths?source=MY_APP&since=[DATE]&to=[DATE]

Response

<TeamLearningPaths>
 <TeamLearningPath>
  <TeamId></TeamId>
  <Id></Id>
  <OriginalLearningPathId></OriginalLearningPathId>
  <OriginalTeamId></OriginalTeamId>
  <Active>true/false</Active>
  <CreatedDate></CreatedDate>
  <UpdatedDate>3</UpdatedDate>
  <CreatedBy></CreatedBy>
  <UpdatedBy></UpdatedBy>
 </TeamLearningPath>
 <TeamLearningPath>
 ..........
 </TeamLearningPath>
</TeamLearningPaths>

Get Modules 

Returns all the modules in an organization that was created/ updated within a given date range.

Request Uri

GET /org/modules?source=MY_APP&since=[DATE]&to=[DATE]

Response

<Modules xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
 <Module>
  <Id></Id>
  <OriginalId></OriginalId>
  <Name></Name>
  <Description></Description>
  <Active>true/false</Active>
  <Passmark></Passmark>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CreatedBy></CreatedBy>
  <ModuleType></ModuleType>
  </Module>
  .......................
</Modules>

Get Modules Results

Module results API will return the list of all user module results that have changed during the specified interval.

Request Uri

GET /org/modules/results?source=MY_APP&since=[DATE]&to=[DATE]

Response

<ModuleResults xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
 <ModuleResult>
  <Id></Id>
  <UserId></UserId>
  <OrginalId></OrginalId>
  <Name></Name>
  <UserName></UserName>
  <Passmark></Passmark>
  <Active>true/false</Active>
  <Score></Score>
  <Completed></Completed>
  <AttemptNumber></AttemptNumber>
  <CreatedBy></CreatedBy>
  <FinishedDate></FinishedDate>
  <CreatedDate></CreatedDate>
  <StartedDate></StartedDate>
  <TimeTaken></TimeTaken>
  <UpdatedDate></UpdatedDate>
 </ModuleResult>
 .......................
</ModuleResults>

Get Learning paths Results

Learning paths results API returns the list of all user learning paths results that have changed during the specified interval.

Request Uri

GET /org/learningpaths/results?source=MY_APP&since=[DATE]&to=[DATE]

Response

<LearningPathResults xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
 <LearningPathResult>
  <LearningPathId></LearningPathId>
  <Id></Id>
  <Name></Name>
  <Active>true/false</Active>
  <OriginalUserId></OriginalUserId>
  <OriginalLearningPathId></OriginalLearningPathId>
  <PercentageComplete></PercentageComplete>
  <Completed></Completed>
  <CreatedDate></CreatedDate>
  <UpdatedDate></UpdatedDate>
  <CompliantTillDate i:nil="true"/>
  <StartDate i:nil="true"/>
  <FinishDate i:nil="true"/>
  <CreatedBy></CreatedBy>
  </LearningPathResult>
  .......................
</LearningPathResults>

Related articles

Comments

0 comments

Article is closed for comments.