(Glue-2011) /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

Mandatory

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