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:

images/download/attachments/284208137/add_file_or_folder.png

images/download/attachments/284208137/file_element.PNG

or by attaching files to e.g. Assignment:

images/download/attachments/284208137/assignment_file_attachment.PNG


Relationships

File is linked to:

Diagram:

images/download/attachments/284208137/file.PNG

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"
}
]
}