Load

Final part of the ETL starts with L -- Load

The Load Part of ETL provides the support of using the transformed JSON as valuable data.

The Load part again has different sections which includes.

Object

The Object as a Load provides the functionality to Create or Update Standard or Custom Object Records using the values from the Transformed JSON.

The user can provide a filter condition, based on the filter condition, the Load will be executed.

Apex Class

The apex class as Load helps to execute a custom class which by taking the input parameters as the Transformed JSON Note : To use Apex Class the custom class must implement the IICResponseHandler Class.

External Service

The External Service as a Load Source helps to Execute an Integration Channel by providing the Transformed JSON as a Request Payload for the target channel.

Note : The channel must be active.

Data Store

This as a Load Source helps the user to store the data from transformed JSON in the Platform Cache, which can be further extracted using the Data Store Key.

Data Mapper of ETL

The Data Mapper in ETL makes it easier to Map by getting the Path from the Extracted JSON and Transformed JSON.

The Data Mapper it self is divided into different sections, which includes.

Mapping Options

Mapping option does give the functionality to get the Extract and Transform JSON so that the user can get the desired path from the respective.

In the above picture we can see that the Mapper allows us to select the Path from the Extracted JSON.

Mapping Editor

The Mapping Editor previews the selected path including the Functions if used

When the Extracted Data is used, then an additional $DS is appended to the path so that it can be differentiated from the Transformed JSON.

Below picture shows the Path selected from Transformed JSON.

Functions

The functions section helps the user to select any function from the list of 200 OK Standard Functions, which will enhance the functionality of ETL.