2022
...
Panel |
---|
Knowledge of QuickBooks and QBXML QuickBooksXML is required for mapping and creating a process for integrating with QuickBooks. |
QuickBooks Online Adapter provides Desktop" adapter/connector provides interfaces for:
You can build the queries of QBOE QuickBooks or QB QuickBooks Desktop Adapter from the Reader Section of the Process Definition. You can build the queries similar to SQL, which includes the straightforward query.
...
The following is a query to extract all Customer Customers in batches of 100 which that have been changed since the last successful run of the process.
Code Block |
---|
Select select * from Customer where Customer.MaxReturned=500 100 and Customer.FromModifiedDate=$last_success_run |
Note: Refer the filters from the QBXML, which QuickBooksXML. This is available in DBSync2 Conf DBSync On-Premise version under this DBSync2\src\www\WEB-INF\conf folder. The XML Structures of all QB QuickBooks Objects are specified in this file.
...
The following is a query to extract all ItemService in batches of 100 which that have been changed since the last successful run of the process.
Code Block |
---|
Select * from ItemService where ItemService.MaxReturned=500 100 and ItemService.FromModifiedDate=$last_success_run |
Panel |
---|
Other items - such as ItemNonInventory, ItemInventory, ItemDiscount - are not supported in QuickBooks Online Edition. |
Complex query with a join
Code Block |
---|
select * from Invoice,Customer where Invoice.MaxReturned=500100 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName |
The above query joins Invoice and Customer QBXML QuickBooksXML responses into one XML. As a result, so that the transformation engine can avoid multiple processes. This is done to optimize data flow to and from QuickBooks.