DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 5

changes.mady.by.user admin

Saved on

compared with

New Version 6

changes.mady.by.user Vishwanath B

Saved on

Key

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

QuickBooks Queries

Panel

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

...

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

...