Transform Data on Demand: ETL as an API!
Last updated
Last updated
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.
To check the ETL as API let us .
In the target Salesforce org, ETL channel has to be created and configured with required Data Source/Transform Source/Load Source details as needed.
Copy the ETL name and paste it in the endpoint url.
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!