CourseMembership

Overview

This entity contains information about courses - users mapping.

Which course memberships are included?

Only users that are assigned to any course are present in this entity.

Usage in itslearning

  • This entity is not used in itslearning, this is a technical table. This table joins courses and users (user is a course participant)

  • Users can see the courses they are participants in from the Courses menu

    images/download/attachments/41661325/courses_of_user.PNG
  • Participants of a course can be seen from the Participants menu in a course

    images/download/attachments/41661325/participants_of_a_course.PNG

Notes

  • The entity shows the latest version of course memberships for each user only.

Relationships

CourseMembership is linked to:

Diagram

Entity Details

Name

Data type

Nullable

Description

CourseId

Edm.Int32

false

Id of a course

UserId

Edm.Int32

false

Id of a user (course participant)

CourseProfileId

Edm.Int32

false

Id of a user course profile

CourseOrganizationId

Edm.Int32

false

Organisation id in which the course exists

FirstOnline

Edm.DateTime

false

Date of the first login of a user to the course

LastOnline

Edm.DateTime

false

Date of the last login of a user to the course

ValidFrom

Edm.DateTime

false

Technical information

ValidTo

Edm.DateTime

false

Technical information

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

SQL code:

CREATE TABLE [Dwh].[CourseMemberships]([CourseId] [INT] NOT NULL ,[UserId] [INT] NOT NULL ,[CourseProfileId] [INT] NOT NULL ,[CourseOrganizationId] [INT] NOT NULL ,[FirstOnline] [DATETIME] NOT NULL ,[LastOnline] [DATETIME] NOT NULL ,[ValidFrom] [DATETIME] NOT NULL ,[ValidTo] [DATETIME] NOT NULL, [T_ModifiedDate] [DATETIME] NOT NULL ) ALTER TABLE Dwh.CourseMemberships ADD CONSTRAINT PK_CourseMemberships PRIMARY KEY (CourseId, UserId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/CourseMemberships?$top=10

Response body - XML

XML response
<?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>2016-12-21T09:53:17Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=1,UserId=2)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=1,UserId=2)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=1,UserId=2)" />
<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/CourseMemberships(CourseId=1,UserI
d=2)/Course" />
<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/CourseMemberships(CourseId=1,UserId=2)
/User" />
<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/CourseMemberships(Co
urseId=1,UserId=2)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=1,UserId=2)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">1</d:CourseId>
<d:UserId m:type="Edm.Int32">2</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">4</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">1</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2010-12-16T20:49:07</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2010-12-16T20:49:07</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=122)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=122)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=122)" />
<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/CourseMemberships(CourseId=2,UserI
d=122)/Course" />
<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/CourseMemberships(CourseId=2,UserId=12
2)/User" />
<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/CourseMemberships(Co
urseId=2,UserId=122)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=2,UserId=122)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">2</d:CourseId>
<d:UserId m:type="Edm.Int32">122</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">4</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">9</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2010-12-21T12:42:37</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2010-12-21T12:42:37</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=129)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=129)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=2,UserId=129)" />
<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/CourseMemberships(CourseId=2,UserI
d=129)/Course" />
<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/CourseMemberships(CourseId=2,UserId=12
9)/User" />
<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/CourseMemberships(Co
urseId=2,UserId=129)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=2,UserId=129)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">2</d:CourseId>
<d:UserId m:type="Edm.Int32">129</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">9</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2010-12-21T14:48:32</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2010-12-21T14:48:32</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=19)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=19)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=19)" />
<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/CourseMemberships(CourseId=6,UserI
d=19)/Course" />
<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/CourseMemberships(CourseId=6,UserId=19
)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=19)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=19)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">19</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">4</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2016-01-22T13:16:27</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2016-05-06T08:16:29</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=123)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=123)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=123)" />
<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/CourseMemberships(CourseId=6,UserI
d=123)/Course" />
<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/CourseMemberships(CourseId=6,UserId=12
3)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=123)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=123)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">123</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2016-01-22T09:06:08</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2016-05-06T08:15:34</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=130)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=130)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=130)" />
<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/CourseMemberships(CourseId=6,UserI
d=130)/Course" />
<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/CourseMemberships(CourseId=6,UserId=13
0)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=130)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=130)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">130</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2012-06-28T17:56:14</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2012-06-28T17:56:14</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=158)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=158)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=158)" />
<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/CourseMemberships(CourseId=6,UserI
d=158)/Course" />
<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/CourseMemberships(CourseId=6,UserId=15
8)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=158)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=158)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">158</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">2015-04-13T09:31:50</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">2015-04-13T09:31:50</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=176)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=176)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=176)" />
<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/CourseMemberships(CourseId=6,UserI
d=176)/Course" />
<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/CourseMemberships(CourseId=6,UserId=17
6)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=176)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=176)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">176</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=334)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=334)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=334)" />
<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/CourseMemberships(CourseId=6,UserI
d=334)/Course" />
<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/CourseMemberships(CourseId=6,UserId=33
4)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=334)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=334)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">334</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=1463)</id>
<category term="Itslearning.Reporting.Data.Models.CourseMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=1463)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseMemberships(CourseId=6,UserId=1463)" />
<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/CourseMemberships(CourseId=6,UserI
d=1463)/Course" />
<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/CourseMemberships(CourseId=6,UserId=14
63)/User" />
<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/CourseMemberships(Co
urseId=6,UserId=1463)/CourseProfile" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseOrganization" type="application/atom+xml;type=entry" title="CourseOrganization" href="https://reporting.itslearning.com/odata/engine7/CourseMemb
erships(CourseId=6,UserId=1463)/CourseOrganization" />
<title />
<updated>2016-12-21T09:53:17Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">6</d:CourseId>
<d:UserId m:type="Edm.Int32">1463</d:UserId>
<d:CourseProfileId m:type="Edm.Int32">5</d:CourseProfileId>
<d:CourseOrganizationId m:type="Edm.Int32">12</d:CourseOrganizationId>
<d:FirstOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:FirstOnline>
<d:LastOnline m:type="Edm.DateTime">1900-01-01T00:00:00</d:LastOnline>
<d:ValidFrom m:type="Edm.DateTime">2015-07-24T14:25:01</d:ValidFrom>
<d:ValidTo m:type="Edm.DateTime">9999-12-31T00:00:00</d:ValidTo>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#CourseMemberships","value":[
{
"CourseId":1,"UserId":2,"CourseProfileId":4,"CourseOrganizationId":1,"FirstOnline":"2010-12-16T20:49:07","LastOnline":"2010-12-16T20:49:07","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":2,"UserId":122,"CourseProfileId":4,"CourseOrganizationId":9,"FirstOnline":"2010-12-21T12:42:37","LastOnline":"2010-12-21T12:42:37","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":2,"UserId":129,"CourseProfileId":5,"CourseOrganizationId":9,"FirstOnline":"2010-12-21T14:48:32","LastOnline":"2010-12-21T14:48:32","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":19,"CourseProfileId":4,"CourseOrganizationId":12,"FirstOnline":"2016-01-22T13:16:27","LastOnline":"2016-05-06T08:16:29","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":123,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"2016-01-22T09:06:08","LastOnline":"2016-05-06T08:15:34","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":130,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"2012-06-28T17:56:14","LastOnline":"2012-06-28T17:56:14","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":158,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"2015-04-13T09:31:50","LastOnline":"2015-04-13T09:31:50","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":176,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"1900-01-01T00:00:00","LastOnline":"1900-01-01T00:00:00","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":334,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"1900-01-01T00:00:00","LastOnline":"1900-01-01T00:00:00","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
},{
"CourseId":6,"UserId":1463,"CourseProfileId":5,"CourseOrganizationId":12,"FirstOnline":"1900-01-01T00:00:00","LastOnline":"1900-01-01T00:00:00","ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
}
]
}