Have fun with your queries! If there are additional questions I can cover for you, please leave a comment below.This does not work: (it fails with a “QuickBooks found an error with the XML” error) SELECT * FROM Customer WHERE Active IN (true,false) Summary To retrieve all customers, both active and inactive, issue this query: SELECT * FROM Customer WHERE Active = false To retrieve inactive objects you must explicitly filter with the Active property, for example: SELECT * FROM Customer WHERE Active = true It’s as if the following quere were issued: Returns only active customer objects by default. SELECT * FROM Invoice WHERE TxnDate > ‘’ AND TxnDate attribute setting. Get all properties for the Invoice entities with transaction dates between Jan. SELECT * FROM Invoice WHERE CustomerId IN (’12’) Get the header properties for the Invoice entities whose CustomerId properties match the values of the IN clause. SELECT * FROM Customer WHERE GivenName LIKE ‘K%h’ AND FamilyName LIKE ‘Palm%’ Get all properties for the Customer entities whose first name starts with “K” and ends with “h”, and whose last name starts with “Palm”. SELECT * FROM Customer WHERE Id = ‘123456’ Get the Customer entity for the specified identifier: SELECT * FROM Customer WHERE active = true SELECT * FROM Customer WHERE Active IN (true, false) Get all active and inactive customers (only list entities like Customer, Vendor, Item, and so on, support concept of Active and InActive) SELECT * FROM Invoice WHERE CustomerRef = ‘123’ Filter on the CustomerRef attribute from the invoice: QueryValidationError: property ‘DeliveryInfo’ is not queryable You receive an error response similar to the following if you try to filter your query with a non-filterable property-in this case an attempt to filter with DeliveryInfo: For example, here is an excerpt from the API reference guide showcasing two properties from the Invoice entity: Balance is filterable and DeliveryInfo is not. FiltersĮntity properties that are available for use as filters in a query are denoted with filterable in the documentation. Here, the apostrophe in “Adam’s” is escaped with a backslash (\). CompanyID/query?query=SELECT * FROM Customer WHERE CompanyName= ‘Adam\’s Candy Shop’ Select * FROM Customer WHERE CompanyName=’Adam\’s Candy Shop’ For example, to find a Customer object whose company name is Adam’s Candy Shop, submit the following query: Use backslash (\) to escape special characters like apostrophe (‘). The OR operation is not supported in WHERE clauses.
Only those properties with values are returned in the response set.The response set returns all properties for each object.The QuickBooks Online SQL-like syntax has the following limitations: CompanyID/query?query=SELECT * FROM Customer WHERE CompanyName=’Wild Garden Restaurant’Ĭlick here for complete details about the query endpoint and supported SELECT statement syntax. For example, to query for Customer objects whose company name is Wild Garden Restaurant, issue the following: Īdditionally, surround multi word names with single quotes (‘). For additional information about URL encoding, see. Also, check with your specific development environment for their URL encoding support. There are several online tools to help you do that. Make sure to URL encode these queries before sending the request down the wire to our servers. CompanyID/query?query=SELECT * FROM Customer In turn, the app issues an HTTP REST GET operation to the query endpoint, passing the query statement as a URL parameter. For example, the following statement retrieves all active customers: This language has a proprietary, SQL-like syntax, familiar to any developer with database experience. Queries sent via this endpoint use a unified expression language, optimized for querying QuickBooks Online data. The QuickBooks Online API supports data queries via the query endpoint. Admin Deep dive into QuickBooks Online data queries
0 kommentar(er)
