Release Notes 200 OK Version 4.6.0

Release Notes - Package Version 4.6.0

Description

This release brings some of the much anticipated feature enhancements such as Calling flow inside Integration Channel, Calling ETL as REST API for executing ETL from outside Salesforce in a secured way with proper authentication, Option to provide Custom JSON while calling ETL using 200 OK standard fx_etl function, Enhanced transformation in ETL with Array support, ETL multiple and multilevel bulk data transformation and so on.

Please refer to the detailed release notes for a complete overview of the changes and improvements in this version.

Package Version: 4.6.0

Table of Contents

New Functionality Enhancements

• Data can be cached using Data Store integration action and ETL Load to retrieve and use later

• Introduced a new standard function fx_invokeFlow to invoke Autolaunched flow within Integration Channel

• Support for passing Custom JSON and Record ID pattern in fx_etl standard function

• Support of dynamic ETL Name for Integration Channel Request Body

• Advanced API support for secure ETL execution from outside Salesforce

• Array/Indexing support of mapping extracted data in Transformation

• Multiple and multi-level [!index] support in ETL Transformation

• Including fields with NULL values as well in Extracted JSON for Query and Object data sources

• Pattern support inside single and multi-level; standard and custom functions

• Provided option to select Object and Record Id while Extracting data in ETL, instead of specifying Record Id

• Support of exporting and importing Action Filters for Integration Channels

• New standard functions fx_encrypt and fx_decrypt to secure the sensitive data during integration with external systems

• Enhanced UI with ability to minimize Data Source and Load Source windows while configuring ETL

• Enhanced introductory Quick assistance on Home page about 200 OK

• Introduced Highlights panel in ETL record page and revamped Log record page

• Support for 200 OK standard and custom functions inside text

• Addition of standard functions: fx_toLowerCase, fx_case

• Support of JSON object mapping in Transformation layer

• Automatcher support in ETL Transformation layer.

Improvements

• Resolved component Error related to Integration Action

• Improved Curl import to set Service Name automatically based on endpoint URL

• Addresses issue with Integration Channel and ETL execution for default logging level

• Revamped file upload functionality for octet-stream content type

• Enhanced Transform value mapping in ETL for setting default mapping value.

New Functionality Enhancements

Functionality	Description
Data can be cached using Data Store integration action and ETL Load to retrieve and use later.	This functionality brings an exciting new feature where input data can be stored in cache using Data Store integration action as well ETL Load and can be retrieved and used later using fx_getDataStore standard 200 OK function.
Introduced a new standard function fx_invokeFlow to invoke Autolaunched flow within Integration Channel.	With the ability to call an Autolaunched flow inside 200 OK integration channel request body, integration action and action filter, more complex business logic can now be implemented in no time without writing any code. This feature extends the application to achieve to-and-fro communication between the Autolaunched flow and 200 OK in a much simpler way than earlier.
Support for passing Custom JSON and Record ID pattern in fx_etl standard function.	Standard fx_etl function now supports passing a custom JSON and Record ID pattern while calling ETL from the Integration Channel request body.
Support of dynamic ETL Name for Integration Channel Request Body.	Same Integration Channel for a given endpoint can be reused for sending different ETL data in the request body dynamically using an index pattern(i.e., {0} pattern).
Advanced API support for secure ETL execution from outside Salesforce.	Users can execute ETL from outside Salesforce as a REST service and also can optionally pass record ID, type and custom JSON in the Request.
Array/Indexing support of mapping extracted data in Transformation.	ETL transformation is enhanced to use index path(e.g., /[1]/) in expected JSON to map and transform complex data.
Multiple and multi-level [!index] support in ETL Transformation.	This functionality will help users in transforming complex multilevel JSON with the help of [!index] pattern.
Including fields with NULL values as well in Extracted JSON for Query and Object data sources.	For Query and Object data source in ETL, Extracted data will now include those fields as well which do not have any value on records and value will be NULL.
Pattern support inside single and multi-level; standard and custom functions.	Now, users can use patterns in both single and multi-level standard/custom functions in the Integration Channel.
Added option to select Object and Record name for Extracting specific record data in ETL Extract.	Instead of explicitly specifying the Record Id, users can search and select a particular Object and Record name for Extracting the record data in ETL Extract.
Support of exporting and importing Action Filters for Integration Channels.	Enhanced Integration channel import and export functionalities to include Action Filters while importing/exporting channels.
New standard functions fx_encrypt and fx_decrypt to secure the sensitive data during integration with external systems.	Encrypt and Decrypt any sensitive information using fx_encrypt and fx_decrypt functions respectively using a custom private key.
Enhanced UI with ability to minimize Data Source and Load Source windows while configuring ETL.	Users can now minimize the window for Data Source and Load Source in ETL while configuring ETL.
Enhanced introductory Quick assistance on Home page about 200 OK.	Revamped 200 OK Home page with Welcome assistance to help new users getting a Quick Start.
Introduced Highlights panel in ETL record page and revamped Log record page.	UI improvement with the use of the highlights panel in ETL record page and revamped Log record page for ease of important fields access.
Support for 200 OK standard and custom functions inside text.	Standard and custom functions can be used inside any text which enables users to perform simple transformations on the go.
Addition of standard functions: fx_toLowerCase, fx_case.	New standard 200 OK functions are introduced to achieve simple data transformation without coding. Convert string to lowercase using fx_toLowerCase Put conditional value using fx_case.
Support of JSON object/list of objects mapping in Transformation layer.	JSON object/list of objects for a given path(e.g., / or /1 or /1[1]) can now be directly mapped to a given key path in the Transformation layer.
Automatcher support in ETL Transformation layer.	Point and click feature to perform automatching of Expected JSON and Extracted JSON based on full path which can save time of manual mapping of fields in Transformation layer.

Improvements

Bug Fix	Description
Resolved component Error related to Integration Action.	To align with Salesforce security standards, the user interface has undergone an update to address the unexpected component errors that were observed in the previous packages.
Improved Curl import to set Service Name automatically based on endpoint URL.	Curl import functionality is improved to auto populate the Service Name based on the endpoint URL.
Addressed issue with Integration Channel and ETL execution.	Resolved issue with executing pre-existing Integration Channels and ETL channels upon application upgrade.
Revamped file upload functionality for octet-stream content type.	File upload using Integration Channel is improved to provide extended support for octet-stream files.
Enhanced Transform value mapping in ETL for setting default mapping value.	Performance is improved for ETL Transformation based on conditional transformation maps to set default and mapped values.