(Glue-2011) /schedule

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.