How to select billing address for customer in IPP .net SDK 3

Question

I am able, using the new Intuit Partner Program version 3 SDK for QBOE, to specify a particular select query with QueryService.ExecuteIdsQuery.

I can execute the following and get back all information (including billing address) for all customers:

SELECT * FROM CUSTOMER

I am also able to send the following and get back (for example) just the ID and DisplayName of all customers:

SELECT ID, DISPLAYNAME FROM CUSTOMER

However, an invalid query exception is thrown if I try to get just the ID and Billing address of all customers -- the following will NOT work:

SELECT ID, BILLADDR FROM CUSTOMER

The request is sent to QBOE, but the response complains that it doesn't know about BillAddr.

I think that under the hood, the Select * version is doing a join on a table of addresses, but joins are not allowed in the API that Intuit provides.

Is there any way to get select for billing address specifically, without doing a Select * to get the entire wide record for each customer?

Thanks in advance for all help....

Answer 1

According docs 'billAddr' is not filterable. You can't query only 'billAddr'.

Thanks