Overview

Connects Course Elements and files attached to them.

Which CourseElementFileAssociations are included?

  • All associations between course elements and files are included

Usage in itslearning

See usage in File.

Relationships

File is linked to:

Diagram:


Entity Details


Name

Data type

Nullable

Description

CourseElementId

Edm.Int32

false

Id of a course element that have a file attached

FileId

Edm.Int32

false

Id of a file that is attached to the course element

CourseId

Edm.Int32

false

Id of a course that contains the element

Request Body


URI
https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations?$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:23:34Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=-1,FileId=-1)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">-1</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">-1</d:CourseElementId>
<d:FileId m:type="Edm.Int32">-1</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7998,FileId=7364)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">570</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">7998</d:CourseElementId>
<d:FileId m:type="Edm.Int32">7364</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=7999,FileId=6787)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">570</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">7999</d:CourseElementId>
<d:FileId m:type="Edm.Int32">6787</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8385,FileId=7365)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">7</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">8385</d:CourseElementId>
<d:FileId m:type="Edm.Int32">7365</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8393,FileId=7366)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">352</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">8393</d:CourseElementId>
<d:FileId m:type="Edm.Int32">7366</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8624,FileId=7630)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">352</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">8624</d:CourseElementId>
<d:FileId m:type="Edm.Int32">7630</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=8766,FileId=7818)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">348</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">8766</d:CourseElementId>
<d:FileId m:type="Edm.Int32">7818</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9266,FileId=8011)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">413</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">9266</d:CourseElementId>
<d:FileId m:type="Edm.Int32">8011</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9365,FileId=8104)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">598</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">9365</d:CourseElementId>
<d:FileId m:type="Edm.Int32">8104</d:FileId>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)</id>
<category term="Itslearning.Reporting.Data.Models.CourseElementFileAssociation" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Course" type="application/atom+xml;type=entry" title="Course" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)/Course" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CourseElement" type="application/atom+xml;type=entry" title="CourseElement" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)/CourseElement" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="https://reporting.itslearning.com/odata/engine7/CourseElementFileAssociations(CourseElementId=9670,FileId=8684)/File" />
<title />
<updated>2020-06-08T11:23:34Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:CourseId m:type="Edm.Int32">646</d:CourseId>
<d:CourseElementId m:type="Edm.Int32">9670</d:CourseElementId>
<d:FileId m:type="Edm.Int32">8684</d:FileId>
</m:properties>
</content>
</entry>
</feed>


Response body - JSON (default output format)


JSON response
 {
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#CourseElementFileAssociations","value":[
{
"CourseId":-1,"CourseElementId":-1,"FileId":-1
},{
"CourseId":570,"CourseElementId":7998,"FileId":7364
},{
"CourseId":570,"CourseElementId":7999,"FileId":6787
},{
"CourseId":7,"CourseElementId":8385,"FileId":7365
},{
"CourseId":352,"CourseElementId":8393,"FileId":7366
},{
"CourseId":352,"CourseElementId":8624,"FileId":7630
},{
"CourseId":348,"CourseElementId":8766,"FileId":7818
},{
"CourseId":413,"CourseElementId":9266,"FileId":8011
},{
"CourseId":598,"CourseElementId":9365,"FileId":8104
},{
"CourseId":646,"CourseElementId":9670,"FileId":8684
}
]
}