BullhornHub Query
AI-generatedSummary
Execute queries against Bullhorn entities using a flexible query interface that supports a visual query builder, raw JSON input, or expressions. Return matching records with options for pagination, sorting, and output format.
Inputs
- Authentication — Select authentication method: User Credentials (email and password) or Enterprise Credentials (API Key). Defaults to Enterprise.
- Input Mode (required) — Choose how to provide the query: visual query builder, complete BullhornQuery JSON, or expression evaluating to BullhornQuery object.
- Entity (required) — Select the Bullhorn entity to query when using Query Builder mode; choose from predefined entities or specify a custom entity name.
- Match (Top-level Logic) — Specify how to combine multiple top-level conditions/groups with AND (all must match) or ANY (any must match) logic.
- Conditions — Define one or more simple conditions on fields with comparison operators.
- Condition Groups — Define nested condition groups with their own AND/OR logic for complex filtering.
- Fields to Return — Comma-separated list of fields to return in results (applicable only in Query Builder mode). Defaults to id,firstName,lastName,email.
- Sort By — Field name to sort results by (optional).
- Sort Direction — Sort order: ascending or descending. Defaults to descending.
- Limit — Maximum number of results to return, with a maximum of 500. Defaults to 50.
- Offset — Number of results to skip, useful for pagination. Defaults to 0.
- Options — Additional options including: include translation info in output, include generated query JSON in output, split each result into separate items or return all in one, and validate query without execution.
- Query JSON (required) — Complete BullhornQuery JSON object specifying entity, filter conditions, fields, pagination, etc. Used when Input Mode is JSON Editor.
- Query Expression (required) — Expression that evaluates to a BullhornQuery JSON object. Used when Input Mode is Expression.
Output shape
a list of matching Bullhorn records as separate items if 'Split Results' is true; otherwise all results in one item with metadata
Each output item contains the queried record's data fields. Metadata including count, start, total, and optionally translation and the query JSON are included depending on options. If no results, output a single item flagged with _noResults:true. Query validation errors or execution errors throw node operation errors.