I am trying to get all customers from QuickBooks 2013 Premier Edition using QBWebConnector. My request QBXML is as follows
string strRequestXML = ""; XmlDocument inputXMLDoc = null; inputXMLDoc = new XmlDocument(); inputXMLDoc.AppendChild(inputXMLDoc.CreateXmlDeclaration("1.0", null, null)); inputXMLDoc.AppendChild(inputXMLDoc.CreateProcessingInstruction("qbxml", "version=\"4.0\"")); XmlElement qbXML = inputXMLDoc.CreateElement("QBXML"); inputXMLDoc.AppendChild(qbXML); XmlElement qbXMLMsgsRq = inputXMLDoc.CreateElement("QBXMLMsgsRq"); qbXML.AppendChild(qbXMLMsgsRq); qbXMLMsgsRq.SetAttribute("onError", "stopOnError"); XmlElement customerQueryRq = inputXMLDoc.CreateElement("CustomerQueryRq"); qbXMLMsgsRq.AppendChild(customerQueryRq); customerQueryRq.SetAttribute("requestID", "whatever"); strRequestXML = inputXMLDoc.OuterXml; req.Add(strRequestXML); Above is my buildRequest Method from WebService , However I am not getting any errors , status is QBWebConnector is OK but doesnot see the response . Here is the log
20160117.21:51:42 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : updateWS() for application = 'HTTPWebService' has STARTED 20160117.21:51:42 UTC : QBWebConnector.RegistryManager.getUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock = FALSE 20160117.21:51:42 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to True 20160117.21:51:42 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session locked ********************* 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : Initiated connection to the following application. 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppName: HTTPWebService 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppUniqueName (if available): HTTPWebService 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.instantiateWebService() : AppURL: http://localhost/WCWebService/WCWebService.asmx 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_serverVersion() : *** Calling serverVersion(). 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_serverVersion() : Received from serverVersion() following parameter:<serverVersionRet="2.0.0.1"> 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_clientVersion() : *** Calling clientVersion() with following parameter:<productVersion="2.2.0.34"> 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_clientVersion() : Received from clientVersion() following parameter:<clientVersionRet=""> 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_clientVersion() : This application agrees with the current version of QBWebConnector. Allowing update operation. 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_authenticate() : Authenticating to application 'HTTPWebService', username = 'username' 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_authenticate() : *** Calling authenticate() with following parameters:<userName="username"><password=<MaskedForSecurity> 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.updateWS() : Received from authenticate() following parameters:<authRet[0]="e8c16e62-7395-469b-9e8d-ed491b2a578c"><authRet[1]="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks 2015\Sample_Premier_ProductBased.QBW"><authRet[2]=""><authRet[3]=""> 20160117.21:51:42 UTC : QBWebConnector.RegistryManager.setCurrentWebServiceName() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\CurrentWebServiceName has been set to HTTPWebService 20160117.21:51:42 UTC : QBWebConnector.RegistryManager.setCurrentWebServiceSessionTicket() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\CurrentWebServiceSessionTicket has been set to e8c16e62-7395-469b-9e8d-ed491b2a578c 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.CheckCFNResponse() : User authenticated. 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.do_authenticate() : Done. 20160117.21:51:42 UTC : QBWebConnector.SOAPWebService.OpenConnection() : Connecting to QuickBooks... 20160117.21:51:43 UTC : QBWebConnector.SOAPWebService.OpenConnection() : Connected., Session started 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="s...... 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <CompanyQueryRs requestID="1" ...... 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.getLock() : Got Lock = UNLOCKED:GHAZANFAR 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.IsLocked() : Lock = UNLOCKED. Returning false. 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="s...... 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <DataExtModRs requestID="1" st...... 20160117.21:51:43 UTC : QBWebConnector.CompanyFileLock.setLock() : Lock has been set to value = <LOCKED:GHAZANFAR:635886643033561787> in QuickBooks for ownerID = <{87EDAAF8-637E-4203-867F-4BA79C2F8998}> 20160117.21:51:44 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="s...... 20160117.21:51:44 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <CompanyQueryRs requestID="1" ...... 20160117.21:51:44 UTC : QBWebConnector.CompanyFileLock.getLock() : Got Lock = LOCKED:GHAZANFAR:635886643033561787 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.update() : Company file has been locked for update. 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.update() : Synchronizing with QuickBooks Company Name = Roving Auto Parts Pro 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : Asking application to send request no. 1 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : *** Calling sendRequestXML() with following parameters: 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : wcTicket="e8c16e62-7395-469b-9e8d-ed491b2a578c" 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : HCPResponseXML= 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <HostQueryRs requestID="0" sta...... 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : cfn="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks 2015\Sample_Premier_ProductBased.QBW" 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : qbNationality="US" 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : qbXMLMajorVers="13" 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : qbXMLMinorVers="0" 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : Received from sendRequestXML() following parameter: 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : strRequestXML = 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="4.0"?><QBXML><QBXMLMsgsRq onError="st...... 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.do_sendRequestXML() : Request xml received. 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.ProcessRequestXML() : Processing request #1 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.ProcessRequestXML() : REQUEST: received from application: size (bytes) = 148 20160117.21:51:44 UTC : QBWebConnector.SOAPWebService.ProcessRequestXML() : Sending request to QuickBooks. 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.ProcessRequestXML() : Response received from QuickBooks: size (bytes) = 107502 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.ProcessRequestXML() : Sending response back to application. 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : *** Calling receiveResponseXML() with following parameters: 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : wcTicket="e8c16e62-7395-469b-9e8d-ed491b2a578c" 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : response = 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <CustomerQueryRs requestID="wh...... 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : hresult="" 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : message="" 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : Received from receiveResponseXML() following parameters: 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : more="100"> 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_receiveResponseXML() : Done. No more to process. 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="s...... 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <CompanyQueryRs requestID="1" ...... 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.getLock() : Got Lock = LOCKED:GHAZANFAR:635886643033561787 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: - <?xml version="1.0"?><?qbxml version="13.0"?><QBXML><QBXMLMsgsRq onError="s...... 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.Send_DataExtModRqXML() : XML dump follows: - <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <DataExtModRs requestID="1" st...... 20160117.21:51:45 UTC : QBWebConnector.CompanyFileLock.unsetLock() : Company file has been unlocked for ownerID = <{87EDAAF8-637E-4203-867F-4BA79C2F8998}> 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.update() : Company file has been unlocked. 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.update() : Ending session to QuickBooks. 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.DisconnectFromQB() : Session ended and connection closed 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_closeConnection() : *** Calling closeConnection() with following parameter:<wcTicket="e8c16e62-7395-469b-9e8d-ed491b2a578c"> 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_closeConnection() : Received from closeConnection() following parameter:<ccResponse="OK"> 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_closeConnection() : CloseConnection called to application. 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.do_closeConnection() : Response received from application = OK 20160117.21:51:45 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20160117.21:51:45 UTC : QBWebConnector.RegistryManager.setUpdateLock() : ********************* Update session unlocked ********************* 20160117.21:51:45 UTC : QBWebConnector.SOAPWebService.update() : update completed. 20160117.21:51:45 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : Update for application = 'HTTPWebService' has COMPLETED 20160117.21:51:45 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : Update session has ended. Need help What I am doing wrong?
No comments:
Post a Comment