--- title: "Release Notes - July 2023" slug: "release-note-2023-07" updated: 2024-09-10T11:35:33Z published: 2024-09-10T11:35:33Z canonical: "documents.trocco.io/release-note-2023-07" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Release Notes - July 2023 **Hello! Release information for July 2023!** --- ## Workflow ### Expand data warehouses capable of checking data 🎉. Workflow **data checking** is a function that matches the results of a query to the data warehouse with error conditions, and if the conditions are met, the corresponding task can be set to error. With the expansion of the data warehouse that can now check data, the following data checks can be incorporated as workflow tasks. - Google BigQuery - **Snowflake** (added this time) - **Amazon Redshift** (added this time) For more information, see [Workflow Data Check](/docs/workflow-data-check). ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-07-2024-08-29-18-29-0.png) ## ETL Configuration ### OAuth 2.0 added as authorization method for Data Source HTTP/HTTPS 🎉. **OAuth 2.0** is added as an authorization method. This allows data to be retrieved from data sources that require OAuth authentication. For more information, see [Data Source - HTTP/HTTPS](/docs/data-source-http). ### Expand file/storage system Connector that can transfer data in XML format 🎉. Added " **XML (beta)** " to the input format options for **Data Source HTTP/HTTPS and****Data Source Google Drive**. Including this change, XML-formatted data can be transferred using the following File/Storage System Connector ETL Configuration. - Data Source App Store Connect API - Data Source Azure Blob Storage - Data Source Box - Data Source FTP/FTPS - Data Source Google Cloud Storage - Data Source KARTE Datahub - Data Source SFTP - Data Source S3 - Data Source Local Files - **Data Source Google Drive** (added this time) - Data **Source HTTP/HTTPS** (added this time) For more information, see [About input file format settings](/docs/configuration-of-input-files). ### Expanded object type options for Data Destination HubSpot 🎉. The object type in ETL Configuration STEP 1 now allows the selection of **Engagement Objects and****Custom Objects**. **Engagement Objects** can be used as Data Destination for interaction-related data, while **Custom Objects** can be used as Data Destination for data that cannot be categorized in the Prescriptive Objects. For more information, see [Data Destination - HubSpot.](/docs/data-destination-hubspot) ### Support for CampaignExportService in Data Source Yahoo! Search Ads 🎉. Added **CampaignExportService** to the services for data acquisition that can be selected in ETL Configuration STEP1. See [Data Source - Yahoo! Search Ads](/docs/data-source-yahoo-search-ads) for the fields retrieved by **the CampaignExportService**. ### Added Data Source Zendesk Support to retrieve data 🎉. Added **ticket_comments** to be retrieved by Data Source Zendesk Support. It is now possible to retrieve and forward comment data related to tickets, including the text of the comment and the ID of the sender of the comment. For more information, see [Data Source - Zendesk Support.](/docs/data-source-zendesk-support#%E3%83%87%E3%83%BC%E3%82%BF%E5%8F%96%E5%BE%97%E5%AF%BE%E8%B1%A1%E3%81%ABticketmetrics%E3%81%BE%E3%81%9F%E3%81%AFticketcomments%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%97%E3%81%9F%E5%A0%B4%E5%90%88) ## Connection Configuration ### Allow Roles to be specified in Snowflake Connection Configuration 🎉. Roles can now be specified in Snowflake Connection Configuration. Roles that grant the necessary permissions to access Snowflake from TROCCO can be tied to Connection Configuration. If not entered, Snowflake's default settings are used. ## UI・UX ### Added ETL Configuration details link when selecting ETL Configuration for workflow 🎉. A **link to the ETL Configuration Details screen** has been added to the Add TROCCO Transfer Job Task modal on the Flow Edit screen. This allows the contents of ETL Configuration to be viewed immediately from the flow editing screen. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-07-2024-08-29-18-29-1.png) ### Display of Workflow definitions to be embedded on various detail pages 🎉. Various detail pages, such as ETL Configuration and Data Mart Configuration, which are embedded as tasks in Workflow, now display the embedded Workflow definitions. You can check the details on the various pages below. - ETL Configuration - Managed ETL Configuration - Data Mart Configuration - Workflow ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-07-2024-08-29-18-29-2.png) ### Fixed header size of various Data Mart Configuration screens changes with scrolling 🎉. Scrolling down on the New, Detail, and Edit pages of a Data Mart Configuration will reduce the height of the fixed header. The display area for the contents of Data Mart Configuration has been widened, increasing the amount of information displayed on the screen. | Before Scroll | After scrolling | | --- | --- | | ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-07-2024-08-29-18-29-3.png) | ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-07-2024-08-29-18-29-4.png) | ## TROCCO API ### Add parameter to specify time zone in job execution request 🎉. Added **time_zone as** a request parameter for ETL Job and Workflow Job execution. This allows you to specify the time zone for the date and time specified in **context_time**. For more information, see [About the TROCCO API.](/docs/trocco-api) ## API Update ### Various Facebook-based Connectors that use the Facebook API The Facebook API used for the following Connector has been updated **to v16**. - Data Source Facebook Ad Creative - Data Source Facebook Ad Insights - Data Destination Facebook Conversions API For more information about the new version, see [Meta for Developers](https://developers.facebook.com/docs/graph-api/changelog/version16.0). ### Data Source Criteo The API used in the above Connector has been updated to **v2023.04**. Please refer to [Version 2023.04 release notes for](https://developers.criteo.com/marketing-solutions/changelog/version-202304-release-notes) more information about the new version. ## Other - Expanded columns forwarded from Data Source Facebook Ad Creative - Expansion of items that can have Custom Variables embedded in Data Source Adobe Marketo Engage. - Custom Variable Loop Execution Edit Form in Workflow Definitions to Suggest Snowflake Warehouses - Added **rest.fra-02.braze.eu** to host choices in Braze Connection Configuration --- **The contents of this release are described above. ** **Please feel free to contact our Customer Success Representative if you have a release you are interested in. ** **Happy Data Engineering!**