CODEWITHSUNDEEP
phpapiquickbooks
Raphael Rafatpanah
Raphael Rafatpanah

Reputation: 19967

Limit columns from QuickBooks Online API Customer Query

I know I can do something like:

SELECT * FROM Customer

which returns the following objects.

I tried limiting my query to:

SELECT Id FROM Customer which worked great, but for some reason I cannot do:

SELECT ShipAddr FROM Customer. No data is returned.

I've learned SELECT DisplayName, Id FROM Customer works but nothing else does.

Is there a way I can request the following data only and nothing else:

SELECT AlternativePhone, BillAddr, CompanyName, DisplayName, Id, PrimaryEmailAddr, PrimaryPhone, ShipAddr FROM Customer?

Upvotes: 0

Views: 287

Answers (1)

nimisha shrivastava
nimisha shrivastava

Reputation: 2367

I do not think fetching only selective fields is supported for all fields. You can try your queries on API explorer and see if get the resultset you want. Else, please consider it as non-supported. You will have to get the full response in that case then and use the selected fields/properties.

Upvotes: 1

Related Questions