CRUD API: API for create,update,and delete operations

• Starter
• Business
• Enterprise
• On-Premise
• Add-on

Overview

In Etlworks, you can create REST APIs for CRUD operations by creating event-driven Flows and selecting the appropriate method when defining the HTTP Listener parameters.

Supported HTTP methods

The following methods are supported:

• POST: select POST as a method when creating an HTTP Listener. Then create an event-driven Flow where a destination is an object you would like to update. If the destination is a database, use a Destination query to update the table(s). Assuming that the HTTP Listener URL has parameters, you can tokenize the destination query: update patient set name={name} where patientid = {patientid}. 

If POST is selected as an HTTP method: the Flow will be executed asynchronously, meaning that the calling code will receive a response before the Flow has actually been executed.

• PUT: follow the same steps as above when the method is POST, with the exception of selecting PUT as the method when creating the HTTP Listener. 

If PUT is selected as the HTTP method: the Flow will be executed synchronously, meaning the calling code will receive a response after the Flow has been executed.

• DELETE: create a Flow similar to how you would create it if the method was GET, except that you need to select DELETE as the method when creating the Listener. At that time, you can change the Successful DELETE response code to configure what code should be returned on a successful delete. 

If DELETE is selected as the HTTP method: the Flow will be executed synchronously, meaning the calling code will receive a response after the Flow has been executed.