QuickBooks Online Beta API

[Accounted4LLC]

2 notes to mention

1. I noticed a bug when running the query for Invoice_Sales_Item_Line. Please see the error report

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DSI] (20030) Memory management error.
Details:
DataSourceKind=QuickBooksOnline
DataSourcePath=QuickBooksOnline
OdbcErrors=[Table]

2. QuickBooks Online hides many accounts when they are "deleted" (really they are jsut removed from view), but for analytics purposes we sometimes need them for past data references. In their API, there is a T/F column for this called "Inactive".  In your integration, there currently is no option to pull a list of these inactive accounts.  I beleive this needs to be specified when calling their API (either calling just inactive or both).

[v-qiuyu-msft]

Hi @Accounted4LLC, 

I don't have QuickBooks account to test the issue currently, I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu

[johnyarbi]

I found a solution that worked for me and posted the details in another thread:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DSI] (20030)