Sourcier AdvancedInstall

Summary

Retrieve multiple Opportunity records from Bullhorn by specifying a JPQL WHERE clause, selected fields, and result limits.

Inputs

• Authentication — Choose authentication method: User Credentials (Email & Password) or Enterprise Credentials (API Key), defaulting to Enterprise.
• Fields (required) — Specify Bullhorn Opportunity fields to retrieve, with optional output renaming.
• Limit — Set the maximum number of Opportunity records to return (1 to 500, default 20).
• Where Clause (required) — Provide a JPQL WHERE clause to filter returned Opportunity records (e.g., id > 0).
• Hide Deleted — Toggle to exclude deleted or archived Opportunity records automatically (default true).
• Enable Operations Log — Enable to emit each write operation to a secondary 'Operations Log' output; not applicable for Get Many but available option.
• Output Fields — Assign fixed values or input fields to merge into every output item.

Output shape

a list of Opportunity records matching the query criteria

The node returns an array of Opportunity objects with requested fields. Supports pagination via the Limit parameter. The output field names reflect any user-defined renaming. Deleted or archived records are excluded by default unless overridden. The Operations Log output is not applicable for this read operation.

Examples

Example 1: Fetch up to 50 active Opportunity records with specific fields

Set Authentication to Enterprise Credentials, Fields to ['id','name','status'], Limit to 50, and Where Clause to "status = 'Active'" with Hide Deleted enabled.

Links

• n8n community nodes installation guide