> For the complete documentation index, see [llms.txt](https://200ok.gitbook.io/200ok-documents/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://200ok.gitbook.io/200ok-documents/user-manual/etl/create-your-etl/load.md).

# 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.

<figure><img src="https://lh7-us.googleusercontent.com/TWlfSsmz0zfnU6SAZtPQH8v4gX8qckrKbcImozcN6a3qNqpEHxVZMsvxE0bgxs_csmeBE2qo_nTyexM0AUaTa7d7zR54htlhzoxN6o_J44PxhpV-xOmfX4ohqm75osqUQTNJcGuN_bq5wiuJIrYvf9s" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/3I7NiXg4Vn6bRXvsVLNlscUWob9aVpLciJ-w-w6Q1bP2T4SJr3rfqqCY2J6IWRT02DU-iiUHt4IzrK9QvjaUwT1j4kQTK0oKE7utO55NJ2BSKM8C5y5Ic3odP8kWPbJLWCUhTjCGeK_jbESZ8OxHAew" alt=""><figcaption></figcaption></figure>

The Load part again has different sections which includes.

**Object**

<figure><img src="https://lh7-us.googleusercontent.com/Gp2JPcCula_TA_UHgMtSCylY_77XvDoef26ePnATN9oRh79hv_IVHjQUupULCgKsxREdVLe1iah5I7nwQw1aILw6jZAvG3TwhtcRFfMkbnmaEhVBakIiSEyjBvwAUZiIQ3Xr3z2xEv-3zbc2zsxZp9o" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://lh7-us.googleusercontent.com/TLFZhtn-XAM3Zlno6YLfiVeTjAzvNYIp8P4g91SH_37VZ-ce_g_noaJuP0bMjZyPWJbJcc5sRgca8BR6VM3b_6_n2W1SwC9u-dwA_l3FHuoM0a2IVz2Yo5Apia187ap3uYkpHRdsEpY9XmKYxuKDnxQ" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://lh7-us.googleusercontent.com/gZwH4eSmZ39D_lz_LGviaglLbLxnRFxicVmHddtXi7mbhd2LiL7T63Q606tpMPDlXcBse841sz1KcwdsxpBdw0WcgJsH0ig2K1QhbUHw--MSboSppWqSKIqSjqMJl2QRzIq5Y8iHR1N89TlCTSd4f-o" alt=""><figcaption></figcaption></figure>

**External Service**

<figure><img src="https://lh7-us.googleusercontent.com/hdRgNWyEFK-Jf7z50jrEKfw1dJnQWblBEUlxdHe9Xuk1WAV2W4PewrHQ4g0ssnHxahOHfdhkOCDTJNImSlw26FJonvY9IIEdpx3LJ9HZcVs503MWdlwZVB5bE94GojBxY45dpSUL4FzyRtmRkKSCrtg" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://lh7-us.googleusercontent.com/ag__izwVhyKAsVnTjGrzmsEED1WpTzPN50MO2RK4HDnYjP8H0ps0SL38Ua1PR_UUt0QGkd9YqWpQx1O8GR_btP_ohYLxbdB3j2waQhPmnkrZn57HhwUGaam1iJOIZrxqbeqWbGCxjHya8i8OrjvHXq0" alt=""><figcaption></figcaption></figure>

**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.

<figure><img src="https://lh7-us.googleusercontent.com/qplMkcLI8AtkVkhcUWblgCkm8Kk44RNRGk90jufd9EJcbAIkpED9L4gBP1tul7BQS2XGkWzjruj3x-vLCITqqEgf0mHRR8dCxyG5WxkvacDbaMXwjHvEHx-APVYA6CgPt_E-9Gcp838XtknRSVOjnc0" alt=""><figcaption></figcaption></figure>

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

**Mapping Options**

<figure><img src="https://lh7-us.googleusercontent.com/qCpDoeDulJ_KEupkORyTJ7CaJxBbyrGz50UrgbU67eGpI0TZTLZ5fqhdSg0ENn9IrK2DEmRxMZgX8hHetg6WR5HMZk_o4Ghmh1xn4qDSNjf-cIqZx4i8O-ck5seX5jc28RwyJBrknCHz4WwH60wBmXE" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://lh7-us.googleusercontent.com/logmVHjmAeUbkWSBaMcdAQpwHdSSVYtf495K0InX3_NvIcTgpv_UnkNy3vph3ERiOD1G5bmcqhkdICSVt8RFEhiSjXo8oncNQsGG83d6-_ypefsRmLuTYPf6RFPwbQW84AKYQUffzYZONixhRTmDIpE" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://lh7-us.googleusercontent.com/8byawyQe-Wn4tfojn0uyZHHlzCSpxQjilctRF3gSTfQmTqYe9UCHSnJdLaSwTg2yoTmyxcXDgKeaLqVNYn2ybj8_L92ASYJa-I_NmLYi35evrHzUgYhBGFQl5RJ2Z1bF3iBoLyIPnFTiUzGy5FIBrZ8" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://lh7-us.googleusercontent.com/ewX7PpNsiLB8cylJfHlgV-3ULkwfm6iWXQSZCoQVDE8_6G40oi29fds73NkATPkIcA9BaifssolK1RvWd63KW_FL13-FiCuG5upplOynT1cYqlKFwy4CHbzwQp-3nRirlKJ-okFBfi42gFInD1EfH2s" alt=""><figcaption></figcaption></figure>

**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.

<figure><img src="https://lh7-us.googleusercontent.com/oC9dK24rr7AYAZyyHa-ART76Cq1mtyXC8McEndp8z5ZA_QjkMdY8a8aCIh7wm6UIWuHX3Yvo6p9yV-DtmEI50P8l0tL82YNqr5d7_-RrXzpTS6zmLCUsh6XHjqivZpBkUluauFo8fAq7VYAGDJd9818" alt=""><figcaption></figcaption></figure>
