New Atlassian Virtual Agent Accelerator!
The Atlassian Virtual Agent accelerator enables instant fulfilment and response to user requests for app provisioning through the Atlassian Virtual Agent. It leverages pre-configured, data-driven intents to autonomously interpret user inquiries and direct them to specific recipes/actions!
Workato's Atlassian Virtual Agent accelerator can be effectively utilised in various scenarios where you want to streamline and automate handling user requests for app provisioning, particularly when using Atlassian Virtual Agent and Slack. Here are some situations in which you might consider using this solution:
- Application Provisioning Requests: If your organization frequently receives requests for setting up or configuring software applications, this accelerator can automate the process, making it more efficient and consistent.
- High Volume of User Requests: Manual handling can be time-consuming when dealing with a high volume of user requests for application provisioning. The accelerator can handle these requests in real-time without human intervention.
- Integration with Atlassian: If your organisation uses Atlassian Virtual Agent and relies on Slack for team communication, this accelerator seamlessly integrates with this platform, providing a cohesive solution for handling requests.
- Scalability: As your organization grows and the volume of requests increases, the accelerator can scale to handle more requests without a corresponding increase in manual effort.
Data Integration release announcements
Big updates coming through! We have released some exciting features in the data integration domain.
FileStorage
We now have the ability to handle CSV data effectively in the FileStorage system. Updates to FileStorage actions:
- Store a CSV file and its column data type schema in a directory (in the “Create file” action).
- Append CSV lines to an existing file with column data type validation (in the “Append to file” action).
- Fetch CSV lines from a file in batches from an existing file (Using the “Get CSV lines from file” action).
- FileStorage can also auto-infer and assign best-fit data type schema to the columns while storing/appending the file.
Introducing new FileStorage triggers:
- Trigger and fetch any file type as a byte stream once it is available using the "New file" bulk trigger.
- Extract complete CSV file data in batches, as and when it is stored/added, using the "New CSV file" batch trigger.
- Monitor a particular CSV file and fetch new lines appended to the file in batches using the "New lines in CSV file" batch trigger.
With these new enhancements, users can be assured that the CSV file data stored within our system aligns with the column schema. This is crucial as they map this data to downstream applications that expect strict conformance to the mentioned data types. With this, we are solving common problems like Data Volume mismatches, Schema safety in data pipelines or Real-Time directory monitoring!
SQL Transformation
We have added the ability to process and transform Excel files using SQL Queries:
- Improves our support for native Excel parsing and transformation.
- It accepts data from a specific Excel file, worksheet, and data range as the data source.
- Provides the ability to aggregate and query across CSV and Excel data types.
We have added Workato Data tables as a new data source to query:
- It alleviates our limitation in running complex queries across one or more data tables.
- Aggregate and transform data across different sources - applications, files, and data tables.
- Fetch the query results as CSV to be used in downstream actions.
With the new updates, SQL Transformations is now even more functional, powerful and scalable, handling data from different sources and in different formats. Note that today, the output of the transformations will be in CSV format.
Long Actions in Database Connectors
Long actions for databases can be understood as asynchronous execution of SQL queries. They give us the ability to handle long-running SQL queries and exports of datasets.
What does it solve?
Previously, we faced limitations with executing long-running SQL queries (>500s) and exporting data in CSV format via cloud connections. Long actions address these challenges by providing a solution that allows for extended query execution times, with a timeout limit of 120 minutes
Which actions and database connectors?
- Run long query using custom SQL: This action is designed to execute custom SQL queries that may exceed the standard timeout limit of 500s. It enables the processing of complex queries without the fear of hitting timeout constraints.
- Export Query Result: This action facilitates bulk data extraction from databases in CSV format. This action has no limit to the number of rows returned, eliminating the need for pagination logic.
Snowflake Connector
Upload to internal stage (new)
- This new action provides a dedicated solution for uploading files to Snowflake's internal stage. It simplifies transferring data into Snowflake for further processing or analysis.
Bulk load from stage (improved to accommodate files from internal stages)
- Improved functionality allows loading files directly from Snowflake's internal stage into a table. This enhancement streamlines data ingestion processes, enabling smoother and more efficient data-loading workflows.
In this release, we've introduced data integration as a distinct top-level category within our documentation, enhancing the discovery of a key platform capability.
Check our Data Integration Documentation →
Platform Connector Updates
We introduced major improvements to several key strategic connectors: SAP Concur, OpenAI, Workday, OneDrive, HTTP connectors, etc...
Top 10 Releases
SAP Concur
[Enhancement] CRUD capability for user provisioning.
We have now added the ability to create, update, and deactivate users in SAP Concur. This includes creating a new user, replacing an existing user, and deactivating a user by updating their active status.
OpenAI
[Enhancement] Add summarize action.
We have now added a "Summarize text" action to the OpenAI and "Ai by Workato" adapters. This new feature uses an underlying function to generate a set of parameters. Additionally, users can now configure the length of the resulting summary through the 'max_words' input field.
Workday
[Enhancement] Workday report feature enhancement.
We have improved the user experience and functionality of our Workday report feature.
For the "Scheduled Report Trigger", when the "Detect Report Schema Automatically" is set to "NO", the report schema inserted using schema designer will now generate datapills. This resolves the previous issue where the datapills were not produced.
We have updated the hint for the "Detect Report Schema Automatically" feature. It states that this function only works if the report URL is a string.
We have also enhanced the "Report Columns" field to support JSON schema, aligning with our recent JSON format output support release.
OneDrive
[Enhancement] Bidirectional sync support.
We have made significant improvements to our OneDrive connector by introducing three new features to support bidirectional sync:
- List Files and Folders: This feature allows users to list files and folders within OneDrive.
- Delete File or Folder: This feature allows users to remove unwanted files or folders, providing better control over their OneDrive content.
- New Event Trigger: This new feature will alert users to specific events within their OneDrive, improving overall workflow and efficiency. These updates are part of our ongoing commitment to meet our customers' needs and enhance their Workato experience.
Outlook
[Enhancement] Pagination support.
We now support this by introducing two key changes. Firstly, an offset field has been added to provide the next page offset. Secondly, using the Outlook API, a timezone picklist has been incorporated to display the supported time zones.
Amazon S3
[Enhancement] Support of custom action.
The connector has now been updated to include custom action support. This enhancement allows for more flexibility and customization in the use of Amazon S3.
[Enhancement] Support extensive search objects operation with pagination.
We enhanced the search objects operation with broader search capabilities and pagination. Previously limited to returning up to 1000 records without search options. With this update, users can now:
- Search by providing delimiters and prefixes on the keys
- Specify "search-after" to fetch keys after a specific key
- Perform pagination by providing max results, next page token
Google Sheets
Support Google sheet update rows in bulk.
Our ability to update Google Sheets is restricted by Google's API, which caps at 100 actions per minute, hindering updates for large data sets. We can only update one row at a time and require a batch update solution akin to the "add rows in bulk" feature.
We've introduced a feature for bulk row updates akin to the "add rows in bulk" function, which only updates consecutive rows. The UI resembles adding rows in bulk, with a 'row number' marking where updates start. If multiple items are listed and a starting row is chosen, all subsequent rows up to the list's end get updated. This feature supports a maximum of 50,000 records.
LinkedIn
[Enhancement] Upgrade to API Version 202401.
We have upgraded the LinkedIn version to 202401 and updated the associated actions and triggers. We have also deprecated some non-backward compatible actions/triggers and introduced new ones. Customers are advised to prepare for the deprecation of the old version by LinkedIn by adding r_marketing_leadgen_automation scope into their connection.
SuccessFactors
[Enhancement] Update environment picklist and documentation link.
The SuccessFactors environment picklist and SAP documentation link have been updated. The endpoint of DC4 (DC68) SalesDemo has also been updated.
Custom Action/HTTP
[Enhancement] Parsing for XML inputs outputs into schemas.
We've fixed a parsing issue for XML inputs in Custom Actions and HTTP, eliminating the need for manual XML output parsing. Our system automatically generates a schema from sample XML documents, simplifying the process by auto-generating output datapills when users paste a sample XML. Also, we've introduced support for converting JSON input into XML in the execute block.
Check out the remaining updated and enhanced connectors in the Connectors Release Notes - 2024.03 post:
- Dropbox
- Stripe
- SMS by Workato
- Email by Workato
- Jira
- SuccessFactors
- Amazon S3
- BIM360
- Salesforce
- Hubspot
- TableStorage
- Coupa
- Outlook
- Netsuite
- Microsoft Sharepoint
- Azure Blob Storage
- Zendesk
- Freshdesk
- Shopify
- Wrike
- Sage Live
- Magento
- Azure Monitor
- ZoomInfo
- Quickbase
- JWT Too
