UserCourseSession
Overview
This is a fact entity which contains basic information about user sessions in courses. It describes time periods when user was actively viewing courses in the itslearning.
Which user course sessions are included?
All the user's course session are included.
Notes
- The entity shows the information using time stamps
- This entity is not used in the itslearning application. This is a technical table.
RelationShips
UserCourseSession is linked to:
Diagram

Entity Details
Name | Data type | Nullable | Description |
|---|---|---|---|
MonthlyDateId | Edm.Int32 | false | Technical id of Monthly Date |
DateId | Edm.Int32 | false | Technical id of a date |
UserId | Edm.Int32 | false | Id of a user that visited the course |
CourseId | Edm.Int32 | false | Id of a course that has been visited |
CourseProfileId | Edm.Int32 | false | User site profile id |
CourseOrganizationId | Edm.DateTime | false | Course organization id |
ConsumerTypeId | Edm.Int32 | false | Consumer type id |
CourseSessionStartDate | Edm.DateTime | false | DateTime when user started visiting the course |
CourseSessionEndDate | Edm.DateTime | false | DateTime when user stopped actively viewing the course |
CourseSessionDurationMinutes | Edm.Int64 | false | User session duration in the course (in minutes) |
Request body
https://reporting.itslearning.com/odata/engine7/UserCourseSessions?$top=10Response body - XML
<?xml version="1.0" encoding="utf-8"?><feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml"> <id>http://schemas.datacontract.org/2004/07/</id> <title /> <updated>2018-04-23T13:18:56Z</updated> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions" /> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T11:21:21')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180401</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180418</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">7</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">4</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-04-18T11:21:21</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-04-18T11:24:21</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">3</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=7,CourseSessionStartDate=datetime'2018-04-18T14:37:46')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180401</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180418</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">7</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">4</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-04-18T14:37:46</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-04-18T14:37:46</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:22:37')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180327</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">25</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">5</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-27T11:22:37</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-27T11:22:37</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=25,CourseSessionStartDate=datetime'2018-03-27T11:32:06')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180327</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">25</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">5</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-27T11:32:06</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-27T11:33:12</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">1</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=81,CourseSessionStartDate=datetime'2018-02-26T09:19:54')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180201</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180226</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">81</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-02-26T09:19:54</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-02-26T09:19:54</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-02-26T09:19:50')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180201</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180226</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">87</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-02-26T09:19:50</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-02-26T09:19:50</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:31:30')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180307</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">87</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:31:30</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:33:30</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">2</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:37:30')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180307</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">87</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:37:30</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:37:30</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">0</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-07T16:40:30')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180307</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">87</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-07T16:40:30</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-07T16:43:30</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">3</d:CourseSessionDurationMinutes> </m:properties> </content> </entry> <entry> <id>https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')</id> <category term="Itslearning.Reporting.Data.Models.UserCourseSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')" /> <link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/Date" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/User" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/Course" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseProfile" type="application/atom+xml;type=entry" title="CourseProfile" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/CourseProfile" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Organization" type="application/atom+xml;type=entry" title="Organization" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/Organization" /> <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConsumerType" type="application/atom+xml;type=entry" title="ConsumerType" href="https://reporting.itslearning.com/odata/engine7/UserCourseSessions(UserId=1,CourseId=87,CourseSessionStartDate=datetime'2018-03-08T08:50:03')/ConsumerType" /> <title /> <updated>2018-04-23T13:18:56Z</updated> <author> <name /> </author> <content type="application/xml"> <m:properties> <d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId> <d:DateId m:type="Edm.Int32">20180308</d:DateId> <d:UserId m:type="Edm.Int32">1</d:UserId> <d:CourseId m:type="Edm.Int32">87</d:CourseId> <d:CourseProfileId m:type="Edm.Int32">3</d:CourseProfileId> <d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId> <d:ConsumerTypeId m:type="Edm.Int32">0</d:ConsumerTypeId> <d:CourseSessionStartDate m:type="Edm.DateTime">2018-03-08T08:50:03</d:CourseSessionStartDate> <d:CourseSessionEndDate m:type="Edm.DateTime">2018-03-08T08:51:03</d:CourseSessionEndDate> <d:CourseSessionDurationMinutes m:type="Edm.Int64">1</d:CourseSessionDurationMinutes> </m:properties> </content> </entry></feed>Response body - JSON (default output format)
{ "odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#UserCourseSessions","value":[ { "MonthlyDateId":20180401,"DateId":20180418,"UserId":1,"CourseId":7,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":4,"CourseSessionStartDate":"2018-04-18T11:21:21","CourseSessionEndDate":"2018-04-18T11:24:21","CourseSessionDurationMinutes":"3" },{ "MonthlyDateId":20180401,"DateId":20180418,"UserId":1,"CourseId":7,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":4,"CourseSessionStartDate":"2018-04-18T14:37:46","CourseSessionEndDate":"2018-04-18T14:37:46","CourseSessionDurationMinutes":"0" },{ "MonthlyDateId":20180301,"DateId":20180327,"UserId":1,"CourseId":25,"CourseProfileId":3,"CourseOrganizationId":5,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-27T11:22:37","CourseSessionEndDate":"2018-03-27T11:22:37","CourseSessionDurationMinutes":"0" },{ "MonthlyDateId":20180301,"DateId":20180327,"UserId":1,"CourseId":25,"CourseProfileId":3,"CourseOrganizationId":5,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-27T11:32:06","CourseSessionEndDate":"2018-03-27T11:33:12","CourseSessionDurationMinutes":"1" },{ "MonthlyDateId":20180201,"DateId":20180226,"UserId":1,"CourseId":81,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-02-26T09:19:54","CourseSessionEndDate":"2018-02-26T09:19:54","CourseSessionDurationMinutes":"0" },{ "MonthlyDateId":20180201,"DateId":20180226,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-02-26T09:19:50","CourseSessionEndDate":"2018-02-26T09:19:50","CourseSessionDurationMinutes":"0" },{ "MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:31:30","CourseSessionEndDate":"2018-03-07T16:33:30","CourseSessionDurationMinutes":"2" },{ "MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:37:30","CourseSessionEndDate":"2018-03-07T16:37:30","CourseSessionDurationMinutes":"0" },{ "MonthlyDateId":20180301,"DateId":20180307,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-07T16:40:30","CourseSessionEndDate":"2018-03-07T16:43:30","CourseSessionDurationMinutes":"3" },{ "MonthlyDateId":20180301,"DateId":20180308,"UserId":1,"CourseId":87,"CourseProfileId":3,"CourseOrganizationId":1,"ConsumerTypeId":0,"CourseSessionStartDate":"2018-03-08T08:50:03","CourseSessionEndDate":"2018-03-08T08:51:03","CourseSessionDurationMinutes":"1" } ]}