EntityFiles
List the attached files to an entity.
View Specific Information
Use this view as a helper in case you need the file unique identifiers, for the DownloadFile.
Except the pseudo columns, no filters are handled server-side on this view. EntityType and EntityId must be specified to query from this view.
SELECT * FROM EntityFiles WHERE EntityType = 'Candidate' AND EntityId = '110011'
Columns
| Name | Type | Description |
| Id [KEY] | Int | The unique identifier of the file. |
| Name | String | The name of the file. |
| DateAdded | Datetime | Datetime the file was added. |
| FileType | String | The type of the file. |
| Type | String | The type of the file. |
| FileExtension | String | The type of the file. |
| Description | String | A brief description of the file. |
| IsDeleted | Boolean | Whether or not the file is deleted. |
| IsPrivate | Boolean | Whether or not the file is private. |
| IsExternal | Boolean | Whether or not the file is external. |
| ContentType | String | The ContentType of the EntityFiles. |
| ContentSubType | String | The ContentSubType of the EntityFiles. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| EntityType | String | The entity type you want to list the attached files for. The available values are Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement.
The allowed values are Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement. |
| EntityId | String | The unique identifier of the entity you want to list attached files from. |