URL Pattern for user-defined API

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

URL Pattern 

In Etlworks, you define an endpoint by specifying the URL Pattern parameter when creating an HTTP Listener.

Only one HTTP Listener with that particular URL Pattern can exist at the same time. For example, you cannot create multiple HTTP Listeners with the URL Pattern/patients. However, you can create a Listener with the URL Pattern /patients and another Listener with the URL Pattern /patient.

User-defined API endpoint URL

The endpoint URL is defined as https://etlworks_base_url/rest/v1/httplistener/url_pattern.

Example: https://app.etlworks.com/rest/v1/httplistener/patients

URL parameters

Within the URL Pattern, you can specify path parameters: /patients/{patientid}. They will be automatically converted to Flow variables, which can then be referenced from the source SQL, FROM and TO fields or accessed programmatically.

An example of an endpoint with path parameters

URL Pattern: /patients/{patientid}
Actual URL: https://app.etlworks.com/rest/v1/httplistener/hl7/patients/123

An example of source SQL with parameters

select * from patient where patientid = {patientid}