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/48697911/add_file_or_folder.png

images/download/attachments/48697911/file_element.PNG

or by attaching files to e.g. Assignment:

images/download/attachments/48697911/assignment_file_attachment.PNG

Relationships

File is linked to:

Diagram:

images/download/attachments/48697911/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

SQL Code:


Request Body

URI
https://reporting.itslearning.com/odata/engine7/Files?$top=10

Response Body - XML

XML response
 

Response body - JSON (default output format)

JSON response