Excel Add-In for Bullhorn CRM

Build 24.0.9062

Note

Create, update, delete and query data of 'Note' entity in BullhornCRM system.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

The Id of the Note.

AboutId Int False

The AboutId of the Note.

Action String False

The Action of the Note.

AuthorId Int False

The AuthorId of the Note.

BhTimeStamp String False

The BhTimeStamp of the Note.

Comments String False

The Comments of the Note.

DateAdded Datetime False

The DateAdded of the Note.

DateLastModified Datetime False

The DateLastModified of the Note.

ExternalID String False

The ExternalID of the Note.

JobOrderId Int False

The JobOrderId of the Note.

MigrateGUID String False

The MigrateGUID of the Note.

PrimaryDepartmentName String False

The PrimaryDepartmentName of the Note.

TimespentMin Int False

The TimespentMin of the Note.

TruestDateAdded Datetime False

The TruestDateAdded of the Note.

IsDeleted Bool False

The IsDeleted of the Note.

Pseudo-Columns

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

Name Type Description
LuceneQuery String

Enter a Lucene query to send it directly to the BullhornCRM API. Note that other filters won't work if this is specified.

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