Sourcier Query icon

Sourcier Query

Execute queries against Bullhorn with visual query builder and nested logic groups

Sourcier Query

AI-generated

Summary

Execute a Bullhorn query to retrieve records matching specified criteria using either a visual query builder, raw JSON, or a dynamic expression.

Inputs

  • Authentication (required) — Choose between User Credentials (email & password) or Enterprise Credentials (API key) for Sourcier authentication.
  • Input Mode (required) — Select how to provide the query: via visual Query Builder, JSON Editor, or Expression mode.
  • Entity — Select the Bullhorn entity to query when using Query Builder mode (ignored in other input modes). For custom entities, specify the entity name.
  • Top Level Logic — Specify how to combine top-level conditions and groups: either all must match (AND) or any can match (ANY).
  • Conditions — Define simple filter conditions at the top level when using Query Builder mode.
  • Condition Groups — Define nested groups of conditions with their own AND/OR logic for complex filters when using Query Builder mode.
  • Fields to Return — Comma-separated list of fields to include in the returned results when using Query Builder mode.
  • Sort By and Sort Direction — Specify a field to sort by and sort direction (ascending or descending) when using Query Builder mode.
  • Limit and Offset — Control pagination with the maximum number of results to return (1-500) and number of records to skip.
  • Query JSON (required) — Provide a complete BullhornQuery JSON object when Input Mode is JSON Editor.
  • Query Expression (required) — Provide a JSON expression evaluating to a BullhornQuery object when Input Mode is Expression.
  • Options — Additional options including whether to validate the query only without execution, include translation info, include generated JSON, and choose whether to split results into separate output items.

Output shape

a list of matching records from Bullhorn, each as a separate output item if 'Split Results' is true, or a single item with an array of results otherwise.

Output items include fields specified by the query. Metadata about total count and pagination are included in _meta for split results or as top-level properties otherwise. If 'Validate Only' is enabled, output indicates validation success or errors without executing the query.

Examples

Example 1: Visual Query Builder: Find active Candidates added within last 30 days

Select Entity 'Candidate', set conditions for 'status equals Active' and 'dateAdded within_last 30d', specify fields 'id,firstName,lastName,email', set limit to 50.

Example 2: JSON Editor: Execute a raw BullhornQuery JSON

Paste or enter a complete BullhornQuery JSON object defining entity, where clause, fields, and pagination.

Example 3: Expression Mode: Use a dynamic expression to define the query

Provide an expression that evaluates to a BullhornQuery object, e.g., from previous node data.

Links

Discussion