OrganizationMembership

Overview

This entity contains information about users in organisations.

Which organisation memberships are included?

The endpoint returns all users who are or have been members of an organisation, including soft deleted users. It shows the latest version of organisation membership for each mapped user.

To return only current members, use filter ValidTo='9999-12-31' (endless future).

Usage in itslearning

This entity is not used directly in the itslearning UI, but derived from information on organisations and users.

Relationships

OrganizationMembership is linked to;

Diagram

Entity Details

Name	Data type	Nullable	Description
OrganizationId	Edm.Int32	false	Id of an organization
UserId	Edm.Int32	false	Id of a user in the organization
SystemRole	Edm.String		Site role of the user
IsHomeOrganization	Edm.Boolean		Flag that determines if the organization is a home organization
ValidFrom	Edm.DateTime	false	Technical information, this is the date of the last change to this user's record
ValidTo	Edm.DateTime	false	Technical information, this is the most recently defined end date of the organisation membership of the user. It is '9999-12-31' for current members, and a date in the past for users who have been removed from the organisation.
T_ModifiedDate	Edm.DateTime	false	Date and time the entity was last modified in data warehouse

Request body

URI

https://reporting.itslearning.com/odata/engine7/OrganizationMemberships?$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-21T10:11:54Z</updated>
  <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships" />
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=1)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=1)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=1)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=1)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=1)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">1</d:UserId>
        <d:SystemRole>Administrator</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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/OrganizationMemberships(OrganizationId=1,UserId=2)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=2)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=2)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=2)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=2)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">2</d:UserId>
        <d:SystemRole>Teacher</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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/OrganizationMemberships(OrganizationId=1,UserId=3)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=3)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=3)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=3)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=3)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">3</d:UserId>
        <d:SystemRole>Teacher</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <d:ValidFrom m:type="Edm.DateTime">2015-11-21T10:22:04</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/OrganizationMemberships(OrganizationId=1,UserId=4)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=4)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=4)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=4)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=4)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">4</d:UserId>
        <d:SystemRole>Student</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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/OrganizationMemberships(OrganizationId=1,UserId=5)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=5)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=5)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=5)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=5)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">5</d:UserId>
        <d:SystemRole>Teacher</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <d:ValidFrom m:type="Edm.DateTime">2015-11-21T10:22:04</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/OrganizationMemberships(OrganizationId=1,UserId=6)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=6)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=6)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=6)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=6)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">6</d:UserId>
        <d:SystemRole>Student</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <d:ValidFrom m:type="Edm.DateTime">2015-11-21T10:22:04</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/OrganizationMemberships(OrganizationId=1,UserId=7)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=7)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=7)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=7)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=7)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">7</d:UserId>
        <d:SystemRole>Student</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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/OrganizationMemberships(OrganizationId=1,UserId=8)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=8)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=8)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=8)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=8)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">8</d:UserId>
        <d:SystemRole>Teacher</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <d:ValidFrom m:type="Edm.DateTime">2015-11-21T10:22:04</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/OrganizationMemberships(OrganizationId=1,UserId=9)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=9)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=9)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=9)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=9)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">9</d:UserId>
        <d:SystemRole>Guest</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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/OrganizationMemberships(OrganizationId=1,UserId=10)</id>
    <category term="Itslearning.Reporting.Data.Models.OrganizationMembership" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=10)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/OrganizationMemberships(OrganizationId=1,UserId=10)" />
    <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/OrganizationMembership
s(OrganizationId=1,UserId=10)/Organization" />
    <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/OrganizationMemberships(OrganizationId
=1,UserId=10)/User" />
    <title />
    <updated>2016-12-21T10:11:54Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
        <d:UserId m:type="Edm.Int32">10</d:UserId>
        <d:SystemRole>Administrator</d:SystemRole>
        <d:IsHomeOrganization m:type="Edm.Boolean">true</d:IsHomeOrganization>
        <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#OrganizationMemberships","value":[
    {
      "OrganizationId":1,"UserId":1,"SystemRole":"Administrator","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":2,"SystemRole":"Teacher","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":3,"SystemRole":"Teacher","IsHomeOrganization":true,"ValidFrom":"2015-11-21T10:22:04","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":4,"SystemRole":"Student","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":5,"SystemRole":"Teacher","IsHomeOrganization":true,"ValidFrom":"2015-11-21T10:22:04","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":6,"SystemRole":"Student","IsHomeOrganization":true,"ValidFrom":"2015-11-21T10:22:04","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":7,"SystemRole":"Student","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":8,"SystemRole":"Teacher","IsHomeOrganization":true,"ValidFrom":"2015-11-21T10:22:04","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":9,"SystemRole":"Guest","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    },{
      "OrganizationId":1,"UserId":10,"SystemRole":"Administrator","IsHomeOrganization":true,"ValidFrom":"2015-07-24T14:25:01","ValidTo":"9999-12-31T00:00:00"
    }
  ]
}