File

Overview

Represents file uploaded to the application. Files can be uploaded in various ways, including course elements (File-type course element), attachments, profile images.

Which Files are included?

All files uploaded to the application are present, including files in courses, profile images, etc.

Usage in itslearning

Files can be added to a course directly using Resources -> Add -> File or Folder:

or by attaching files to e.g. Assignment:

Relationships

File is linked to:

User - References user that have uploaded this file
CourseElementFileAssociation - Association with course element, where the file is attached

Diagram:

Entity Details

Name	Data type	Nullable	Description
FileId	Edm.Int32	false	Id of a file
FileTitle	Edm.String	true	File title
FileMimeType	Edm.String	true	File mime type
FileStatus	Edm.String	true	File status
FileSize	Edm.Int64	false	File size
CreatedUserId	Edm.Int32	false	Id of a user that have created this file
IsTempFile	Edm.Boolean	false	Flag that determines if file is temporary
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/Files?$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>2020-06-08T11:33:29Z</updated>
  <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files" />
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(-1)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(-1)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(-1)" />
    <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/Files(-1)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">-1</d:FileId>
        <d:FileTitle>Other</d:FileTitle>
        <d:FileMimeType>Other</d:FileMimeType>
        <d:FileStatus>Deleted</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">0</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">-1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2020-06-07T20:03:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(1)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(1)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(1)" />
    <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/Files(1)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">1</d:FileId>
        <d:FileTitle>Screenshot_20170118-082253.png</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">102923</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">5760</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(2)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(2)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(2)" />
    <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/Files(2)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">2</d:FileId>
        <d:FileTitle>Kalimba.mp3</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">8414449</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(3)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(3)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(3)" />
    <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/Files(3)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">3</d:FileId>
        <d:FileTitle>answer_file - Copy (165).txt</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">1024</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">5140</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(4)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(4)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(4)" />
    <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/Files(4)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">4</d:FileId>
        <d:FileTitle>Office.docx</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">15101</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">6629</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(5)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(5)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(5)" />
    <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/Files(5)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">5</d:FileId>
        <d:FileTitle>calculation (1).xlsx</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">8457</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">6777</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(6)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(6)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(6)" />
    <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/Files(6)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">6</d:FileId>
        <d:FileTitle>answer_file - Copy (58).txt</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">6</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(7)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(7)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(7)" />
    <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/Files(7)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">7</d:FileId>
        <d:FileTitle>Attendance quickfixes - R45.docx</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">82938</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(8)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(8)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(8)" />
    <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/Files(8)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">8</d:FileId>
        <d:FileTitle>Lekcja T4J5062W.txt</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">7828</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
  <entry>
    <id>https://reporting.itslearning.com/odata/engine7/Files(9)</id>
    <category term="Itslearning.Reporting.Data.Models.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <link rel="edit" href="https://reporting.itslearning.com/odata/engine7/Files(9)" />
    <link rel="self" href="https://reporting.itslearning.com/odata/engine7/Files(9)" />
    <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/Files(9)/User" />
    <title />
    <updated>2020-06-08T11:33:29Z</updated>
    <author>
      <name />
    </author>
    <content type="application/xml">
      <m:properties>
        <d:FileId m:type="Edm.Int32">9</d:FileId>
        <d:FileTitle>swfFile.swf</d:FileTitle>
        <d:FileMimeType m:null="true" />
        <d:FileStatus>Available</d:FileStatus>
        <d:FileSize m:type="Edm.Int64">13</d:FileSize>
        <d:CreatedUserId m:type="Edm.Int32">1</d:CreatedUserId>
        <d:IsTempFile m:type="Edm.Boolean">false</d:IsTempFile>
        <d:T_ModifiedDate m:type="Edm.DateTime">2019-06-27T05:26:00</d:T_ModifiedDate>
      </m:properties>
    </content>
  </entry>
</feed>

Response body - JSON (default output format)

JSON response

 {
  "odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#Files","value":[
    {
      "FileId":-1,"FileTitle":"Other","FileMimeType":"Other","FileStatus":"Deleted","FileSize":"0","CreatedUserId":-1,"IsTempFile":false,"T_ModifiedDate":"2020-06-07T20:03:00"
    },{
      "FileId":1,"FileTitle":"Screenshot_20170118-082253.png","FileMimeType":null,"FileStatus":"Available","FileSize":"102923","CreatedUserId":5760,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":2,"FileTitle":"Kalimba.mp3","FileMimeType":null,"FileStatus":"Available","FileSize":"8414449","CreatedUserId":1,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":3,"FileTitle":"answer_file - Copy (165).txt","FileMimeType":null,"FileStatus":"Available","FileSize":"1024","CreatedUserId":5140,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":4,"FileTitle":"Office.docx","FileMimeType":null,"FileStatus":"Available","FileSize":"15101","CreatedUserId":6629,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":5,"FileTitle":"calculation (1).xlsx","FileMimeType":null,"FileStatus":"Available","FileSize":"8457","CreatedUserId":6777,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":6,"FileTitle":"answer_file - Copy (58).txt","FileMimeType":null,"FileStatus":"Available","FileSize":"6","CreatedUserId":1,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":7,"FileTitle":"Attendance quickfixes - R45.docx","FileMimeType":null,"FileStatus":"Available","FileSize":"82938","CreatedUserId":1,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":8,"FileTitle":"Lekcja T4J5062W.txt","FileMimeType":null,"FileStatus":"Available","FileSize":"7828","CreatedUserId":1,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    },{
      "FileId":9,"FileTitle":"swfFile.swf","FileMimeType":null,"FileStatus":"Available","FileSize":"13","CreatedUserId":1,"IsTempFile":false,"T_ModifiedDate":"2019-06-27T05:26:00"
    }
  ]
}