Forum for users and developers of Bullhorn's API service.
Moderators: StaffingSupport, s.emmons, BullhornSupport
- Posts: 8
- Joined: Tue Aug 12, 2014 7:13 pm
I'm trying to get a list of ClientContacts for a given ClientCorporation, using the following code:
Code: Select all
Dim service = New BullhornAPI.ApiServiceClient()
Dim currentsession = service.startSession("<username>", "<password>", "<key>").session
Dim query2 As BullhornAPI.dtoQuery = New BullhornAPI.dtoQuery
query2.entityName = "ClientContact"
query2.where = "clientCorporation.ID = 1"
Dim bhcontacts As New BullhornAPI.apiQueryResult
bhcontacts = service.query(currentsession, query2)
... but when I run it I get the following error: "-99999: org.hibernate.QueryException: could not resolve property: ID of: com.bullhorn.entity.client.ClientCorporation [SELECT a.id FROM com.bullhorn.entity.client.ClientContact a WHERE clientCorporation.ID = 1]"
- Posts: 67
- Joined: Thu Feb 20, 2014 4:52 pm
The properties in the query are case sensitive. The id column on the ClientCorporation entity should be in lower case.