如何实现Node.js与QuickBooks Desktop集成？无官方SDK场景方案咨询

Got it, integrating Node.js with QuickBooks Desktop can feel a bit frustrating since Intuit doesn't offer an official SDK for this specific stack. But don't worry—there are proven approaches using QuickBooks' native protocols and community tools that get the job done. Let me walk you through the most reliable methods:

Method 1: QBXML + QuickBooks Web Connector (Official Supported Approach) #

This is the go-to method recommended by Intuit for Desktop integrations. It uses QBXML (QuickBooks' XML-based data exchange format) and the QuickBooks Web Connector (a desktop tool that acts as a bridge between your Node.js service and QuickBooks Desktop).

Step 1: Understand QBXML #

QBXML is how QuickBooks Desktop reads and writes data. You'll need to craft XML requests for actions like querying customers, creating invoices, or updating vendors. Intuit's official docs list all valid QBXML messages and their structure for your specific QuickBooks version.

Step 2: Set Up the QuickBooks Web Connector #

Download and install the Web Connector from Intuit's site. You'll also need a QWC (QuickBooks Web Connector) configuration file that tells the connector how to talk to your Node.js service. Here's a sample QWC file:

<?xml version="1.0" encoding="utf-8"?>
<QBWCXML>
  <AppName>My Node.js QBD Sync</AppName>
  <AppURL>http://localhost:3000/qwc-soap</AppURL>
  <AppDescription>Syncs data between Node.js and QuickBooks Desktop</AppDescription>
  <UserName>your-service-username</UserName>
  <OwnerID>{YOUR-UNIQUE-OWNER-ID}</OwnerID>
  <FileID>{YOUR-UNIQUE-FILE-ID}</FileID>
  <QBType>QBFS</QBType>
  <Scheduler>
    <RunEveryNMinutes>15</RunEveryNMinutes>
  </Scheduler>
  <IsReadOnly>false</IsReadOnly>
</QBWCXML>

Import this QWC file into the Web Connector, and enter the matching password you'll define in your Node.js service.

Step 3: Build a Node.js SOAP Service #

The Web Connector communicates via SOAP, so you'll need to create a SOAP endpoint in Node.js that handles its required methods (like authenticate, sendRequestXML, and receiveResponseXML). Use the soap npm package to simplify this:

First, install dependencies:

npm install soap express

Then create your service:

const express = require('express');
const soap = require('soap');
const app = express();

// Define the SOAP service methods the Web Connector expects
const qwcService = {
  QBWebConnectorSvc: {
    QBWebConnectorSvcSoap: {
      // Handle authentication
      authenticate: (args) => {
        // Return [username, password, "", ""] to validate
        return {
          authenticateResult: ['your-service-username', 'your-service-password', '', '']
        };
      },
      // Send your QBXML request to QuickBooks
      sendRequestXML: (args) => {
        // Example: Query all active customers
        const qbxmlRequest = `<?xml version="1.0" encoding="utf-8"?>
        <?qbxml version="13.0"?>
        <QBXML>
          <QBXMLMsgsRq onError="stopOnError">
            <CustomerQueryRq>
              <ActiveStatus>ActiveOnly</ActiveStatus>
            </CustomerQueryRq>
          </QBXMLMsgsRq>
        </QBXML>`;
        return { sendRequestXMLResult: qbxmlRequest };
      },
      // Process the response from QuickBooks
      receiveResponseXML: (args) => {
        console.log('QuickBooks Response:', args.response);
        // Parse the XML response here (use a library like xml2js if needed)
        return { receiveResponseXMLResult: 0 }; // 0 = success
      },
      // Required helper methods
      connectionError: (args) => {
        console.error('Connection Error:', args.errorMessage);
        return { connectionErrorResult: '' };
      },
      getLastError: () => ({ getLastErrorResult: '' }),
      closeConnection: () => ({ closeConnectionResult: '' })
    }
  }
};

// Use the official QB Web Connector WSDL (save it locally or reference the official URL)
const wsdlPath = './qbwebconnector.wsdl';

// Start the SOAP endpoint
soap.listen(app, '/qwc-soap', qwcService, wsdlPath);

app.listen(3000, () => {
  console.log('QWC SOAP service running on http://localhost:3000/qwc-soap');
});

Method 2: Community-Maintained NPM Packages #

To avoid writing raw QBXML manually, use community packages that simplify request/response handling:

• qbd-xml: Generates valid QBXML from JavaScript objects, and parses responses back into objects. Install with npm install qbd-xml.
  Example usage:

  const qbdXml = require('qbd-xml');
  
  // Generate a customer query request
  const customerQuery = qbdXml({
    type: 'CustomerQueryRq',
    payload: { ActiveStatus: 'All' }
  });
  
  console.log(customerQuery); // Outputs formatted QBXML
  

• xml2js: Parses the raw XML responses from QuickBooks into easy-to-use JavaScript objects.

Key Things to Remember #

• QBXML Version: Match the QBXML version to your QuickBooks Desktop release (e.g., QB 2023 uses version 13.0). Check Intuit's docs for the correct version.
• Permissions: In QuickBooks, enable access for the Web Connector and grant the necessary data permissions (e.g., read/write for customers).
• Security: Never hardcode credentials—use environment variables or encrypted storage. If your service is public, use HTTPS for the SOAP endpoint.
• Error Handling: Add logic to catch invalid QBXML responses, authentication failures, and connection issues.

内容的提问来源于stack exchange，提问作者Vimal Sharma