Panoply utilizes Quickbooks' REST API to collect data into your Panoply data warehouse.
Metadata
Panoply inserts the following metadata fields into each table collected:
__company_id: The connected Quickbooks Company ID.__company_name: The connected Quickbooks Company name.__resource: The name of the selected resource.
Quickbooks Endpoints
Panoply supports up to 36 different endpoints:
- Account
- Attachable
- Bill
- Bill Payment
- Budget
- Class
- Company Currency
- Company Info
- Credit Memo
- Credit Card Payment
- Customer
- Customer Type
- Department
- Deposit
- Employee
- Estimate
- Invoice
- Item
- Journal Code
- Journal Entry
- Payment
- Payment Method
- Purchase
- Purchase Order
- Refund Receipt
- Reimburse Charge
- Sales Receipt
- Tax Agency
- Tax Code
- Tax Payment (only available for AU, CA and UK locales)
- Tax Rate
- Term
- Time Activity
- Transfer
- Vendor
- Vendor Credit