Get candidates with dateAdded after specific date 02543170

Forum for users and developers of Bullhorn's new REST API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

DrJones
User
Posts: 15
Joined: Sat Dec 12, 2015 1:20 pm

Get candidates with dateAdded after specific date 02543170

Postby DrJones » Wed Dec 23, 2015 11:47 am

All I'm trying to do is retrieve candidates that have been added after a specific date and time. So I'm using the search API call which takes a lucene query. The sample URI from the documentation is below.

{corpToken}/search/{entityType}?query={luceneQueryString}&fields={fieldList}&sort={fieldList} &count={count}&start={start}

My lucene query is "dateAdded:[{datetime} TO *]". However, I'm not sure of the format that is expected for the datetime. Through lots of trial and error I've been able to get it to work correctly based on the date values using the format "yyyyMMdd". However, I don't know the format for the time component of the date. So I can get candidates added after 12/6/2015. But I can't get candidates accurately for 12/6/2015 9:27:00PM. Is it possible to include the time? If so, what format is expected?

DaveNorthCreek
User
Posts: 71
Joined: Fri Nov 20, 2015 2:04 pm

Re: Get candidates with dateAdded after specific date

Postby DaveNorthCreek » Mon Jan 11, 2016 3:07 pm

There is a related question on the board now, and I suggested using an event subscription. If your lucene query works, can you sort by dateAdded? That might get you an ordered list that you can do something with.

I'm going to post your query example for AndyRoper's question titled "Candidate who have been updated in the last week (or many day)".

If you get something working, please let us know!

Cheers,
Dave
North Creek

srg.bdavis
User
Posts: 58
Joined: Thu Feb 20, 2014 4:52 pm

Re: Get candidates with dateAdded after specific date

Postby srg.bdavis » Tue Jan 12, 2016 9:45 pm

DrJones,

I'd have to run a test against our api to be 100% certain, but it should accept the format of yyymmddT00:00:00. In your example the query would be dateAdded:[20151206T21:27:00 TO *].

Regards,
Brent
**** No longer accurate. This post was updated by Bullhorn Support. Please see later posts for up to date formatting.****

ArunrajM
User
Posts: 3
Joined: Tue Jul 04, 2017 1:25 pm

Re: Get candidates with dateAdded after specific date

Postby ArunrajM » Mon Jul 10, 2017 8:05 am

I am using your date format with time.but bullhorn api doesnt consider time.
So the issue is still exist.
Can i get any other help .

Regards,
Arunraj M

pmularski
Bullhorn Support Staff
Posts: 880
Joined: Wed Dec 31, 1969 8:00 pm

Re: Get candidates with dateAdded after specific date

Postby pmularski » Thu Jul 13, 2017 12:05 pm

Hello ArunrajM,

Would you please post your API request?
Patrick Mularski
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

lplumley
User
Posts: 1
Joined: Mon Jul 04, 2016 8:27 am

Re: Get candidates with dateAdded after specific date 02543170

Postby lplumley » Wed Aug 30, 2017 11:14 am

You can add the time component in the same was the date: yyyymmddhhmmssms (where ms = milliseconds)
So for example 15:30:05.25 on the 30th of August would be: 2017083015300525

The format yyymmddThh:mm:ss is accepted for the /query operation (which expects Java Persistence Language (JPQL)), whereas the /search operation expects Lucene query syntax.


Return to “REST API”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron