Get All Customers from QuickBook using Web Connector and qbxml

Question

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:
20160117.21:51:42 UTC   : QBWebConnector.SOAPWebService.do_clientVersion() : *** Calling clientVersion() with following parameter:
20160117.21:51:42 UTC   : QBWebConnector.SOAPWebService.do_clientVersion() : Received from clientVersion() following parameter:
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:
20160117.21:51:42 UTC   : QBWebConnector.SOAPWebService.updateWS() : Received from authenticate() following parameters:
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: -







 in QuickBooks for ownerID = <{87EDAAF8-637E-4203-867F-4BA79C2F8998}>
20160117.21:51:44 UTC   : QBWebConnector.CompanyFileLock.Send_CompanyQueryRqXML() : XML dump follows: -











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: -








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:
20160117.21:51:45 UTC   : QBWebConnector.SOAPWebService.do_closeConnection() : Received from closeConnection() following parameter:
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.

Edit Posting code :

public ArrayList buildRequest() 
    {
        //Get All Customer Query
        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);

        // Clean up
        strRequestXML="";
        inputXMLDoc=null;
        qbXML=null;
        qbXMLMsgsRq=null;
        //maxReturned=null;
        return req;
    }


public string sendRequestXML(string ticket, string strHCPResponse, string strCompanyFileName, 
        string qbXMLCountry, int qbXMLMajorVers, int qbXMLMinorVers)
    {
        if (Session["counter"] == null) {
            Session["counter"] = 0;
        }
        string evLogTxt="WebMethod: sendRequestXML() has been called by QBWebconnector" + "

";
        evLogTxt=evLogTxt+"Parameters received:
";
        evLogTxt=evLogTxt+"string ticket = " + ticket + "
";
        evLogTxt=evLogTxt+"string strHCPResponse = " + strHCPResponse + "
";
        evLogTxt=evLogTxt+"string strCompanyFileName = " + strCompanyFileName + "
";
        evLogTxt=evLogTxt+"string qbXMLCountry = " + qbXMLCountry + "
";
        evLogTxt=evLogTxt+"int qbXMLMajorVers = " + qbXMLMajorVers.ToString() + "
";
        evLogTxt=evLogTxt+"int qbXMLMinorVers = " + qbXMLMinorVers.ToString() + "
";
        evLogTxt=evLogTxt+"
";

        ArrayList req=buildRequest();
        string request="";
        int total = req.Count;
        count=Convert.ToInt32(Session["counter"]);

        if(count
    /// WebMethod - receiveResponseXML()
    /// Signature: public int receiveResponseXML(string ticket, string response, string hresult, string message)
    /// 
    /// IN: 
    /// string ticket
    /// string response
    /// string hresult
    /// string message
    ///
    /// OUT: 
    /// int retVal
    /// Greater than zero  = There are more request to send
    /// 100 = Done. no more request to send
    /// Less than zero  = Custom Error codes
    /// 
    public int receiveResponseXML(string ticket, string response, string hresult, string message)
    {
        string evLogTxt="WebMethod: receiveResponseXML() has been called by QBWebconnector" + "

";
        evLogTxt=evLogTxt+"Parameters received:
";
        evLogTxt=evLogTxt+"string ticket = " + ticket + "
";
        evLogTxt=evLogTxt+"string response = " + response + "
";
        evLogTxt=evLogTxt+"string hresult = " + hresult + "
";
        evLogTxt=evLogTxt+"string message = " + message + "
";
        evLogTxt=evLogTxt+"
";

        int retVal=0;
        if(!hresult.ToString().Equals("")){
            // if there is an error with response received, web service could also return a -ve int     
            evLogTxt=evLogTxt+ "HRESULT = " + hresult + "
";
            evLogTxt=evLogTxt+ "Message = " + message + "
";
            retVal=-101;
        }
        else{ 
            evLogTxt=evLogTxt+ "Length of response received = " + response.Length + "
";

            ArrayList req = buildRequest();
            int total=req.Count;
            int count=Convert.ToInt32(Session["counter"]);

            int percentage=(count*100)/total;
            if (percentage>=100){
                count=0;
                Session["counter"]=0;
            }
            retVal=percentage;
        }
        evLogTxt=evLogTxt+"
";
        evLogTxt=evLogTxt+"Return values: " + "
";
        evLogTxt=evLogTxt+"int retVal= " + retVal.ToString() + "
";
        logEvent(evLogTxt);
        return retVal;
    }

Here is my send and response methods . Problem is that how do I see the response of getting all customers , and How do I test response in browser ? If I want to test the the service in browser how do I do that ? I want to parse the response in C# classes and use it in my other app.

Keith Palmer Jr. · Accepted Answer

The response is being sent, successfully, to you in the receiveResponseXML(...) method. You can see this in the logs:

0160117.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: -

You neglected to post any of the relevant code, so it's going to be pretty tough to help you beyond that.

You should review how the Web Connector works. There's several hundred pages of documentation available in the QuickBooks SDK:

https://developer.intuit.com/docs/0250_qb/0020_get_set_up/sdk_downloads

Here's another summary:

http://www.consolibyte.com/docs/index.php/QuickBooks_Web_Connector_Overview

Regarding your added questions:

Problem is that how do I see the response of getting all customers

You can view it in the logs, or you can make your application save it to your database, and display it to you from there.

How do I test response in browser ?

You can't test it in the browser. It's a SOAP service, it has nothing to do with your web browser what-so-ever, in any way at all.

You will never see the XML response, or any data from it, directly in the browser using only the Web Connector.

You will need to parse the XML, store/cache it in your own database, and then you can display the cached/stored data in your own application however you want.

You can not display the response from the Web Connector directly in your browser -- you need to store it somewhere/somehow, and then display the data from whereever it's stored.

Get All Customers from QuickBook using Web Connector and qbxml

Answers (1)

Related Questions