ConsumerType

Overview

This is a dimension entity which gather basic information about consumer types.

Which consumer type are included?

This entity includes consumer types used in application to track mobile and desktop sessions in courses and elements.

Usage in itslearning

................................

Notes

  • the entity shows mobile twice since there are two ids for mobile session

Diagram

images/download/attachments/45732144/ConsumerType.PNG

Entity Details

Name

Data type

Nullable

Description

ConsumerTypeId

Edm.Int32

false

business ID for a consumer type

ConsumerTypeTitle

Edm.String

consumer type title

SQL code:


CREATE TABLE [Dwh].[ConsumerType]([ConsumerTypeId] [INT] NOT NULL ,[ConsumerTypeTitle] [NVARCHAR]( 255 ) NOT NULL ) ALTER TABLE Dwh.ConsumerType ADD CONSTRAINT PK_ConsumerType PRIMARY KEY (ConsumerTypeId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/ConsumerTypes

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" xml
ns: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-23T12:57:32Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ConsumerTypes(1)</id>
<category term="Itslearning.Reporting.Data.Models.ConsumerType" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserCourseSessions" type="application/atom+xml;type=feed" title="UserCourseSessions" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(1)/UserCour
seSessions" />
<title />
<updated>2018-04-23T12:57:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ConsumerTypeId m:type="Edm.Int32">1</d:ConsumerTypeId>
<d:ConsumerTypeTitle>Other</d:ConsumerTypeTitle>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ConsumerTypes(2)</id>
<category term="Itslearning.Reporting.Data.Models.ConsumerType" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(2)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(2)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserCourseSessions" type="application/atom+xml;type=feed" title="UserCourseSessions" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(2)/UserCour
seSessions" />
<title />
<updated>2018-04-23T12:57:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ConsumerTypeId m:type="Edm.Int32">2</d:ConsumerTypeId>
<d:ConsumerTypeTitle>Mobile</d:ConsumerTypeTitle>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ConsumerTypes(3)</id>
<category term="Itslearning.Reporting.Data.Models.ConsumerType" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(3)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(3)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserCourseSessions" type="application/atom+xml;type=feed" title="UserCourseSessions" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(3)/UserCour
seSessions" />
<title />
<updated>2018-04-23T12:57:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ConsumerTypeId m:type="Edm.Int32">3</d:ConsumerTypeId>
<d:ConsumerTypeTitle>Mobile</d:ConsumerTypeTitle>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ConsumerTypes(4)</id>
<category term="Itslearning.Reporting.Data.Models.ConsumerType" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(4)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(4)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/UserCourseSessions" type="application/atom+xml;type=feed" title="UserCourseSessions" href="https://reporting.itslearning.com/odata/engine7/ConsumerTypes(4)/UserCour
seSessions" />
<title />
<updated>2018-04-23T12:57:32Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ConsumerTypeId m:type="Edm.Int32">4</d:ConsumerTypeId>
<d:ConsumerTypeTitle>Web</d:ConsumerTypeTitle>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#ConsumerTypes","value":[
{
"ConsumerTypeId":1,"ConsumerTypeTitle":"Other"
},{
"ConsumerTypeId":2,"ConsumerTypeTitle":"Mobile"
},{
"ConsumerTypeId":3,"ConsumerTypeTitle":"Mobile"
},{
"ConsumerTypeId":4,"ConsumerTypeTitle":"Web"
}
]
}