Release Notes

Google Sheets (v 2.6.0) Users can no longer select Google Sheets from the list of all available sheets. Instead, users will need to enter the Sheets identifiers or URL. All existing Google Sheets connectors were migrated to the new version and no...

Reports Configurations Users can configure table and single value reports with the following options: Table chart: Color Palette - Select one of five available palettes Show borders - Select if the table chart will have borders or not ...

Hubspot (v 2.9.5) Panoply now supports non-incremental collection. Users can disable the incremental load through the advanced settings of the Hubspot connector. This will force the connector to always extract all the data of the selected resource...

Jobs - Query Bytes Used Panoply now displays for each job (visible in the jobs and collection history pages) the amount of query bytes used during the collection and ingestion of data. This option is available for BigQuery accounts only. Google ...

Flex Connector (v 2.13.5) Panoply now supports AWS Signature authorization as part of the Authorization group configuration. Users that wish to connect to different AWS services can do it with ease using this new authorization method. Read more h...

Instagram Business (v 2.3.2) Panoply has changed two available resources and added five new resources for users to utilize: Additional metrics were added to the Reels Insights resource: clips_replays_count ig_reels_aggregated_all_plays_co...

Date Format advanced configuration Panoply now supports advanced date format configuration. Users can define if the incoming date fields are set as month-first or day-first. For example, the date 2024-04-01 will be identified as April 1st for mo...

Netsuite (v 1.9.5) The Netsuite and Netsuite TBA data sources now support the following new resources: entityAddress transactionSalesTeam transactionBilling

Dashboards Panoply now allows you to consolidate your saved reports into dedicated dashboards. Users can add, remove, change location or change size of any report in any dashboard and share their insights with their colleagues. Read more here P...

Flex Connector (v 2.10.0) Panoply now supports async API processes. Users can trigger and check the status of async API processes. When the async process finishes successfully, Panoply will run the main API defined in the Flex Connector and ingest...

Flex Connector (v 2.7.4) Panoply now supports the input of a static list of identifiers in the Fetch List feature. The Fetch List helps users to support dynamic and static list of identifiers to be used in the different API calls. Read more here ...

Nested Data (data sources advanced option) - Pivoting subtables A new option was added to the nested data configuraiton. Users can now select to pivot the data in the subtables. This option can be found in the advanced options of every connector. ...

Workbench Copying Results Panoply now allows you to copy the results of queries you ran. After running a query, click on the results' arrow action menu and select Copy Results . This will copy the results from the current visible page.

Geography Data Type Panoply now identifies WKT geography values and ingest them as a Geography data type. It includes the following geography data: Point - For example: POINT(1 2) Linestring - For example: LINESTRING(30 10, 10 30, 40 40) ...

Hubspot (v 2.8.0) Panoply now supports the collection of custom objects associations. Important notes: When selecting to collect an association you must select both object types. In Hubspot, when adding an association the relevant records ar...

Workbench menu changes With the release of reports, some available workbench actions have switched places. Below are the available actions and where you can find them: Workbench toolbar: Format : Formats the written query in standard SQL f...

Google Drive (v 2.4.0) Panoply now support skipping XML attributes when extracting XML results using the Google Drive connector. Under the advanced options of the Google drive connector, select the Skip XML attributes to skip all of the XML att...

Flex Connector Panoply now supports a wide variety of different API services. With the Flex Connector you can connect almost every API service (GET and POST methods with raw or graphQL inputs). What You Need To Know When setting up the Flex co...

Workbench multiple queries ability Panoply now supports the ability to run multiple queries directly in the platform's workbench. That means that you no longer need to run one query at a time but instead run them all together and paginate through ...

Shopify (v 2.1.1) Panoply now support the collection of Shopify Metafield Definitions and the values of metafields for the following Shopify objects: Customers Orders Products What You Need To Know The Metafield Definitions resou...

Hubspot (v 2.3.0) Panoply now supports the collection of three new Hubspot resources: The Calling sales tool The Meetings sales tool The CRM Tasks After you had collected data from your target resource, two new tables will be cre...

Shopify (v 2.1.0) Due to Shopify API updates, we've removed the Customer - Customers Saved Search resource and added the Customer - Segments resource instead. This new resource will populate two tables: shopify_customer_segments - This t...

Nested Data (data sources advanced option) Users can define if they want to ingest nested objects as one-to-many tables (default) or to flatten them to top-most parent table. The user can change the default behavior for all nested objects and/or i...

Load Strategy Users can change the load strategy of the data sources and choose one of the following options: Upsert (deafult) - Every record that already exists in the table will be updated while new records will be inserted. The identificati...

Stripe (v 2.3.2) The Stripe data source now supports incremental loading for the Events resource. When selecting the Events resource, users can enable the Collect Events incrementally option in the advanced options. Workbench improvements Th...

Schema Lock When selected, any new column, change to a data type or new table will not be addressed by the ingestion process. Any incompatible data will be stored as null and the data source will not fail when encountering any incompatibility. Th...

Quickbooks (v 1.0.0) Panoply has released the new Quickbooks data source. Using the Quickbooks API, Panoply can collect your data into your data warehouse. The resources available are: Account Attachable Bill Bill Payment Budget Class Comp...

Hubspot (v 2.1.0) The Hubspot data source now supports the extraction of custom objects. Postgres (v 3.3.1) Panoply now supports SSL connection to Postgres databases. You can enable SSL connection and use certificates to protect the connection...

Facebook Ads (v 2.2.0) Additional delivery breakdowns are now available for selection: Ad Format Asset App Id App Id and Skan Conversion Id Body Asset Call To Action Asset Description Asset Frequency Value Image Asset Link Url ...

Google Ads (v 2.0.0) Switch from the old Adwords API to the new Google Ads API . This switch include the following changes: 149 total resources to select from Flexibility on the selection of returned fields, segments and metrics Increme...

Postgres (v 3.3.0) Collecting data using logical replication is now available. In order to use logical replication in your data source you need to: Have logical replication enabled on your Postgres server: Server version 10 and higher Set...

MySQL (v 2.4.0) Collecting data using binary logs is now available. In order to use binary logs in your data source you need to: Have binary logs enabled on the MySQL server: Server version 5.5. and higher Binary logs are enabled on the...

Hubspot (v 2.0.8) Panoply has refreshed the Hubspot data source to improve efficiency and reliability. As part of this refresh, the data structure of the properties tables has changed and Panoply supports even more resources from your Hubspot, i...

Shopify (v 2.0.18) The following resources were removed: Shipping and Fulfillment - Fulfillment and Orders - Refund . The data returning from these resources is available directly through the Orders - Order resource. If one of these resource...

DynamoDB (v 2.1.0) Collecting data using DynamoDB Streams is now available. In order to use DynamoDB Streams in your data source you need to: Have DynamoDB Streams enabled on the desired tables Enable Streams in the advanced options ...

Hubspot (v 2.1.0) In our efforts to improve collection times, Panoply has made two changes to the way we collect from Hubspot. We have increased the limit for email events to 1000 (max) from 250. We have implemented Incremental Loads for t...

WooCommerce Panoply has released the new WooCommerce data source. Using the WooCommerce API, Panoply can collect your data into your data warehouse. The following resources are available: Coupons Customers Orders Order Notes Refunds ...

Facebook Ads In response to changes made by Facebook, the default Attribution Setting has been set to 7-day click . The 28-day window has been deprecated. Because of these changes, users will need to adjust their settings or add a new instance of...

Square Panoply has released the new Square data source. Using the Square API, Panoply can collect your data into your data warehouse. The resources available are: Terminal Checkouts Payments Payment Refunds Orders Catalog Objects Inv...

Hubspot Panoply has added the email events endpoint to the Hubspot data source. Shopify The Shopify data source has been updated and released. With this update, Panoply has added additional resources and user control over the date range used t...

Salesforce A bug in the proper handling of Incremental Keys was fixed. The Parse field was removed from the UI.

Dynamo DB (v 2.0.x) The Dynamo DB data source has been updated and released. This update brings changes to the UI, better primary key handling and improved performance. Because this change also affects the way we process data, it is recommended ...

Panoply has released the refreshed and updated data sources MongoDB, MySQL and PostgreSQL. Users who are already utilizing these data sources will not need to manually migrate to the new version, Panoply will do the migrating for you. What does th...

LinkedIn Ads (v 2.0.x) Panoply has refreshed the LinkedIn Ads data source and is opening it up to public beta. This update added functionality to retrieve data from Ad Accounts, Campaign Groups, Creatives, Campaigns, Conversion Tracking endpoint...

Google Drive (v 1.4.1) In our ongoing efforts to bring our users improvements, Panoply has released the new Google Drive Data Source. This allows users to import the following types of files from their Google Drive: tar, parsing with tarfile ...

Dynamo DB UI Update In keeping with our goal to improve our customer experience, we have updated the user interface for Dynamo DB  General and the Advanced tabs. Bug Affecting All Dynamic Sources (Database/File Systems) It was ...

Google Adwords v 1.6.0 An added field spurred this change to Google Adwords data source, as it alters the ID patterns on two reports: the Adgroup Performance Report and the Search Query Performance Report. For the Adgroup Performance Report, that ...

Google Adwords June 2020 (v1.51) Panoply is always working to improve our service and our data sources. This update to the Google Adwords data source brings it current with recent changes in the underlying API, including changes to the Search Quer...