BullhornInstall

Summary

Retrieve multiple Client Contact records from Bullhorn using either SQL WHERE clause filtering or Lucene full-text search.

Inputs

• Search Type — Selects the query engine to use: Query (SQL) for WHERE clause filtering (supports JOINs and comparisons) or Search (Lucene) for full-text searching.
• WHERE Clause / Search Query (Lucene) (required) — The query filter expression. When Search Type is Query, accepts SQL WHERE syntax (e.g., 'clientCorporation.id=406 AND isDeleted=false'). When Search Type is Search, accepts Lucene query syntax (e.g., 'firstName:John').
• Fields — Comma-separated list of fields to return for each record. Defaults to 'id,firstName,lastName,email,clientCorporation'.
• Return All — Whether to automatically paginate and retrieve all matching records.
• Limit — Maximum number of records to return when Return All is disabled. Accepts values between 1 and 500 (default: 50).

Output shape

a list of items

Returns an array where each item represents a Client Contact entity containing the selected fields. When Return All is true, the node automatically iterates through all available pages.

Examples

Example 1: Query active client contacts assigned to a specific corporation ID

Search Type = 'Query (SQL)', WHERE Clause = 'clientCorporation.id=406 AND isDeleted=false', Fields = 'id,firstName,lastName,email,clientCorporation', Limit = 50

Example 2: Search client contacts using Lucene syntax and return all matching results

Search Type = 'Search (Lucene)', Search Query (Lucene) = 'firstName:John AND isDeleted:false', Return All = true

Links

• n8n community nodes installation guide