search/Candidate?showTotalMatched=true&start=0&count=66&query=id:[* TO *]&fields=id,name,firstName,middleName,lastName,nickName,gender,status,owner,comments,dateLastComment,customText5,desiredLocations,companyName,dateAvailable,source,customText4,customText12,referredBy,dateOfBirth,ssn,customText11,customText6,email,phone,mobile,phone2,preferredContact,address,secondaryAddress,primarySkills,specialties,categories,certifications,customText1,customText7,customText10,customDate3,dateAdded,isDeleted&orderBy=+id
This is Mikaela from Bullhorn Support.
I would advise using something like the below:
I hope this helps. Please let me know if you have any additional questions.
I did that and it still doesn't give me all the records I need. Also, I had to use orderBy instead of sort and the max count I can get of candidates is 66. I have to run it multiple times, and with over 130,000 candidates this is not desirable. And even when I use orderBy, they aren't actually ordered by id.
Also, I tried specifically telling it which IDs I want but it appears to be a text search and not an actual ID search. For example, if I tell it I want IDs 1000 to 1100 it will bring back IDs 10500, 103000, etc.
All the other objects (jobOrder, jobSubmission, Placement, etc) I'm able to get fine but Candidate not so much.
Can you please send me the call you made based on my recommendation of the below? I would also recommend your order by dateadded rather than ID.