Sourcier AdvancedInstall

Summary

Retrieve multiple Candidate records from Bullhorn using a JPQL WHERE clause, with customizable field selection and optional filtering of deleted or archived records.

Inputs

• Authentication (required) — Choose between User Credentials (Email & Password) or Enterprise Credentials (API Key) for authentication.
• Fields (required) — Specify one or more Bullhorn candidate fields to return for each record, with optional renaming of output field names.
• Limit (required) — Maximum number of candidate records to return, between 1 and 500 (default 20).
• Where Clause (required) — JPQL WHERE clause to filter candidates (e.g., "id > 100 AND status = 'Active'").
• Hide Deleted — Whether to exclude deleted or archived records by adding filters for isDeleted or status fields (default true).
• Enable Operations Log — Optionally emit an audit log entry to the second output for each write operation (not applicable for this read operation).
• Output Fields — Assign additional fields or fixed values to include in every output item.

Output shape

a list of Candidate records matching the query

The operation returns up to the specified limit of records with fields as specified by 'Fields'. The 'Hide Deleted' option automatically excludes deleted or archived candidates. Filtering uses JPQL syntax. No pagination is described; by default, it returns a single page of results.

Examples

Example 1: Fetch up to 50 active candidates returning first name, last name, and email fields

Authentication: Enterprise Credentials; Fields: firstName, lastName, email; Limit: 50; Where Clause: status = 'Active'; Hide Deleted: true

Links

• n8n community nodes installation guide