DBSync QBO Error - QuickBooksRestV3Adapter Error Parsing Query (QueryParseError)

1. Summary / Introduction

This article describes how to troubleshoot query parsing errors in DBSync when retrieving data from QuickBooks Online (QBO). These errors occur when the SQL query configured in a QuickBooks Online Query Step contains invalid or malformed syntax that does not comply with the QuickBooks Query Language format. When the query cannot be parsed, DBSync cannot retrieve records from the specified QuickBooks Online object, causing the workflow task to fail.

Common error messages associated with this issue include:

QuickBooksRestV3Adapter Error parsing query QueryParseError: Encountered

QBRestV3Reader Error while parsing query statement

QBRestV3Reader Unable to get records count from Intuit:

2. Problem / Issue

Synchronization fails when DBSync executes a QuickBooks Online Query Step containing an invalid query. During workflow execution, DBSync sends the configured query to QuickBooks Online to retrieve records from the specified object. If the query syntax is invalid, QuickBooks Online rejects the request and returns a query parsing error.

When this occurs, the Query Step fails and the workflow cannot retrieve records. As a result, subsequent steps in the workflow cannot process data, causing the synchronization task to stop.

Example error observed in logs:

QuickBooksRestV3Adapter Error parsing query

QueryParseError: Encountered "<INTEGER> "2026"" at line 1, column 56

3. Environment / Applies To

Product / Service: DBSync Cloud Workflow Connector: Intuit QuickBooks Online

Versions: All supported DBSync versions

4. Symptoms

Users may observe the following behavior:

• The QuickBooks Online Query Step fails during workflow execution.

• No records are retrieved from the Query Step.

• DBSync logs contain query parsing errors related to the QuickBooks Online Query Step.

• Error messages in the logs may reference the failing workflow step using the format [Flow Step Name].

• Subsequent Transform or Write steps fail because no records are returned from the Query Step.

5. Root Cause

The issue occurs when the SQL query configured in the DBSync QuickBooks Online Query Step contains invalid or malformed syntax that does not comply with the QuickBooks Query Language format. Because the query cannot be parsed by the QuickBooks Online query engine, DBSync cannot execute the request or retrieve records from the specified object. As a result, no data is returned to the workflow and subsequent steps cannot process records.

6. Solution / Resolution

Follow the steps below to identify and correct the malformed query in the QuickBooks Online Query Step.

1. Log in to the DBSync application.

2. Navigate to the Project and Task (integration workflow) where the synchronization failure occurs.

3. Open the Workflow Logs for the failed execution.

4. Review the logs to identify the step generating the error. The failing step can typically be identified by SEVERE log entries referencing the workflow step name in square brackets [ ].

5. Note the Query Step where the parsing error occurs.

6. Open the workflow configuration and locate the QuickBooks Online Query Step identified in the logs.

7. Review the SQL query configured in the Query Step.

8. Validate the query by checking the following:

   1. The query syntax follows the QuickBooks Query Language format.

   2. The object name referenced in the query is correct.

   3. All fields referenced in the query exist in the QuickBooks Online object.

   4. The query does not contain unsupported conditions, invalid values, or malformed syntax.

9. Correct any identified syntax errors, invalid field references, or unsupported query conditions.

10. Use the Preview option in the Query Step to validate the query.

11. After correcting the query, save the workflow configuration.

    1. If records are returned or no records are found, the query syntax is valid.

    2. If the preview returns a query parsing error, additional corrections are required.

    3. After correcting the query, save the workflow configuration.

12. Re-run the workflow synchronization to confirm that the Query Step successfully retrieves records.

Alternative Option

If the Advanced Query option is being used and syntax errors persist, consider switching to the Visual Query Builder to construct the query. The Visual Query Builder helps reduce syntax errors by generating the query automatically based on selected objects and fields.

7. Impact

When this issue occurs, DBSync cannot retrieve records from QuickBooks Online in the affected Query Step due to the malformed query syntax. Because no data is returned, any Transform or Write steps that depend on the query results cannot process records. As a result, the workflow execution fails at the affected step and downstream processing cannot proceed.

9. Keywords / Tags

DBSync

QuickBooks Online

Intuit

QuickBooksRestV3Adapter

QBRestV3Reader

QueryParseError

Error parsing query

QuickBooks query language

DBSync Query Step

QuickBooks query syntax

Malformed query

QuickBooks Online integration

Error while parsing Unable to get records count