JDBC Driver for Bullhorn CRM

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654