(Glue-2111) /schedule
- SNP
- Marian Vidra
The resource/schedule serves as the main way to execute the Extraction Process to run immediately. It supports the following input parameters:
Parameter name | Description | Usage | Notes |
processID | Filtering based on the process ID | Mandatory |
|
loadType | Delta type of the load, default value is “F” (Full load) | Optional |
|
truncate | Option to truncate the table before the data load, the default value is “” (Don’t truncate) | Optional |
|
packageSize | Option to set the number of rows for each package, the default value is 10.000 | Optional |
|
previewMode | Option to view data from a source before Extraction Process | Optional | Use with packageSize parameter, max value is 1000; default is 20 |
variant | The existing variant name for the extractor process report. | Optional |
|
All input parameters are case insensitive.
Example of REST API call:
http://servername:portnumber/dvd/glue/api/v2/schedule?sap-client=800
JSON body:
{
"processid": "ZTS_SFLIGHT",
"packagesize": "1000",
"truncate": "X",
"loadtype": "E"
}
Example of the REST API output:
{
“requestId”: 281309
}
Note: If the job is not executed within 20 seconds after the submission of the job, requestId is set to 0.
Example of the REST API output for preview mode:
JSON body:
{
"processid": "ZIG_SFLIGHT_P",
"packagesize": "50",
"previewmode": "X"
}
Example of the REST API output for preview mode:
Load Type values:
F Full Load (Repair) Without Delta Update
D Delta Load
I Delta Init Without Data
L Delta Init + Full Load
Truncate values:
X Truncate the target table
„empty value“ No truncate
Functionality is implemented in the SAP class /DVD/GL_EXT2_API_SCHEDULE.