DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 3

changes.mady.by.user admin

Saved on

compared with

New Version 4

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

QuickBooks Queries

...

Panel

(info) Knowledge of QuickBooks and QBXML is required for mapping and creating process for integrating with QuickBooks.

QuickBooks Online Adapter provides interfaces for

...

Code Block
Select * from ItemService where ItemService.MaxReturned=500

Panel

(info) Other items such as ItemNonInventory, ItemInventory, ItemDiscount are not supported in QuickBooks Online Edition.

Complex query with join

Code Block

select * from Invoice,Customer where Invoice.MaxReturned=500 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 responses into one XML, so that the transformation engine can avoid multiple processes. This is done to optimize data flow to and from QuickBooks.