Actions87
- Appointment Actions
- Candidate Actions
- Company Actions
- Contact Actions
- File Actions
- Job Actions
- Job Submission Actions
- Lead Actions
- Note Actions
- Opportunity Actions
- Placement Actions
- Sendout Actions
- Task Actions
- Tearsheet Actions
Appointment → Query
AI-generatedSummary
Execute a JPQL WHERE clause to retrieve Appointment records, with optional field renaming and pagination.
Inputs
- Authentication (required) — Credentials type: User Credentials (Email & Password) or Enterprise Credentials (API Key).
- Where Clause (required) — JPQL WHERE clause (e.g., id > 100 AND status = 'Active').
- Limit — Maximum number of records to return (default: 20, max: 500).
- Fields — Bullhorn fields to return. Set an Output Name to rename in the output, or leave empty to use the Bullhorn field name.
- Hide Deleted — Whether to automatically exclude deleted/archived records (adds isDeleted=false).
- Output Fields — Fields to include in every output item (merged into results, no-results, and error items).
Output shape
A list of items, each containing the requested Appointment fields.
Uses JPQL WHERE syntax. The node automatically excludes soft-deleted records (isDeleted=false) for most entities, but not for ClientCorporation or Placement. Results are paginated based on the Limit parameter.
Examples
Example 1: Find active appointments for a specific company.
Where Clause: companyURL = 'https://example.com' AND status = 'Active'; Limit: 50
Example 2: Retrieve the last 10 appointments created within the last 30 days.
Where Clause: dateAdded >= '30d'; Limit: 10; Fields: id, title, dateAdded, status