we need an overview of the mapping between all database fieldnames and their corresponding UI labels.
We can get it manually in the UI via Menu/Admin/Field Mappings but the is too labour entinsive.
From the your support we got the query (below and attached) we should use, see attached.
But when we take the documentation, the only call we think is usable is http://bullhorn.github.io/rest-api-docs ... #get-query
But here we can't releae the query.
Can you help us out?
Happy to explain a little further in a Zoom meeting with our developer.
SELECT Top 4000
entity AS Entity,
columnName AS Field,
display AS Label,
isRequired AS isRequired,1
FROM BULLHORN11963.BULLHORN1.BH_FieldMapList a WITH (nolock)
WHERE privateLabelID = 18491
AND editType NOT LIKE 'System'
AND entity IN ('Candidate','Client','Client Contact','Job Posting','Job Posting II', 'Job Posting III', 'Job Posting IV', 'Job Posting V','Lead','Opportunity','Placement')
ORDER BY entity,sortOrder ASC
- BH query database veld vs UI label 20200406.txt
- (511 Bytes) Downloaded 97 times
My apologies for the delay in our response.
Have you had a member of the team reach out with the data pull you were looking to receive? If not, please let me know.
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
UK: 44 800 032 2848
Australia: 61 28 073 5089