Members of a Distribution List

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
DaveNorthCreek
User
Posts: 89
Joined: Fri Nov 20, 2015 2:04 pm

Members of a Distribution List

Post by DaveNorthCreek » Tue May 15, 2018 4:57 pm

Hi Bullhorn peeps!

My client wants to integrate with an email campaign manager, so that instead of emailing directly from within Bullhorn, he creates a distribution list and then kicks off an email campaign to everyone in the list.

I only have REST API access to his installation. Can I:
1) retrieve all distribution lists
2) retrieve the candidates (email addresses, names) that are on a specific distribution list
3) be notified when a list is "done" through some sort of trigger?

I am planning to circumvent (3) by building a separate UI that lists all relevant distribution lists, allows users to choose one, then kicks off the transfer process. The client does not want to go through csv export/csv import for every distribution event.

Any ideas / help is welcome!

Dave Block
North Creek Consulting, Inc.

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

Re: Members of a Distribution List

Post by pmularski » Fri May 18, 2018 11:26 am

Greetings Dave,

The tables you should be pulling are the BH_DistributionList and the associated BH_DistributionListMember table. The DistributionList table should be available, despite not being visible in the documentation.

-Pat
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

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

Re: Members of a Distribution List

Post by DaveNorthCreek » Wed May 23, 2018 3:27 pm

The client has decided to use the recommended 'Hotlist' entity type to export his list of candidates. Is that accessible through the REST API, and is it documented anywhere? I have the BullhornRESTAPI_0_2.pdf file, and the link to the online documentation:
http://bullhorn.github.io/rest-api-docs/entityref.html
But there is no mention of distributionList or Hotlist in either of those resources.

I have also done a bunch of queries in Postman using variants of

https://restXX.bullhornstaffing.com/res ... n=redacted

where I tried DistributionList, Distribution_list, etc.

The result was:

Code: Select all

{
    "errorMessage": "Unknown or badly structured command: /meta/BH_DistributionList.",
    "errorMessageKey": "errors.badCommand"
}
or for Hotlist:

Code: Select all

{
    "errorMessage": "Unknown entity 'Hotlist'.",
    "errorMessageKey": "errors.unknownEntity",
    "errorCode": 404
}
So I have not achieved my client's objective yet.

Thanks for any pointers!
Dave
North Creek

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

Re: Members of a Distribution List

Post by DaveNorthCreek » Wed May 23, 2018 3:36 pm

...and a google search reveals that Hotlist is a synonym for Tearsheet, so we're off to the races!

Problem apparently solved.

Post Reply