FlowmageDocs

Search records

BetaReads dataVersion 2

Searches Bullhorn's index with a Lucene query.

Settings

SettingWhat it is
ConnectionRequiredThe Bullhorn connection the step signs in with.
EntityRequiredCandidate, ClientContact, ClientCorporation, JobOrder, Lead, Note, Opportunity, Placement, Task.
Lucene queryRequiredBullhorn's own search syntax, e.g. isOpen:true AND isDeleted:false.
FieldsRequiredThe fields you want back, comma-separated. Bullhorn no longer accepts * here.
Sort byA field name; put a minus in front to reverse it.
Records per call1 to 500. With Fetch every page on, this is the page size.
Skip recordsnumber
Fetch every pagePages with start until a short page, and refuses past 10,000 records rather than answering a short list.
CursorPaste a previous run's Next cursor to read the page after it.
Technical details
KeyValue
connectiontexta connection id from `requires.connections` (provider `bullhorn`)
entityTypetext
querytext
fieldstext
sorttext
countnumber, by default 100
startnumber, by default 0
returnAlltrue/false, by default false
cursortext

Output

FieldType
recordsarray
recordCountRecords in this answernumber
totalHow many Bullhorn found in totalnumber
hasMoreMore records are waiting behind this pageboolean
nextCursorCursor for the next pagestring
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>",
    "query": "<lucene query>",
    "returnAll": false,
    "sort": "",
    "start": 0
  },
  "label": "Search records",
  "type": "bullhorn.search",
  "version": 2
}

Older versions

A flow that already has this version keeps running it. A new step always gets the newest.

Version 1
SettingWhat it is
ConnectionRequiredThe Bullhorn connection the step signs in with.
EntityRequiredCandidate, ClientContact, ClientCorporation, JobOrder, Lead, Note, Opportunity, Placement, Task.
Lucene queryRequiredBullhorn's own search syntax, e.g. isOpen:true AND isDeleted:false.
FieldsRequiredThe fields you want back, comma-separated. Bullhorn no longer accepts * here.
Sort byA field name; put a minus in front to reverse it.
Records per call1 to 500. With Fetch every page on, this is the page size.
Skip recordsnumber
Fetch every pagePages with start until a short page, and refuses past 10,000 records rather than answering a short list.
Technical details
KeyValue
connectiontexta connection id from `requires.connections` (provider `bullhorn`)
entityTypetext
querytext
fieldstext
sorttext
countnumber, by default 100
startnumber, by default 0
returnAlltrue/false, by default false