Processes are the components of a workflow that move data from one object to another. They can be executed and monitored.
Get processes information
Resource GET /processes serve as the main way to list all available Extraction Processes. It supports the following input parameters:
| | | |
|---|
tableName | Filtering based on Glue table name | Optional | Array input possible; if used, other parameters are ignored |
package | Filtering based on the SAP development package | Optional | Array input possible |
author | Filtering based on the author | Optional | Array input possible |
processID | Filtering based on the process ID | Optional | Array input possible |
All input parameters are case insensitive.
Example of the REST API call:
GET http://servername:portnumber/dvd/glue/api/v3/processes?sap-client=800
JSON body:
{
"tableName": [
" ZTS_SFLIGHT",
" ZZK_ERPVAL"
]
}Output:
{
"processes": [
{
"name": "ZAP_SFLIGHT_1_P",
"description": "ZAP_SFLIGHT_1_P",
"systemId": "NSD",
"package": "ZAP_GLUE_TEST",
"createdOn": "2019-11-04",
"modifiedOn": "2020-03-25",
"createdBy": "APOLTANO",
"transformation": [
{
"targetField": "GLREQUEST",
"type": "E",
"expression": "GL_REQUEST( )"
},
{ "targetField": "MANDT", "type": "=", "expression": "MANDT" },
{ "targetField": "CARRID", "type": "=", "expression": "CARRID" },
{ "targetField": "CONNID", "type": "=", "expression": "CONNID" },
{ "targetField": "FLDATE", "type": "=", "expression": "FLDATE" },
{ "targetField": "PRICE", "type": "C", "expression": "PRICE" },
{ "targetField": "CURRENCY", "type": "=", "expression": "CURRENCY" },
{ "targetField": "PLANETYPE", "type": "=", "expression": "PLANETYPE" },
{ "targetField": "SEATSMAX", "type": "=", "expression": "SEATSMAX" },
{ "targetField": "SEATSOCC", "type": "=", "expression": "SEATSOCC" },
{
"targetField": "PAYMENTSUM",
"type": "C",
"expression": "PAYMENTSUM"
},
{
"targetField": "SEATSMAX_B",
"type": "=",
"expression": "SEATSMAX_B"
},
{
"targetField": "SEATSOCC_B",
"type": "=",
"expression": "SEATSOCC_B"
},
{
"targetField": "SEATSMAX_F",
"type": "=",
"expression": "SEATSMAX_F"
},
{ "targetField": "SEATSOCC_F", "type": "=", "expression": "SEATSOCC_F" }
],
"fetcher": [
{
"id": "ZAP_SFLIGHT_1_F",
"description": "ZAP_SFLIGHT_1_F",
"type": "SAP Table Fetcher",
"parameters": [
{
"paramName": "DELTA_FIELD",
"numb": 0,
"sign": "",
"opti": "",
"low": "FLDATE",
"high": ""
},
{
"paramName": "DELTA_TYPE",
"numb": 0,
"sign": "",
"opti": "",
"low": "DATE",
"high": ""
},
{
"paramName": "FILTER",
"numb": 1,
"sign": "",
"opti": "",
"low": "CARRID",
"high": ""
},
{
"paramName": "FILTER",
"numb": 2,
"sign": "",
"opti": "",
"low": "CURRENCY",
"high": ""
},
{
"paramName": "FILTER",
"numb": 3,
"sign": "",
"opti": "",
"low": "FLDATE",
"high": ""
},
{
"paramName": "LOAD_TYPE",
"numb": 0,
"sign": "",
"opti": "",
"low": "F",
"high": ""
},
{
"paramName": "TABLE_NAME",
"numb": 0,
"sign": "",
"opti": "",
"low": "SFLIGHT",
"high": ""
}
]
}
],
"consumer": [
{
"id": "ZAP_SFLIGHT_1_C",
"description": "ZAP_SFLIGHT_1_C",
"type": "GLUE Table Consumer",
"parameters": [
{
"paramName": "GLUE_TABLE_NAME",
"numb": 0,
"sign": "",
"opti": "",
"low": "ZAP_SFLIGHT_1",
"high": ""
},
{
"paramName": "TRUNCATE_TARGET",
"numb": 0,
"sign": "",
"opti": "",
"low": "",
"high": ""
}
]
}
]
},
{
"name": "ZTS_SFLIGHT_E",
"description": "SF.",
"systemId": "NSD",
"package": "ZTS_TEST",
"createdOn": "2020-02-17",
"modifiedOn": "2020-02-17",
"createdBy": "TSLANINK",
"transformation": [
{ "targetField": "MANDT", "type": "=", "expression": "MANDT" },
{ "targetField": "CARRID", "type": "=", "expression": "CARRID" },
{ "targetField": "CONNID", "type": "=", "expression": "CONNID" },
{ "targetField": "FLDATE", "type": "=", "expression": "FLDATE" },
{
"targetField": "GLREQUEST",
"type": "E",
"expression": "GL_REQUEST( )"
},
{ "targetField": "PRICE", "type": "C", "expression": "PRICE" },
{ "targetField": "CURRENCY", "type": "=", "expression": "CURRENCY" },
{ "targetField": "PLANETYPE", "type": "=", "expression": "PLANETYPE" },
{ "targetField": "SEATSMAX", "type": "=", "expression": "SEATSMAX" },
{ "targetField": "SEATSOCC", "type": "=", "expression": "SEATSOCC" },
{
"targetField": "PAYMENTSUM",
"type": "C",
"expression": "PAYMENTSUM"
},
{
"targetField": "SEATSMAX_B",
"type": "=",
"expression": "SEATSMAX_B"
},
{
"targetField": "SEATSOCC_B",
"type": "=",
"expression": "SEATSOCC_B"
},
{
"targetField": "SEATSMAX_F",
"type": "=",
"expression": "SEATSMAX_F"
},
{ "targetField": "SEATSOCC_F", "type": "=", "expression": "SEATSOCC_F" }
],
"fetcher": [
{
"id": "ZTS_SFLIGHT_F",
"description": "SF.",
"type": "SAP Table Fetcher",
"parameters": [
{
"paramName": "DELTA_FIELD",
"numb": 0,
"sign": "",
"opti": "",
"low": "",
"high": ""
},
{
"paramName": "DELTA_TYPE",
"numb": 0,
"sign": "",
"opti": "",
"low": "FULL",
"high": ""
},
{
"paramName": "FILTER",
"numb": 1,
"sign": "",
"opti": "",
"low": "CARRID",
"high": ""
},
{
"paramName": "FILTER",
"numb": 2,
"sign": "",
"opti": "",
"low": "CONNID",
"high": ""
},
{
"paramName": "FILTER",
"numb": 3,
"sign": "",
"opti": "",
"low": "FLDATE",
"high": ""
},
{
"paramName": "LOAD_TYPE",
"numb": 0,
"sign": "",
"opti": "",
"low": "F",
"high": ""
},
{
"paramName": "TABLE_NAME",
"numb": 0,
"sign": "",
"opti": "",
"low": "SFLIGHT",
"high": ""
}
]
}
],
"consumer": [
{
"id": "ZTS_SFLIGHT_C",
"description": "SF.",
"type": "GLUE Table Consumer",
"parameters": [
{
"paramName": "GLUE_TABLE_NAME",
"numb": 0,
"sign": "",
"opti": "",
"low": "ZTS_SFLIGHT",
"high": ""
},
{
"paramName": "TRUNCATE_TARGET",
"numb": 0,
"sign": "",
"opti": "",
"low": "",
"high": ""
}
]
}
]
}
]
}
Functionality is implemented in the SAP class /DVD/GL_EXT2_API_PROCESSES.
Edit a process
The endpoint PATCH /processes allow editing process parameters like fetcher delta type, filters, etc.
| | | |
|---|
processes | array of processes to be patched, the format is the same as the get /processes output | Mandatory | JSON object |
All input parameters are case insensitive.
When changing components “parameters”, all the parameters need to be specified, including the ones that will not be modified.
When passing filter parameters, the field “numb” needs to be set to value 1.
... {
"paramName": "FILTER",
"numb": 1,
"sign": "",
"opti": "",
"low": "CARRID",
"high": ""
}, ...For all the other parameters, the field “numb” needs to be set to value 0.
Example of the REST API call:
Functionality is implemented in the SAP class /DVD/GL_EXT2_API_PROCESSES.