BullhornHub AdvancedInstall

Summary

Retrieve multiple Contact records from Bullhorn using a JPQL WHERE clause with optional field selection, pagination limit, and deletion filtering.

Inputs

• Authentication — Choose between User Credentials (Email & Password) or Enterprise Credentials (API Key) for authenticating with Bullhorn.
• Fields (required) — List Bullhorn fields to return for each Contact record. Each field can be renamed in the output by setting an Output Name, or left blank to keep the original Bullhorn field name.
• Limit — Maximum number of Contact records to return, with a default of 20 and a maximum of 500.
• Where Clause (required) — JPQL WHERE clause to filter the Contacts retrieved, for example, filtering by id or status. This clause must be provided and supports expressions like 'id > 0 AND status = 'Active''.
• Hide Deleted — Boolean flag to exclude deleted or archived Contacts automatically. When enabled (default true), adds filters such as isDeleted:false or excludes archived statuses depending on entity support.
• Enable Operations Log — Toggle to emit an audit log row to a secondary output for every write operation; this does not affect this read operation directly but prepares for audit logging elsewhere.
• Output Fields — Additional static or dynamic fields to include in every output item, merged into each result object.

Output shape

a list of Contact records matching the query

The operation returns a list of Contact objects matching the provided JPQL where clause. The results include only the fields specified in 'Fields' plus any 'Output Fields' merged in. Results are limited by the 'Limit' parameter (max 500). Deleted or archived records are excluded if 'Hide Deleted' is true, by automatically adding appropriate filters. The 'Where Clause' must be a valid JPQL expression filtering Contact entities. Errors or empty result sets are returned as execution errors or empty arrays respectively.

Examples

Example 1: Retrieve up to 50 active Contacts, excluding deleted ones, returning only 'id', 'firstName', and 'email' fields.

Set 'Where Clause' to "id > 0 AND status = 'Active'", 'Limit' to 50, 'Hide Deleted' to true, and specify 'fields' as 'id', 'firstName', and 'email'.

Links

• n8n community nodes installation guide