Sourcier AdvancedInstall

Summary

Retrieve multiple Lead records from Bullhorn using a JPQL WHERE clause with optional field selection, record limits, and filtering of deleted entries.

Inputs

• Authentication — Choose between User Credentials (Email & Password) or Enterprise Credentials (API Key) for Bullhorn authentication.
• Enable Operations Log — Whether to emit an audit log to a secondary output for each write operation (create/update/delete/parseResume/fileUpload). Defaults to false and has no effect on this read operation.
• Fields — Specify which Bullhorn Lead fields to return. You can rename them in output by setting an Output Name or leave empty to keep the Bullhorn field name.
• Limit — Maximum number of Lead records to return in one call, ranging from 1 to 500. Defaults to 20.
• Where Clause (required) — JPQL WHERE clause to filter Leads, e.g., "id > 0 AND status = 'Active'".
• Hide Deleted — Automatically exclude deleted or archived Leads by appending filters to the query. Defaults to true.
• Output Fields — Additional fields or values to include in every output item, merged into result items (including no-results or errors).

Output shape

a list of Lead records matching the query, each including the requested fields, with optional additional output fields merged in

The number of records returned is capped by the Limit parameter (max 500). The query respects the Hide Deleted toggle unless explicitly overridden in the WHERE clause. The operation does not produce outputs on the secondary Operations Log output since it's a read-only operation.

Examples

Example 1: Retrieve up to 50 active leads with email and name fields, excluding deleted records

Set Authentication to Enterprise, Where Clause to "status = 'Active'", Fields to include 'email' and 'name', Limit to 50, Hide Deleted enabled.

Links

• n8n community nodes installation guide