[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 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?


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

(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).