(Glue-2008) /generate
Resource /generate serves as a mass generation function for Glue objects.
It supports the following objects and their input parameters:
General parameters
Parameter name | Description | Usage | Notes |
SAPTableName | Source SAP tables | Mandatory | Array with the list of SAP tables for which to generate a replication object |
GlueTableSett | Parameters for Glue table generation | Mandatory | JSON object |
ext2Sett | Parameters for Extractors 2.0 generation | Mandatory | JSON object |
asyncExec | Execute generation in a background job (Asynchronous) | Optional | ‘’ or ‘X’ |
GlueTableSett: Glue table generation parameter object
Parameter name | Description | Usage | Notes |
prefix | Object prefix | Mandatory | string |
suffix | Object suffix | Optional | string |
devclass | Package for object | Mandatory | string |
storID | Storage ID | Optional | string |
meaningFields | Meaningful fieldname | Optional | boolean |
meaningValues | Speaking field values | Optional | boolean |
glRequest | Add Glue Request field | Optional | boolean |
glRequestAsKey | Add Glue request as a key | Optional | boolean |
CSVFolderName | File storage folder name | Obligatory in case of file storages | Default <GLUE_TABNAME> |
CSVDelimiter | file storage – Delimiter type | Obligatory in case of file storages | string |
CSVQuotes | file storage – Put values into quotes | Optional | boolean |
CSVEscaping | file storage – Use extended escaping | Optional | boolean |
CSVHeader | file storage – Include table header | Optional | boolean |
CSVOneFile | file storage – One file extraction | Optional | boolean |
CSVCompress | file storage – Compress file | Optional | boolean |
CSVCompressLevel | file storage – Compression level | Optional | int |
ext2Sett: Glue Extractor 2.0
Parameter name | Description | Usage | Notes |
prefix | Object prefix | Mandatory | Must start with Z* |
suffixFetcher | Fetcher suffix | Optional | For example `_F` |
suffixConsumer | Consumer suffix | Optional | For example `_C` |
suffixProcess | Extraction process suffix | Optional | For example `_P` |
devclass | Package for object | Mandatory | String |
deltaType | Delta type | Mandatory | string |
loadType | Load type | Mandatory | string |
keyFieldsFilter | Add key fields as a selection parameter | Optional | boolean |
noActivation | Do not activate objects | Optional | boolean |
useDeduplication | Use deduplication | Optional | boolean |
All input parameters are case insensitive.
Example of REST API call:
http://servername:portnumber/dvd/glue/api/v2/generate?sap-client=800
JSON body:
{
"SAPTableName": [
"DD02L",
"DD01L"
],
"GlueTableSett": {
"prefix": "ZGL_",
"devclass": "$TMP",
"glRequest": "X",
"glRequestAsKey": "X"
},
"ext2Sett": {
"prefix": "ZGL_",
"devclass": "$TMP",
"suffixFetcher": "_F",
"suffixConsumer": "_C",
"suffixProcess": "_P",
"deltaType": "FULL",
"loadType": "F"
}
}
Example of the REST API output:
Note: If the job is scheduled in the background, the HTTP response code is set to 200 with information about Job
“200 Generation scheduled under Job name - ZDVD_GLUE_OBJ_GEN_MCHOMA”
Functionality is implemented in the SAP class /DVD/GL_EXT2_API_GENERATE.
Error handling
Every error message is raised via code 400. The reason for the error is also provided; however further investigation might be needed on the SAP side.