BullhornHub AdvancedInstall

Summary

Retrieve multiple Opportunity records matching a specified JPQL WHERE clause, with control over returned fields, result limit, and exclusion of deleted or archived records.

Inputs

• Authentication — Select authentication method: User Credentials (Email & Password) or Enterprise Credentials (API Key). Defaults to Enterprise credentials.
• Fields (required) — Specify the Bullhorn Opportunity fields to return. You can rename output fields optionally by setting an Output Name per field.
• Limit — Set the maximum number of Opportunity records to return, between 1 and 500. Defaults to 20.
• Where Clause (required) — Define the JPQL WHERE clause to filter Opportunity records, e.g., 'id > 0 AND status = "Active"'.
• Hide Deleted — Choose whether to automatically exclude deleted or archived Opportunities. Adds an isDeleted:false filter for most entities and excludes archived status where applicable. Defaults to true.
• Enable Operations Log — Optionally enable emission of an audit log entry to a secondary output for changes. This only applies to write operations and is false by default.
• Output Fields — Specify additional fields or fixed values to include in every output item, merged into all results.

Output shape

a list of Opportunity records matching the query

Returned records include only requested fields. Result count respects the limit parameter up to 500. The query respects the hideDeleted setting by adding filters to exclude deleted or archived records when enabled. If Enable Operations Log is true, a second output stream for audit logs exists but is inactive for this read-only operation.

Examples

Example 1: Fetch up to 50 active Opportunities showing id, name, and status fields.

Limit=50, Where Clause='status = "Active"', Fields mapped to ['id', 'name', 'status']

Example 2: Retrieve Opportunities without deleted/archived records, with custom field renaming.

Hide Deleted=true, Fields mapping with Output Name to rename 'owner' field to 'OpportunityOwner'

Links

• n8n community nodes installation guide