Sourcier AdvancedInstall

Summary

Retrieve multiple Contact records from Bullhorn using a JPQL WHERE clause, with optional field selection and result limiting.

Inputs

• Authentication (required) — Choose the authentication method: User Credentials (Email & Password) or Enterprise Credentials (API Key).
• Fields — List of Bullhorn Contact fields to return, with optional output renaming.
• Limit — Maximum number of Contact records to return, between 1 and 500 (default 20).
• Where Clause (required) — JPQL WHERE clause to filter Contacts (e.g., id > 0). Used to constrain query results.
• Hide Deleted — If true (default), excludes deleted or archived Contacts by automatically adding isDeleted and archive filters as applicable.
• Enable Operations Log — If true, emits an audit log entry to a second output for each write operation (not relevant to this read operation).
• Output Fields — Additional fixed or input fields to include in every output item, merged with query results.

Output shape

a list of Contact records each containing the requested Bullhorn fields and any specified output fields

The operation requires a valid authentication to retrieve data. The 'Where Clause' filters records using JPQL syntax. Up to 'Limit' records are returned (maximum 500). The 'Fields' input specifies which Contact fields to retrieve; if empty, only the 'id' field is returned. Deleted or archived records are excluded by default if 'Hide Deleted' is true. No pagination is performed beyond the limit.

Examples

Example 1: Retrieve up to 10 active Contact records with fields 'id', 'firstName', and 'email'

Set 'Where Clause' to "isDeleted=false AND status='Active'", 'Fields' to include 'id', 'firstName', 'email', and 'Limit' to 10.

Links

• n8n community nodes installation guide