SQL Upsert, PCMCS Deploy Cube, Salesforce OAuth connections, HTTP Webhook Triggers, Feedback form
Release Date: 6 June 2020
OneCloud will be making platform enhancements, Saturday, June 6, 2020, from 11 am to 1 pm EDT. There will be no downtime for this release.
HTTP Webhook Trigger
A new Trigger for HTTP Webhooks is now available on the platform. This Trigger allows a POST request with a JSON payload to initialize a OneCloud Chain. Triggers are a powerful way to integrate enterprise applications and seamlessly exchange data in an automated fashion.
The relational BizApps now support the Upsert Command. Upsert provides the ability to update existing and insert new records to a table from a single Command. During the import, existing records are updated based on the field(s) specified in the Command and new records are inserted into the table.
Amazon Redshift: Read the Docs
SQL Server: Read the Docs
MySQL: Read the Docs
Oracle RDBMS | ADW: Read the Docs
Postgres: Read the Docs
Snowflake: Read the Docs
The Oracle Profitability and Cost Management Cloud Service (PCMCS) BizApp now supports the Deploy Cube Command. The Deploy Cube Command is utilized after a metadata update within the PCMCS application to redeploy the Essbase cube that supports the application.
The Salesforce BizApp now supports OAuth connections. OAuth is an open protocol that provides additional data security by authorizing a client application to access data from a protected resource through the exchange of tokens.
In-app Support Enhancements
The in-app support (question mark icon in the header) now contains a few new options to enhance our support and gather your feedback. You will now see a direct link to our documentation, a link to open in-app chat, and a quick link to submit feedback via email. We welcome your input and feedback regarding how OneCloud can continue to grow and help your organization integrate, automate, and accelerate.
The following defects are fixed in this platform update:
OneCloud Slack Integration (Ticket #1809)
Command outputs remain in the temp directory (Ticket #1815)
Pagination Fix for List Object with Sage Intacct (Ticket #1816)
More than 50 records displayed in Google Big Query (Ticket #1830)
Date filter not filtering Command Run overview (Ticket #1857)
Box ID not displayed correctly (Ticket #1849)
Overlapping input boxes on Variable Transformation (Ticket #1847)
Deleting multiple schedules is not working when trying to delete all schedules (Ticket #1841)
Promoted Chains generating incorrect resource IDs (Ticket #1842)
Import Snapshot command fails when run without optional user password (Ticket #1851)
Chain reported failure but shows as still executing (Ticket #1829)
SSO does not support multi-cert config (Ticket #1853)
NetSuite Saved Search Pagination (Ticket #1869)
Many of our recent changes come from user insights, so please don't hesitate to drop us a line at firstname.lastname@example.org!