Troubleshooting - Select statement is not working.

Problem Description:

I am evaluating the product. When I made this SQL Statement:

Select * from Customer where ListId=557

I was getting a column not found the error. The QBO online documentation says the Customer table has a field called "Id," but this also comes back as "column not found."

Can you let me know if this unique ID column is being renamed or something?

Solution:

ListID column data type is varchar, So you need to add quotes (i.e. ') around it. Please use the below query & try again.

select * from Customer where ListId='557'

Regarding ID, I think you might have tried

select * from Customer where ID='557'

ID is not part of the QODBC-Online Schema. Please use the listed.

You can get QODBC Online table schema from below link:

Please refer to QODBC Online Data Layout for more details:

Tags: QuickBooks Online, QBO, QODBC Online, Customer