Sourcier AdvancedInstall

Summary

Retrieve multiple Placement records from Bullhorn using a JPQL WHERE clause filter, specifying the fields to return and limiting the number of records.

Inputs

• Authentication (required) — Select whether to authenticate with User Credentials (Email & Password) or Enterprise Credentials (API Key).
• Fields (required) — Specify which Bullhorn fields of the Placement entity to return for each record; optionally rename output fields.
• Limit — Maximum number of Placement records to return, between 1 and 500; defaults to 20.
• Where Clause (required) — JPQL WHERE clause to filter Placement entities (e.g., "id > 0").
• Hide Deleted — Whether to automatically exclude deleted or archived Placement records; defaults to true.
• Enable Operations Log — If enabled, emits an audit log entry for this read operation on a second output.
• Output Fields — Additional fields to include in every output item, merged into results regardless of success or failure.

Output shape

a list of Placement records matching the where clause, each including the requested fields potentially renamed as specified

The operation uses JPQL filtering at the API level with automatic exclusion of deleted or archived records when enabled. Result count is limited as specified with a maximum of 500 records returned. If 'Enable Operations Log' is turned on, an audit log entry is emitted via a second output channel. Field renaming is applied in the output as configured.

Examples

Example 1: Get active Placements with id over 100

Set 'Where Clause' to "id > 100 AND status = 'Active'", select desired fields, set Limit to 50, and optionally enable 'Hide Deleted' to true to exclude archived records.

Links

• n8n community nodes installation guide