Issue getting data from user with apostrophe

Have a question about Bullhorn's HTTP based APIs? You've found the right place.

API Update [posted on December 13, 2012]:

This version of the Bullhorn APIs should no longer be used.

All new work should be done using Bullhorn's REST or Web Services APIs. For more information please visit: http://developer.bullhorn.com/documentation

Bullhorn REST API provides a simpler and faster way for developers to build applications that interact with the Bullhorn platform and is used by Bullhorn Inc. to develop features of the Bullhorn ATS/CRM application.

Of the BullhornSTAFFING HTTP API interfaces listed below, our analysis shows that the following are most commonly used by developers:

Resume Parsing API
Published Job Data (XML)
The interface to these will continue to work as is because Bullhorn will replace the back end to use REST API. The URLs for these 2 specific APIs may change in the 2nd half of 2013; developers may require to update their applications to use the new URLs.

Moderators: StaffingSupport, s.emmons

Locked
tbradley
User
Posts: 3
Joined: Wed Dec 31, 1969 8:00 pm

Issue getting data from user with apostrophe

Post by tbradley » Mon Dec 15, 2008 11:17 am

Greetings,

There appears to be a bug in a Bullhorn service:

The data i'm sending is Karen.D'Attanasio@Morganstanley.com
as
<customParam1 xsi:type="xsd:string">Karen.D&apos;Attanasio@Morganstanley.com</customParam1>


POST /bullhornstaffing/API/DataExport.cfc HTTP/1.1
Content-Type: text/xml; charset="utf-8"
SOAPAction: ""
Connection: close
Content-length: 977
Cache-Control: no-cache
Pragma: no-cache
User-Agent: Java/1.6.0_07
Host: http://www.bullhornstaffing.com
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body xmlns:impl="http://www.bullhornstaffing.com/bullhor ... Export.cfc">
<impl:Export xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<privateLabelID xsi:type="xsd:double">493</privateLabelID>
<apiEncryptionKey xsi:type="xsd:string">XXXXXXXXX</apiEncryptionKey>
<userID xsi:type="xsd:double">4973450</userID>
<reportID xsi:type="xsd:double">9120</reportID>
<startDate xsi:type="xsd:dateTime">1999-12-31T23:59:59</startDate>
<endDate xsi:type="xsd:dateTime">1999-12-31T23:59:59</endDate>
<includeExported xsi:type="xsd:boolean">false</includeExported>
<markAsExported xsi:type="xsd:boolean">false</markAsExported>
<status xsi:type="xsd:string" />
<customParam1 xsi:type="xsd:string">Karen.D&apos;Attanasio@Morganstanley.com</customParam1>
</impl:Export>
</soapenv:Body>
</soapenv:Envelope>







HTTP/1.1 500 Internal Server Error
Connection: close
Date: Fri, 12 Dec 2008 23:03:14 GMT
Server: Microsoft-IIS/6.0
Set-Cookie: CFID=1485218;domain=.bullhornstaffing.com;expires=Sun, 05-Dec-2038 23:03:21 GMT;path=/
Set-Cookie: CFTOKEN=849e13cad325a219-2D709C64-FC36-6651-B186280C9F83F63A;domain=.bullhornstaffing.com;expires=Sun, 05-Dec-2038 23:03:21 GMT;path=/
Content-Language: en-US
Content-Type: text/xml; charset=utf-8

<?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>coldfusion.xml.rpc.CFCInvocationException: [coldfusion.tagext.sql.QueryTag$DatabaseQueryException : Error Executing Database Query.][java.sql.SQLException : [Macromedia][SQLServer JDBC Driver][SQLServer]Line 19: Incorrect syntax near 'Attanasio@Morganstanley'.][java.sql.SQLException : [Macromedia][SQLServer JDBC Driver][SQLServer]Unclosed quotation mark before the character string '
AND a.recordTypeBits = 2
AND c.clientCorporationID = 174958'.]</faultstring>
<detail>
<ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/">coldfusion ... nException: [coldfusion.tagext.sql.QueryTag$DatabaseQueryException : Error Executing Database Query.][java.sql.SQLException : [Macromedia][SQLServer JDBC Driver][SQLServer]Line 19: Incorrect syntax near 'Attanasio@Morganstanley'.][java.sql.SQLException : [Macromedia][SQLServer JDBC Driver][SQLServer]Unclosed quotation mark before the character string '
AND a.recordTypeBits = 2
AND c.clientCorporationID = 174958'.]
at coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(CFComponentSkeleton.java:694)
at coldfusion.xml.rpc.CFComponentSkeleton.__invoke(CFComponentSkeleton.java:640)
at bullhornstaffing.API.DataExport.Export(C:\JRun4\servers\Bullhorn_3\cfusion-ear\cfusion-war\BullhornSTAFFING\API\DataExport.cfc)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at coldfusion.xml.rpc.CFCProvider.invoke(CFCProvider.java:54)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at coldfusion.xml.rpc.CFCServlet.doAxisPost(CFCServlet.java:163)
at coldfusion.filter.AxisFilter.invoke(AxisFilter.java:43)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:106)
at coldfusion.xml.rpc.CFCServlet.doPost(CFCServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.G(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
</ns1:stackTrace>
<ns2:hostname xmlns:ns2="http://xml.apache.org/axis/">webserver51</ns2:hostname>
</detail>
</soapenv:Fault>
</soapenv:Body>

jp.dowd
User
Posts: 164
Joined: Wed Dec 31, 1969 8:00 pm

Re: Issue getting data from user with apostrophe

Post by jp.dowd » Mon Dec 15, 2008 11:20 am

Hello,
Your message edited to remove the encrypted API key. Remember to take that out whenever you are posting code.

J.P.

jp.dowd
User
Posts: 164
Joined: Wed Dec 31, 1969 8:00 pm

Re: Issue getting data from user with apostrophe

Post by jp.dowd » Mon Dec 15, 2008 5:25 pm

Hello,
I have taken a look and there is a bug on the export side of the cfc. A patch has been created and submitted for review. I will keep you updated on the status. We will also post the changes/releases in an announcement in the API forum. This bug has a ticket number of 219237.

J.P.

tbradley
User
Posts: 3
Joined: Wed Dec 31, 1969 8:00 pm

Re: Issue getting data from user with apostrophe

Post by tbradley » Thu Mar 12, 2009 3:53 pm

We are working with private labels...when we send a job thru the API and direct to one of our Private Labels (VMS-MCSIBarra) the job ends up going into the wrong Private Label and the Wrong Job List (Morgan Stanley CWO). Also we are not able to see all the client side USERs in the company -- MSCI Barra thru the API

jp.dowd
User
Posts: 164
Joined: Wed Dec 31, 1969 8:00 pm

Re: Issue getting data from user with apostrophe

Post by jp.dowd » Thu Mar 12, 2009 4:56 pm

Hi,
Could you give an example of what you are posting? Often times items will post to the parent PL if it is set up that way. Remember to remove the PL key before posting anything.

J.P.

jp.dowd
User
Posts: 164
Joined: Wed Dec 31, 1969 8:00 pm

Re: Issue getting data from user with apostrophe

Post by jp.dowd » Thu Mar 12, 2009 5:29 pm

Also,
you may want to post this to a new thread. Hijacking threads with new topics can make it difficult for people to follow and find solutions in the future.


J.P.

Locked