Knowledgebase: Tutorials
[QODBC-Online] Troubleshooting - Select statement is not working
Posted by Jack - QODBC Support on 11 January 2016 10:14 AM

Troubleshooting - Select statement is not working

Problem Description:

I am evaluating the product. When I did 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 as well comes back as "column not found".

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


ListID column data type is varchar, So you need to add quotes (i.e. ') around it. Please use 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 QODBC-Online Schema, Please use ListID.

You can get QODBC Online table schema from below link:

Please refer QODBC Online Data Layout for more details:



Tags: QuickBooks Online, QBO, QODBC Online, Customer

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).