Power BI Connector for Bullhorn CRM

Build 24.0.9062

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

使用できる値は次のとおりです。Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement

EntityId String The unique identifier of the entity you want to list attached files from.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062