Help Desk

Submit a ticket My Tickets
Welcome
Login

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.

Featured Highlights

Platform Enhancements

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.  

Connectors (BizApps)

Relational BizApps

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

Oracle PCMCS

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.

Read the Docs

Salesforce

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. 

Other

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.  

Defects

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 support@onecloud.io!