(Glue-2208) /generate

Resource /generate serves as a mass generation function for SNP Glue™ objects.

It supports the following objects and their input parameters:

General parameters

Parameter name	Description	Usage	Notes

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 SNP 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: SNP Glue™ table generation parameter object

Parameter name	Description	Usage	Notes

Parameter name	Description	Usage	Notes
prefix	Object prefix	Mandatory	String
suffix	Object suffix	Optional	String
devclass	Package for object	Mandatory	String
storID	Storage ID	Mandatory	String
meaningFields	Meaningful fieldname	Optional	Boolean
meaningValues	Speaking field values	Optional	Boolean
glRequest	Add SNP Glue™ Request field	Optional	Boolean
glRequestAsKey	Add SNP 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: SNP Glue™ Extractor 2.0

Parameter name	Description	Usage	Notes

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 the 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.