Sourcier AdvancedInstall

Summary

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

Inputs

• Authentication (required) — Select authentication method: User Credentials (Email & Password) or Enterprise Credentials (API Key).
• Fields — Specify Bullhorn fields to return for each Company record, optionally renaming output fields.
• Limit — Maximum number of Company records to return, up to 500 (default 20).
• Where Clause (required) — JPQL WHERE clause to filter the Company records (e.g., "id > 100 AND status = 'Active'").
• Hide Deleted — Whether to exclude deleted or archived Company records automatically (default true).
• Enable Operations Log — Optionally emit audit log rows for write operations (not applicable here since this is a read operation).
• Output Fields — Additional fixed fields or inputs to include in every output item, merged into each result.

Output shape

a list of Company records matching the where clause with specified fields included

Returns up to the specified limit of Company entities, applying filtering per the WHERE clause and hideDeleted option. Field output names reflect any renames specified. No pagination beyond the limit is supported within a single execution.

Examples

Example 1: Retrieve active Company records with specified fields

Authentication using Enterprise Credentials; WHERE clause 'status = "Active"'; Fields set to 'id' and 'companyName' with optional output renames; Limit set to 50; Hide Deleted enabled (default).

Links

• n8n community nodes installation guide