BullhornQuery records
Reads Bullhorn records with a database-style where clause.
Settings
| Setting | What it is |
|---|---|
| ConnectionRequired | The Bullhorn connection the step signs in with. |
| EntityRequired | text |
| WhereRequired | Bullhorn's own JPQL where clause, e.g. id > 0 AND isOpen = true. |
| FieldsRequired | The fields you want back, comma-separated. Bullhorn no longer accepts * here. |
| Order by | text |
| Total only | true/false |
| Records per call | 1 to 500. |
| Skip records | number |
| Fetch every page | Pages with start until a short page, and refuses past 10,000 records. |
| Cursor | Paste a previous run's Next cursor to read the page after it. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `bullhorn`) |
entityType | text |
where | text |
fields | text |
orderBy | text |
totalOnly | true/false, by default false |
count | number, by default 100 |
start | number, by default 0 |
returnAll | true/false, by default false |
cursor | text |
Output
| Field | Type |
|---|---|
records | array |
recordCountRecords in this answer | number |
totalHow many Bullhorn counted | number |
hasMoreMore records are waiting behind this page | boolean |
nextCursorCursor for the next page | string |
Sample output, and the expression for each field
- hasMorefalse
- recordCount0
- records[]
- total0
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"connection": "<connection id>",
"count": 100,
"cursor": "",
"entityType": "<entity>",
"fields": "<fields>",
"orderBy": "",
"returnAll": false,
"start": 0,
"totalOnly": false,
"where": "<where>"
},
"label": "Query records",
"type": "bullhorn.query",
"version": 2
}Older versions
A flow that already has this version keeps running it. A new step always gets the newest.
Version 1
| Setting | What it is |
|---|---|
| ConnectionRequired | The Bullhorn connection the step signs in with. |
| EntityRequired | text |
| WhereRequired | Bullhorn's own JPQL where clause, e.g. id > 0 AND isOpen = true. |
| FieldsRequired | The fields you want back, comma-separated. Bullhorn no longer accepts * here. |
| Order by | text |
| Total only | true/false |
| Records per call | 1 to 500. |
| Skip records | number |
| Fetch every page | Pages with start until a short page, and refuses past 10,000 records. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `bullhorn`) |
entityType | text |
where | text |
fields | text |
orderBy | text |
totalOnly | true/false, by default false |
count | number, by default 100 |
start | number, by default 0 |
returnAll | true/false, by default false |