ETL Application APIs

Gathr’s REST API supports the following actions on ETL applications:


Start ETL Application

This API will start a Gathr ETL application with the following REST call.

Request URL

POST https://app.gathr.one/api/v1/application/start

Headers

Parameter NameDescription
Content-Typeapplication/json
Authorization< gathr-user-token >

Request Body

{
"name":"<your_etl_app_name>",
"appType":"etl",
"projectName":"<your_project_name>"
}

Request Body Parameters

NameRequiredDescription
nameYESThe name of the ETL application to be started.
appTypeYESThe type of the Gathr application that should be started. Value to be provided - etl
projectNameYESGathr project name containing ETL application to be started.

Response

HTTP Status Code: 200

{"message": "Request to start the application is accepted.",
"status": "Success"}

HTTP Status Code: 400

{"message": "<A description of the error will be provided.>",
"status": "Error"}

Stop ETL Application

This API will stop a Gathr ETL application with the following REST call.

Request URL

POST https://app.gathr.one/api/v1/application/stop

Headers

Parameter NameDescription
Content-Typeapplication/json
Authorization< gathr-user-token >

Request Body

{
"name":"<your_etl_app_name>",
"appType":"etl",
"projectName":"<your_project_name>"
}

Request Body Parameters

NameRequiredDescription
nameYESThe name of the ETL application to be stopped.
appTypeYESThe type of the Gathr application that should be stopped. Value to be provided - etl
projectNameYESThe Gathr project name containing the ETL application to be stopped.

Response

HTTP Status Code: 200

{"message": "Request to stop the application is accepted.",
"status": "Success"}

HTTP Status Code: 400

{"message": "<A description of the error will be provided.>",
"status": "Error"}

Get ETL Application Status

This API will get the status of a Gathr ETL application with the following REST call.

Request URL

GET https://app.gathr.one/api/v1/application/status/<appType>/<appName>

Headers

Parameter NameDescription
Content-Typeapplication/json
Authorization< gathr-user-token >

Query Parameters

NameRequiredDescription
appTypeYESThe type of the Gathr application to fetch the status. Value to be provided - etl
appNameYESThe name of the ETL application for which the status is to be fetched.

Response

HTTP Status Code: 200

{"application_status": "STOPPED",
"status": "Success"}
{"application_status": "STARTING",
"status": "Success"}
{"application_status": "RUNNING",
"status": "Success"}
{"application_status": "ERROR",
"status": "Success"}

HTTP Status Code: 400

{"message": "<A description of the error will be provided.>",
"status": "Error"}

Update ETL Application

This API will update a Gathr ETL application with the following REST call.

Request URL

POST https://app.gathr.one/api/v1/application/update

Headers

Parameter NameDescription
Content-Typeapplication/json
Authorization< gathr-user-token >

Request Body

{
"name":"<your_etl_app_name>",
"appType":"etl",
"projectName":"<your_project_name>",
"componentId":"<yourS3ChannelComponentID>",
"bucketName":"<yourS3BucketName>",
"filename":["file-1.csv,file-2.csv,file-3.csv"]
}

Request Body Parameters

NameRequiredDescription
nameYESThe name of the ETL application to be updated.
appTypeYESThe type of the Gathr application that should be updated. Value to be provided – etl
projectNameYESThe Gathr project name containing the ETL application to be updated.
componentIdYESThe component ID of the S3 Batch Data Source.
Note: Right-click a component to see its component ID on the ETL canvas, as shown in the image below:
component_id
bucketNameYESThe bucket name to be updated in the component’s configuration should be provided.
filenameYESThe array of files to be to be updated in the component’s configuration should be provided.

Response

HTTP Status Code: 200

{"message": " Application updated successfully.",
"status": "Success"}

HTTP Status Code: 400

{"message": "<A description of the error will be provided.>",
"status": "Error"}
Top