Organisation

Overview

This is a dimension entity which contains information about organisations and their place in site hierarchy.

Which organisations are included?

In the entity all organisations are present.

Usage in itslearnig

images/download/attachments/41661349/image2018-7-10_10_57_47.png

images/download/attachments/41661349/image2018-7-10_10_59_24.png

images/download/attachments/41661349/image2018-7-10_10_59_58.png

Notes

  • The entity shows the latest version of organisations only.

  • Levels organization:

    • Example schema:

      • Home organization name

        • Folder 1

          • Folder 1 - 1

            • Organization name 1 - this is "OrganizationLevel3" - level 3 organization hierarchy

          • Folder 1 - 2

        • Folder 2

          • Organization name 2 - this is "OrganizationLevel2" - level 2 organization hierarchy

        • Folder 3

Diagram

images/download/attachments/41661349/Organization.PNG

Entity Details

Name

Data type

Nullable

Description

OrganizationId

Edm.Int32

false

business ID

OrganizationType

Edm.String

organisation type (site / school)

OrganizationTitle

Edm.String

organisation name

OrganizationLevel1

Edm.String

level 1 inorganisationhierarchy

OrganizationLevel2

Edm.String

level 2 in organisation hierarchy

OrganizationLevel3

Edm.String

level 3 in organisation hierarchy

OrganizationLevel4

Edm.String

level 4 in organisation hierarchy

OrganizationLevel5

Edm.String

level 5 in organisation hierarchy

OrganizationLevel6

Edm.String

level 6 in organisation hierarchy

OrganizationLevel7

Edm.String

level 7 in organisation hierarchy

OrganizationLevel8

Edm.String

level 8 in organisation hierarchy

OrganizationLevel9

Edm.String

level 9 in organisation hierarchy

OrganizationLevel10

Edm.String

level 10 in organisation hierarchy

ExternalOrganizationId

Edm.String

external ID (if exists)

OrganizationStatus

Edm.String

organisation status (active)

CreatedOn

Edm.DateTime

creation date

SQL code

CREATE TABLE [Dwh].[Organization]([OrganizationId] [INT] NOT NULL ,[OrganizationType] [NVARCHAR]( 100 ) NULL ,[OrganizationTitle] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel1] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel2] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel3] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel4] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel5] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel6] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel7] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel8] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel9] [NVARCHAR]( 100 ) NULL ,[OrganizationLevel10] [NVARCHAR]( 100 ) NULL ,[ExternalOrganizationId] [NVARCHAR]( 255 ) NULL ,[OrganizationStatus] [NVARCHAR]( 100 ) NULL ,[CreatedOn] [DATETIME] NULL ) ALTER TABLE Dwh.Organization ADD CONSTRAINT PK_Organization PRIMARY KEY (OrganizationId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/Organizations?$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:02:32Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(-1)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(-1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(-1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(-1)/Cours
eVisits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(-1)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">-1</d:OrganizationId>
<d:OrganizationType>Other</d:OrganizationType>
<d:OrganizationTitle>Other</d:OrganizationTitle>
<d:OrganizationLevel1>Other</d:OrganizationLevel1>
<d:OrganizationLevel2>Other</d:OrganizationLevel2>
<d:OrganizationLevel3>Other</d:OrganizationLevel3>
<d:OrganizationLevel4>Other</d:OrganizationLevel4>
<d:OrganizationLevel5>Other</d:OrganizationLevel5>
<d:OrganizationLevel6 m:null="true" />
<d:OrganizationLevel7 m:null="true" />
<d:OrganizationLevel8 m:null="true" />
<d:OrganizationLevel9 m:null="true" />
<d:OrganizationLevel10 m:null="true" />
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Other</d:OrganizationStatus>
<d:CreatedOn m:null="true" />
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(1)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(1)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(1)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">1</d:OrganizationId>
<d:OrganizationType>Site</d:OrganizationType>
<d:OrganizationTitle>Engine7</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>Engine7</d:OrganizationLevel2>
<d:OrganizationLevel3>Engine7</d:OrganizationLevel3>
<d:OrganizationLevel4>Engine7</d:OrganizationLevel4>
<d:OrganizationLevel5>Engine7</d:OrganizationLevel5>
<d:OrganizationLevel6>Engine7</d:OrganizationLevel6>
<d:OrganizationLevel7>Engine7</d:OrganizationLevel7>
<d:OrganizationLevel8>Engine7</d:OrganizationLevel8>
<d:OrganizationLevel9>Engine7</d:OrganizationLevel9>
<d:OrganizationLevel10>Engine7</d:OrganizationLevel10>
<d:ExternalOrganizationId>root__92D3E89D1B9C2D1CD708ACBB3706AC773BF639EA3524D19AB2EAF1A6CC3BAB1</d:ExternalOrganizationId>
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(2)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(2)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(2)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(2)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(2)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">2</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>daniel_hierarchy</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>daniel_hierarchy</d:OrganizationLevel2>
<d:OrganizationLevel3>daniel_hierarchy</d:OrganizationLevel3>
<d:OrganizationLevel4>daniel_hierarchy</d:OrganizationLevel4>
<d:OrganizationLevel5>daniel_hierarchy</d:OrganizationLevel5>
<d:OrganizationLevel6>daniel_hierarchy</d:OrganizationLevel6>
<d:OrganizationLevel7>daniel_hierarchy</d:OrganizationLevel7>
<d:OrganizationLevel8>daniel_hierarchy</d:OrganizationLevel8>
<d:OrganizationLevel9>daniel_hierarchy</d:OrganizationLevel9>
<d:OrganizationLevel10>daniel_hierarchy</d:OrganizationLevel10>
<d:ExternalOrganizationId>SR34567</d:ExternalOrganizationId>
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(3)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(3)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(3)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(3)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(3)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">3</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>KFS_hierarchy</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>KFS_hierarchy</d:OrganizationLevel2>
<d:OrganizationLevel3>KFS_hierarchy</d:OrganizationLevel3>
<d:OrganizationLevel4>KFS_hierarchy</d:OrganizationLevel4>
<d:OrganizationLevel5>KFS_hierarchy</d:OrganizationLevel5>
<d:OrganizationLevel6>KFS_hierarchy</d:OrganizationLevel6>
<d:OrganizationLevel7>KFS_hierarchy</d:OrganizationLevel7>
<d:OrganizationLevel8>KFS_hierarchy</d:OrganizationLevel8>
<d:OrganizationLevel9>KFS_hierarchy</d:OrganizationLevel9>
<d:OrganizationLevel10>KFS_hierarchy</d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(4)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(4)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(4)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(4)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(4)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">4</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>Y??roslav</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>Y??roslav</d:OrganizationLevel2>
<d:OrganizationLevel3>Y??roslav</d:OrganizationLevel3>
<d:OrganizationLevel4>Y??roslav</d:OrganizationLevel4>
<d:OrganizationLevel5>Y??roslav</d:OrganizationLevel5>
<d:OrganizationLevel6>Y??roslav</d:OrganizationLevel6>
<d:OrganizationLevel7>Y??roslav</d:OrganizationLevel7>
<d:OrganizationLevel8>Y??roslav</d:OrganizationLevel8>
<d:OrganizationLevel9>Y??roslav</d:OrganizationLevel9>
<d:OrganizationLevel10>Y??roslav</d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(5)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(5)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(5)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(5)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(5)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">5</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>Y??roslav 2</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>Y??roslav 2</d:OrganizationLevel2>
<d:OrganizationLevel3>Y??roslav 2</d:OrganizationLevel3>
<d:OrganizationLevel4>Y??roslav 2</d:OrganizationLevel4>
<d:OrganizationLevel5>Y??roslav 2</d:OrganizationLevel5>
<d:OrganizationLevel6>Y??roslav 2</d:OrganizationLevel6>
<d:OrganizationLevel7>Y??roslav 2</d:OrganizationLevel7>
<d:OrganizationLevel8>Y??roslav 2</d:OrganizationLevel8>
<d:OrganizationLevel9>Y??roslav 2</d:OrganizationLevel9>
<d:OrganizationLevel10>Y??roslav 2</d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(6)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(6)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(6)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(6)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(6)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">6</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>Tatiana's school</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>Tatiana's school</d:OrganizationLevel2>
<d:OrganizationLevel3>Tatiana's school</d:OrganizationLevel3>
<d:OrganizationLevel4>Tatiana's school</d:OrganizationLevel4>
<d:OrganizationLevel5>Tatiana's school</d:OrganizationLevel5>
<d:OrganizationLevel6>Tatiana's school</d:OrganizationLevel6>
<d:OrganizationLevel7>Tatiana's school</d:OrganizationLevel7>
<d:OrganizationLevel8>Tatiana's school</d:OrganizationLevel8>
<d:OrganizationLevel9>Tatiana's school</d:OrganizationLevel9>
<d:OrganizationLevel10>Tatiana's school</d:OrganizationLevel10>
<d:ExternalOrganizationId>autogenerated_Tatiana'sschool_211072423</d:ExternalOrganizationId>
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(7)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(7)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(7)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(7)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(7)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">7</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle xml:space="preserve">School 1 </d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2 xml:space="preserve">School 1 </d:OrganizationLevel2>
<d:OrganizationLevel3 xml:space="preserve">School 1 </d:OrganizationLevel3>
<d:OrganizationLevel4 xml:space="preserve">School 1 </d:OrganizationLevel4>
<d:OrganizationLevel5 xml:space="preserve">School 1 </d:OrganizationLevel5>
<d:OrganizationLevel6 xml:space="preserve">School 1 </d:OrganizationLevel6>
<d:OrganizationLevel7 xml:space="preserve">School 1 </d:OrganizationLevel7>
<d:OrganizationLevel8 xml:space="preserve">School 1 </d:OrganizationLevel8>
<d:OrganizationLevel9 xml:space="preserve">School 1 </d:OrganizationLevel9>
<d:OrganizationLevel10 xml:space="preserve">School 1 </d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(8)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(8)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(8)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(8)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(8)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">8</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>School 2</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>School 2</d:OrganizationLevel2>
<d:OrganizationLevel3>School 2</d:OrganizationLevel3>
<d:OrganizationLevel4>School 2</d:OrganizationLevel4>
<d:OrganizationLevel5>School 2</d:OrganizationLevel5>
<d:OrganizationLevel6>School 2</d:OrganizationLevel6>
<d:OrganizationLevel7>School 2</d:OrganizationLevel7>
<d:OrganizationLevel8>School 2</d:OrganizationLevel8>
<d:OrganizationLevel9>School 2</d:OrganizationLevel9>
<d:OrganizationLevel10>School 2</d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/Organizations(9)</id>
<category term="Itslearning.Reporting.Data.Models.Organization" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Organizations(9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/Organizations(9)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseVisits" type="application/atom+xml;type=feed" title="CourseVisits" href="https://reporting.itslearning.com/odata/engine7/Organizations(9)/Course
Visits" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrganizationMemberships" type="application/atom+xml;type=feed" title="OrganizationMemberships" href="https://reporting.itslearning.com/odata/engine7/O
rganizations(9)/OrganizationMemberships" />
<title />
<updated>2016-12-21T10:02:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:OrganizationId m:type="Edm.Int32">9</d:OrganizationId>
<d:OrganizationType>School</d:OrganizationType>
<d:OrganizationTitle>nikita school</d:OrganizationTitle>
<d:OrganizationLevel1>Engine7</d:OrganizationLevel1>
<d:OrganizationLevel2>nikita school</d:OrganizationLevel2>
<d:OrganizationLevel3>nikita school</d:OrganizationLevel3>
<d:OrganizationLevel4>nikita school</d:OrganizationLevel4>
<d:OrganizationLevel5>nikita school</d:OrganizationLevel5>
<d:OrganizationLevel6>nikita school</d:OrganizationLevel6>
<d:OrganizationLevel7>nikita school</d:OrganizationLevel7>
<d:OrganizationLevel8>nikita school</d:OrganizationLevel8>
<d:OrganizationLevel9>nikita school</d:OrganizationLevel9>
<d:OrganizationLevel10>nikita school</d:OrganizationLevel10>
<d:ExternalOrganizationId m:null="true" />
<d:OrganizationStatus>Active</d:OrganizationStatus>
<d:CreatedOn m:type="Edm.DateTime">1900-01-01T00:00:00</d:CreatedOn>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#Organizations","value":[
{
"OrganizationId":-1,"OrganizationType":"Other","OrganizationTitle":"Other","OrganizationLevel1":"Other","OrganizationLevel2":"Other","OrganizationLevel3":"Other","OrganizationLevel4":"Other","OrganizationLevel5":"Other","
OrganizationLevel6":null,"OrganizationLevel7":null,"OrganizationLevel8":null,"OrganizationLevel9":null,"OrganizationLevel10":null,"ExternalOrganizationId":null,"OrganizationStatus":"Other","CreatedOn":null
},{
"OrganizationId":1,"OrganizationType":"Site","OrganizationTitle":"Engine7","OrganizationLevel1":"Engine7","OrganizationLevel2":"Engine7","OrganizationLevel3":"Engine7","OrganizationLevel4":"Engine7","OrganizationLevel5":"
Engine7","OrganizationLevel6":"Engine7","OrganizationLevel7":"Engine7","OrganizationLevel8":"Engine7","OrganizationLevel9":"Engine7","OrganizationLevel10":"Engine7","ExternalOrganizationId":"root__92D3E89D1B9C2D1CD708ACBB3706AC
773BF639EA3524D19AB2EAF1A6CC3BAB1","OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":2,"OrganizationType":"School","OrganizationTitle":"daniel_hierarchy","OrganizationLevel1":"Engine7","OrganizationLevel2":"daniel_hierarchy","OrganizationLevel3":"daniel_hierarchy","OrganizationLevel4":"da
niel_hierarchy","OrganizationLevel5":"daniel_hierarchy","OrganizationLevel6":"daniel_hierarchy","OrganizationLevel7":"daniel_hierarchy","OrganizationLevel8":"daniel_hierarchy","OrganizationLevel9":"daniel_hierarchy","Organizati
onLevel10":"daniel_hierarchy","ExternalOrganizationId":"SR34567","OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":3,"OrganizationType":"School","OrganizationTitle":"KFS_hierarchy","OrganizationLevel1":"Engine7","OrganizationLevel2":"KFS_hierarchy","OrganizationLevel3":"KFS_hierarchy","OrganizationLevel4":"KFS_hierarc
hy","OrganizationLevel5":"KFS_hierarchy","OrganizationLevel6":"KFS_hierarchy","OrganizationLevel7":"KFS_hierarchy","OrganizationLevel8":"KFS_hierarchy","OrganizationLevel9":"KFS_hierarchy","OrganizationLevel10":"KFS_hierarchy",
"ExternalOrganizationId":null,"OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":4,"OrganizationType":"School","OrganizationTitle":"Y\u00e5roslav","OrganizationLevel1":"Engine7","OrganizationLevel2":"Y\u00e5roslav","OrganizationLevel3":"Y\u00e5roslav","OrganizationLevel4":"Y\u00e5rosl
av","OrganizationLevel5":"Y\u00e5roslav","OrganizationLevel6":"Y\u00e5roslav","OrganizationLevel7":"Y\u00e5roslav","OrganizationLevel8":"Y\u00e5roslav","OrganizationLevel9":"Y\u00e5roslav","OrganizationLevel10":"Y\u00e5roslav",
"ExternalOrganizationId":null,"OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":5,"OrganizationType":"School","OrganizationTitle":"Y\u00e5roslav 2","OrganizationLevel1":"Engine7","OrganizationLevel2":"Y\u00e5roslav 2","OrganizationLevel3":"Y\u00e5roslav 2","OrganizationLevel4":"Y\u00
e5roslav 2","OrganizationLevel5":"Y\u00e5roslav 2","OrganizationLevel6":"Y\u00e5roslav 2","OrganizationLevel7":"Y\u00e5roslav 2","OrganizationLevel8":"Y\u00e5roslav 2","OrganizationLevel9":"Y\u00e5roslav 2","OrganizationLevel10
":"Y\u00e5roslav 2","ExternalOrganizationId":null,"OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":6,"OrganizationType":"School","OrganizationTitle":"Tatiana's school","OrganizationLevel1":"Engine7","OrganizationLevel2":"Tatiana's school","OrganizationLevel3":"Tatiana's school","OrganizationLevel4":"Ta
tiana's school","OrganizationLevel5":"Tatiana's school","OrganizationLevel6":"Tatiana's school","OrganizationLevel7":"Tatiana's school","OrganizationLevel8":"Tatiana's school","OrganizationLevel9":"Tatiana's school","Organizati
onLevel10":"Tatiana's school","ExternalOrganizationId":"autogenerated_Tatiana'sschool_211072423","OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":7,"OrganizationType":"School","OrganizationTitle":"School 1 ","OrganizationLevel1":"Engine7","OrganizationLevel2":"School 1 ","OrganizationLevel3":"School 1 ","OrganizationLevel4":"School 1 ","Organizatio
nLevel5":"School 1 ","OrganizationLevel6":"School 1 ","OrganizationLevel7":"School 1 ","OrganizationLevel8":"School 1 ","OrganizationLevel9":"School 1 ","OrganizationLevel10":"School 1 ","ExternalOrganizationId":null,"Organizat
ionStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":8,"OrganizationType":"School","OrganizationTitle":"School 2","OrganizationLevel1":"Engine7","OrganizationLevel2":"School 2","OrganizationLevel3":"School 2","OrganizationLevel4":"School 2","OrganizationLev
el5":"School 2","OrganizationLevel6":"School 2","OrganizationLevel7":"School 2","OrganizationLevel8":"School 2","OrganizationLevel9":"School 2","OrganizationLevel10":"School 2","ExternalOrganizationId":null,"OrganizationStatus"
:"Active","CreatedOn":"1900-01-01T00:00:00"
},{
"OrganizationId":9,"OrganizationType":"School","OrganizationTitle":"nikita school","OrganizationLevel1":"Engine7","OrganizationLevel2":"nikita school","OrganizationLevel3":"nikita school","OrganizationLevel4":"nikita scho
ol","OrganizationLevel5":"nikita school","OrganizationLevel6":"nikita school","OrganizationLevel7":"nikita school","OrganizationLevel8":"nikita school","OrganizationLevel9":"nikita school","OrganizationLevel10":"nikita school",
"ExternalOrganizationId":null,"OrganizationStatus":"Active","CreatedOn":"1900-01-01T00:00:00"
}
]
}