Quickbooks Online - Customer Query Using Email (QBXML)

Question

Can't we query Quickbooks for a Customer using the Email address? I came to know that the only way to query using Email is to query using FullName and then parse the response at your own end to match the Email address. And this seems true as is not working within .

Why is this so? If we can query using then why can't using .

I just came to know about a "not so good" solution which is to store Email address in FullName field of QuickBooks Online and then make simple Query for customer using FullName. The drawback in this solution is that FullName's maximum length is 41 but I think Email addresses can exceed the 41 characters.

Answer 1

Yes you can, in QBO API v3.

For example:

SELECT * FROM Customer WHERE PrimaryEmailAddr = '[email protected]'

It's undocumented, but I've been using it in production for a few years. https://developer.intuit.com/docs/api/accounting/Customer

Answer 2

Can't we query Quickbooks for a Customer using the Email address?

Nope. QuickBooks does not support this.

If you want to query by the Email field, you'll need to pull the entire customer list (or find some other way to filter it down) and filter it within your application.