How do I fetch complete data of a table from Rest API

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
Vandna
User
Posts: 3
Joined: Thu Nov 28, 2019 5:22 am

How do I fetch complete data of a table from Rest API

Post by Vandna » Thu Nov 28, 2019 5:33 am

Hi Team,

I want to fetch complete data present in all the tables for my client for reporting purpose.
Could anyone please suggest me a way of doing it.
I have a ticket opened fro the same: 03870104.

I am able to connect to rest APi and fetch data based on candidate Ids using Postman, but my requirement is quite different from this.
I have checked the following documents bus was not able to find any thing:
http://bullhorn.github.io/Exploring-the ... h-PostMan/
http://bullhorn.github.io/Getting-Started-with-REST/
http://bullhorn.github.io/rest-api-docs/#entity

Please suggest me a way of doing it.

agrossman
User
Posts: 10
Joined: Thu Jul 19, 2018 12:21 pm

Re: How do I fetch complete data of a table from Rest API

Post by agrossman » Mon Dec 02, 2019 1:50 pm

Hi Vanda,

Exporting all data across all tables would not be possible nor supported by Bullhorn. Alternatively, we would recommend having your client request a standard backup, which they are entitled to for free once a month. This will be a .bak file with all of their data.

Please let me know if you have any questions!
Alice Grossman
Enterprise Support Analyst
B U L L H O R N

Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

Vandna
User
Posts: 3
Joined: Thu Nov 28, 2019 5:22 am

Re: How do I fetch complete data of a table from Rest API

Post by Vandna » Tue Dec 03, 2019 10:18 am

Hi Team,

Thank you for your response.
Backup will not solve my problem as we need reporting dashboard to reflect real time values.
Could you please suggest me an alternative way of doing this.

agrossman
User
Posts: 10
Joined: Thu Jul 19, 2018 12:21 pm

Re: How do I fetch complete data of a table from Rest API

Post by agrossman » Wed Dec 04, 2019 6:27 pm

Hi Vandna,

Some of our clients have purchased Data Mirror, which is a data replication product and allows for real time access to the data in the database for reporting or backup purposes. You are certainly welcome to pull data via API, but it is not possible to pull all data from all tables.
Alice Grossman
Enterprise Support Analyst
B U L L H O R N

Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

Vandna
User
Posts: 3
Joined: Thu Nov 28, 2019 5:22 am

Re: How do I fetch complete data of a table from Rest API

Post by Vandna » Mon Dec 09, 2019 4:59 am

Hi Team,

In below link
https://rest42.bullhornstaffing.com/res ... =dateAdded:[20000101060000 TO 20191209045959]&fields=*
I would like to replace end date with system's date or Today so that we can always fetch records dynamically to the current date.
Can you please suggest, How can we do this?

Post Reply