QXL for QuickBooks Online - Known Issue(s)/Limitation(s)

Problem Description:

I am trying to export data from QuickBooks Online using QXL Online. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in QXL Online status.

After reviewing the Output folder, I noticed some of the tables are not exported & found the below error in the error logs from the export table folder:

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: ValidationException was thrown. At Intuit.Ipp.QueryFilter.QueryService`1

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: The Response Stream was null or empty.

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: No connection could be made because the target machine actively refused

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: An existing connection was forcibly closed by the remote host

GatewayTimeout error

Solution:

The above-mentioned error is returned randomly from Intuit API. Sometimes Intuit API does not provide the proper response to data requests & may throw the above error.

When you receive such an error, You need to retry & export a particular table.

Tags: QuickBooks Online, QBO, QXL Online, API