Cdata error when querying Quickbooks JournalEntryLineItems

Hi  ​@lesh Based on the error message it looks like the issue is with the LineNum column being sent as [Line.LineNum] in the query projection for you instead of [Line_LineNum]

Can you double check on your end if the column in question is exposed as Line_LineNum in the column metadata? Also can you confirm the issue happens only when running a SELECT * query? What happens if you try running the following query as a workaround?

SELECT [LineId], [JournalEntryId], [SyncToken], [MetaData_CreateTime], [MetaData_LastUpdatedTime], [DocNumber], [TxnDate], [PrivateNote], [Adjustment], [Line_Id], [Line_Description], [Line_Amount], [Line_DetailType], [Line_LineNum], [Line_JournalEntryLineDetail_PostingType], [Line_JournalEntryLineDetail_Entity_Type], [Line_JournalEntryLineDetail_Entity_EntityRef], [Line_JournalEntryLineDetail_Entity_EntityRef_Name], [Line_JournalEntryLineDetail_AccountRef], [Line_JournalEntryLineDetail_AccountRef_Name], [Line_JournalEntryLineDetail_ClassRef], [Line_JournalEntryLineDetail_ClassRef_Name], [Line_JournalEntryLineDetail_DepartmentRef], [Line_JournalEntryLineDetail_DepartmentRef_Name], [Line_JournalEntryLineDetail_TaxCodeRef], [Line_JournalEntryLineDetail_TaxApplicableOn], [Line_JournalEntryLineDetail_TaxAmount], [Line_JournalEntryLineDetail_BillableStatus], [Line_JournalEntryLineDetail_TaxInclusiveAmt], [TxnTaxDetail_TxnTaxCodeRef], [TxnTaxDetail_TotalTax], [TxnTaxDetail_TaxLineAggregate], [TotalAmt], [CurrencyRef], [CurrencyRef_Name], [ExchangeRate], [ProjectRef] FROM [QuickBooksOnline1].[QuickBooksOnline].[JournalEntryLineItems]

As for the issue, if the problem is reproduced from a simple SELECT * FROM JournalEntryLineItems query then we would need to take a look at the log to better understand why the underlying query is sending this column as Line.LineNum. Please submit a support case with the CData support team here and send the logs over so one of our support specialists will further assist you.

Hi  ​@lesh Based on the error message it looks like the issue is with the LineNum column being sent as [Line.LineNum] in the query projection for you instead of [Line_LineNum]

Can you double check on your end if the column in question is exposed as Line_LineNum in the column metadata? Also can you confirm the issue happens only when running a SELECT * query? What happens if you try running the following query as a workaround?

SELECT [LineId], [JournalEntryId], [SyncToken], [MetaData_CreateTime], [MetaData_LastUpdatedTime], [DocNumber], [TxnDate], [PrivateNote], [Adjustment], [Line_Id], [Line_Description], [Line_Amount], [Line_DetailType], [Line_LineNum], [Line_JournalEntryLineDetail_PostingType], [Line_JournalEntryLineDetail_Entity_Type], [Line_JournalEntryLineDetail_Entity_EntityRef], [Line_JournalEntryLineDetail_Entity_EntityRef_Name], [Line_JournalEntryLineDetail_AccountRef], [Line_JournalEntryLineDetail_AccountRef_Name], [Line_JournalEntryLineDetail_ClassRef], [Line_JournalEntryLineDetail_ClassRef_Name], [Line_JournalEntryLineDetail_DepartmentRef], [Line_JournalEntryLineDetail_DepartmentRef_Name], [Line_JournalEntryLineDetail_TaxCodeRef], [Line_JournalEntryLineDetail_TaxApplicableOn], [Line_JournalEntryLineDetail_TaxAmount], [Line_JournalEntryLineDetail_BillableStatus], [Line_JournalEntryLineDetail_TaxInclusiveAmt], [TxnTaxDetail_TxnTaxCodeRef], [TxnTaxDetail_TotalTax], [TxnTaxDetail_TaxLineAggregate], [TotalAmt], [CurrencyRef], [CurrencyRef_Name], [ExchangeRate], [ProjectRef] FROM [QuickBooksOnline1].[QuickBooksOnline].[JournalEntryLineItems]

As for the issue, if the problem is reproduced from a simple SELECT * FROM JournalEntryLineItems query then we would need to take a look at the log to better understand why the underlying query is sending this column as Line.LineNum. Please submit a support case with the CData support team here and send the logs over so one of our support specialists will further assist you.

 

Hi Yes, it is exposed as Line_LineNum on my end.

I’ll file a case with the support team.