Transform Data on Demand: ETL as an API!

With recent enhancements in version 4.6 and onwards, you can now securely invoke an ETL from outside Salesforce, as long as you have the proper authentication.

1. To check the ETL as API let us Create an ETL .

2. In the target Salesforce org, ETL channel has to be created and configured with required Data Source/Transform Source/Load Source details as needed.

3. Copy the ETL name and paste it in the endpoint url.

4. Endpoint URL will be in the below format

https://<YOUR_DOMAIN_URL>/services/apexrest/lwapic/lws/etl/ETL_CHANNEL_NAME?recordId=RECORD_ID&type=TYPE

YOUR_DOMAIN_URL - Target Salesforce org domain URL

ETL_CHANNEL_NAME - ETL Channel unique name

RECORD_ID - Dynamic record ID(optional)

TYPE - (Optional) It can be used one of the following: E, T, L, ET, EL, TL, ETL.

It is considered as ETL by default, if not specified.

NOTE: If Load is used while invoking, Extracted/Transformed JSON cannot be retrieved using this callout. In case, either of E, T, ET is used, the Extracted or Transformed JSON is returned as the Response Body.

Method:

GET/POST

Header:

Authorization for a valid Salesforce User(or Integration User)

Content-Type(if applicable, such as for POST method)

Other Header Information(as required)

Body:

Custom JSON(if applicable, such as for POST method)

This is how you can power up your ETL by invoking it as an API!