Sourcier AdvancedInstall

Summary

Retrieve multiple Appointment records from Bullhorn using a JPQL WHERE clause to filter results, specifying desired fields, and controlling record limit and exclusion of deleted records.

Inputs

• Authentication — Choose between User Credentials (Email & Password) or Enterprise Credentials (API Key) for authenticating with Bullhorn.
• Enable Operations Log — Optionally emit an audit log for each write operation (not applicable for this read operation).
• Fields (required) — Specify which Bullhorn Appointment entity fields to return. You can rename fields in the output by setting an Output Name or leave empty to retain original field names.
• Limit — Maximum number of Appointment records to return, from 1 up to 500, defaulting to 20.
• Where Clause (required) — JPQL WHERE clause to filter Appointment records (e.g., "id > 0 AND status = 'Active'"), must be provided by the user.
• Hide Deleted — Automatically exclude deleted or archived Appointment records by adding appropriate filtering to the query; true by default.
• Output Fields — Static or variable fields merged into every output item as additional output data.

Output shape

a list of Appointment records matching the where clause

The operation returns an array of Appointment objects with only the specified fields. The records returned respect the limit parameter and exclude deleted records if 'Hide Deleted' is enabled. No pagination is implemented, so the maximum number returned is limited by the 'Limit' parameter.

Links

• n8n community nodes installation guide