Contents x
- Welcome to Panoply Documentation
- Getting Started
- Manage Data
- Data Security
- BI and ETL Tools
- Connectors Documents
- Connectors Introduction
- API Connectors
- Appsflyer
- Asana
- BigCommerce
- Bing Ads
- Delighted
- Facebook Ads
- Facebook Pages
- Facebook Posts
- Flex Connector
- Flex Connector Setup Guide
- Flex Connector Advanced Settings
- Flex Connector Authorization
- Flex Connector Variables
- Flex Connector Pagination
- Flex Connector Refresh Access Token
- Flex Connector Fetch List
- Flex Connector Async API
- Flex Connector Release Notes
- Flex Connector Templates
- Google Ads
- Google Analytics 4
- Google Universal Analytics
- Google Search Console
- Hubspot
- Instagram Business
- Intercom
- Jira
- Klaviyo
- LinkedIn Ads
- Mailchimp
- NetSuite
- Pardot
- Quickbooks
- Salesforce
- Shopify
- Square
- Stripe
- Twilio
- Twitter Ads
- WooCommerce
- Xero
- Zendesk
- Database/File Systems
- Data Recipes
- Release Notes
- September 2024 Release Notes
- August 2024 Release Notes
- July 2024 Release Notes
- June 2024 Release Notes
- May 2024 Release Notes
- April 2024 Release Notes
- March 2024 Release Notes
- February 2024 Release Notes
- January 2024 Release Notes
- December 2023 Release Notes
- November 2023 Release Notes
- October 2023 Release Notes
- September 2023 Release Notes
- August 2023 Release Notes
- July 2023 Release Notes
- June 2023 Release Notes
- May 2023 Release Notes
- April 2023 Release Notes
- March 2023 Release Notes
- February 2023 Release Notes
- January 2023 Release Notes
- December 2022 Release Notes
- November 2022 Release Notes
- October 2022 Release Notes
- September 2022 Release Notes
- August 2022 Release Notes
- July 2022 Release Notes
- June 2022 Release Notes
- February 2022 Release Notes
- April 2022 Release Notes
- January 2022 Release Notes
- December 2021 Release Notes
- November 2021 Release Notes
- October 2021 Release Notes
- September 2021 Release Notes
- July 2021 Release Notes
- June 2021 Release Notes
- May 2021 Release Notes
- April 2021 Release Notes
- March 2021 Release Notes
- January 2021 Release Notes
- November 2020 Release Notes
- October 2020 Release Notes Supplemental
- October 2020 Release Notes
- September 2020 Release Notes
- August 2020 Release Notes
- July 2020 Release Notes
- June 2020 Release Notes
- Platform FAQs
Quickbooks Advanced Settings
Article summary
Did you find this summary helpful?
Thank you for your feedback
Warning:
We do not recommend changing advanced settings unless you are an experienced Panoply user.
For users who have some experience working with their data in Panoply, there are a number of items that can be customized for this data source.
- Destination Prefix: This is the prefix that Panoply will use in the name of the tables included in the collection.
- The default prefix for Quickbooks is
quickbooks
. To change this, entire your desired prefix. - The naming convention is
quickbooks_<__resource>
, where__resource
is a dynamic field. For example, for the resource namedCustomer
, the default destination table will bequickbooks_customer
.
- The default prefix for Quickbooks is
- Incremental Load: By default, Panoply collects all of your data from Quickbooks on your first collect. After that, Panoply collects from the date of the last successful collection.
- Destination Schema: This is the name of the target schema to save the data. The default schema for data warehouses built on Google BigQuery is panoply. The default schema for data warehouses built on Amazon Redshift is public. This cannot be changed once a source has been collected.
- Exclude: The Exclude option allows you to exclude certain data, such as names, addresses, or other personally identifiable information. Enter the column names of the data to exclude.
- Truncate: Truncate deletes all the current data stored in the destination tables, but not the tables themselves. Afterwards Panoply will recollect all the available data for this data source.
- Click Save Changes then click Collect.
- The data source appears grayed out while the collection runs.
- You may add additional data sources while this collection runs.
- You can monitor this collection from the Jobs page or the Data Sources page.
- After a successful collection, navigate to the Tables page to review the data results.
Was this article helpful?
Thank you for your feedback! Our team will get back to you
How can we improve this article?
Your feedback
Comment
Comment (Optional)
Character limit : 500
Please enter your comment
Email (Optional)
Email
Please enter a valid email