(Glue-2205) v3.1 Replication processes

Processes are the components of a workflow that move data from one object to another. They can be executed and monitored.

Get processes information

In this section:

Resource GET /processes serve as the main way to list all available Extraction Processes. It supports the following input parameters:

Parameter name	Description	Usage	Notes

Parameter name	Description	Usage	Notes
tableName	Filtering based on SNP Glue™ table name	Optional	Array input possible; if used, other parameters are ignored
package	Filtering based on the SAP development package	Optional	Array input possible
author	Filtering based on the author	Optional	Array input possible
processID	Filtering based on the process ID	Optional	Array input possible

All input parameters are case insensitive.

Example of the REST API call:

GET	http://servername:portnumber/dvd/glue/api/v3_1/processes?sap-client=clientnumber

GET	http://servername:portnumber/dvd/glue/api/v3_1/processes?sap-client=clientnumber

JSON body:

{
    "tableName": [
        " ZTS_SFLIGHT",
        " ZZK_ERPVAL"
    ]
}

Output:

{
  "processes": [
    {
      "name": "ZAP_SFLIGHT_1_P",
      "description": "ZAP_SFLIGHT_1_P",
      "systemId": "NSD",
      "package": "ZAP_GLUE_TEST",
      "createdOn": "2019-11-04",
      "modifiedOn": "2020-03-25",
      "createdBy": "APOLTANO",
      "transformation": [
        {
          "targetField": "GLREQUEST",
          "type": "E",
          "expression": "GL_REQUEST( )"
        },
        { "targetField": "MANDT", "type": "=", "expression": "MANDT" },
        { "targetField": "CARRID", "type": "=", "expression": "CARRID" },
        { "targetField": "CONNID", "type": "=", "expression": "CONNID" },
        { "targetField": "FLDATE", "type": "=", "expression": "FLDATE" },
        { "targetField": "PRICE", "type": "C", "expression": "PRICE" },
        { "targetField": "CURRENCY", "type": "=", "expression": "CURRENCY" },
        { "targetField": "PLANETYPE", "type": "=", "expression": "PLANETYPE" },
        { "targetField": "SEATSMAX", "type": "=", "expression": "SEATSMAX" },
        { "targetField": "SEATSOCC", "type": "=", "expression": "SEATSOCC" },
        {
          "targetField": "PAYMENTSUM",
          "type": "C",
          "expression": "PAYMENTSUM"
        },
        {
          "targetField": "SEATSMAX_B",
          "type": "=",
          "expression": "SEATSMAX_B"
        },
        {
          "targetField": "SEATSOCC_B",
          "type": "=",
          "expression": "SEATSOCC_B"
        },
        {
          "targetField": "SEATSMAX_F",
          "type": "=",
          "expression": "SEATSMAX_F"
        },
        { "targetField": "SEATSOCC_F", "type": "=", "expression": "SEATSOCC_F" }
      ],
      "fetcher": [
        {
          "id": "ZAP_SFLIGHT_1_F",
          "description": "ZAP_SFLIGHT_1_F",
          "type": "SAP Table Fetcher",
          "parameters": [
            {
              "paramName": "DELTA_FIELD",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "FLDATE",
              "high": ""
            },
            {
              "paramName": "DELTA_TYPE",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "DATE",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 1,
              "sign": "",
              "opti": "",
              "low": "CARRID",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 2,
              "sign": "",
              "opti": "",
              "low": "CURRENCY",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 3,
              "sign": "",
              "opti": "",
              "low": "FLDATE",
              "high": ""
            },
            {
              "paramName": "LOAD_TYPE",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "F",
              "high": ""
            },
            {
              "paramName": "TABLE_NAME",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "SFLIGHT",
              "high": ""
            }
          ]
        }
      ],
      "consumer": [
        {
          "id": "ZAP_SFLIGHT_1_C",
          "description": "ZAP_SFLIGHT_1_C",
          "type": "GLUE Table Consumer",
          "parameters": [
            {
              "paramName": "GLUE_TABLE_NAME",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "ZAP_SFLIGHT_1",
              "high": ""
            },
            {
              "paramName": "TRUNCATE_TARGET",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "",
              "high": ""
            }
          ]
        }
      ]
    },
    {
      "name": "ZTS_SFLIGHT_E",
      "description": "SF.",
      "systemId": "NSD",
      "package": "ZTS_TEST",
      "createdOn": "2020-02-17",
      "modifiedOn": "2020-02-17",
      "createdBy": "TSLANINK",
      "transformation": [
        { "targetField": "MANDT", "type": "=", "expression": "MANDT" },
        { "targetField": "CARRID", "type": "=", "expression": "CARRID" },
        { "targetField": "CONNID", "type": "=", "expression": "CONNID" },
        { "targetField": "FLDATE", "type": "=", "expression": "FLDATE" },
        {
          "targetField": "GLREQUEST",
          "type": "E",
          "expression": "GL_REQUEST( )"
        },
        { "targetField": "PRICE", "type": "C", "expression": "PRICE" },
        { "targetField": "CURRENCY", "type": "=", "expression": "CURRENCY" },
        { "targetField": "PLANETYPE", "type": "=", "expression": "PLANETYPE" },
        { "targetField": "SEATSMAX", "type": "=", "expression": "SEATSMAX" },
        { "targetField": "SEATSOCC", "type": "=", "expression": "SEATSOCC" },
        {
          "targetField": "PAYMENTSUM",
          "type": "C",
          "expression": "PAYMENTSUM"
        },
        {
          "targetField": "SEATSMAX_B",
          "type": "=",
          "expression": "SEATSMAX_B"
        },
        {
          "targetField": "SEATSOCC_B",
          "type": "=",
          "expression": "SEATSOCC_B"
        },
        {
          "targetField": "SEATSMAX_F",
          "type": "=",
          "expression": "SEATSMAX_F"
        },
        { "targetField": "SEATSOCC_F", "type": "=", "expression": "SEATSOCC_F" }
      ],
      "fetcher": [
        {
          "id": "ZTS_SFLIGHT_F",
          "description": "SF.",
          "type": "SAP Table Fetcher",
          "parameters": [
            {
              "paramName": "DELTA_FIELD",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "",
              "high": ""
            },
            {
              "paramName": "DELTA_TYPE",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "FULL",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 1,
              "sign": "",
              "opti": "",
              "low": "CARRID",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 2,
              "sign": "",
              "opti": "",
              "low": "CONNID",
              "high": ""
            },
            {
              "paramName": "FILTER",
              "numb": 3,
              "sign": "",
              "opti": "",
              "low": "FLDATE",
              "high": ""
            },
            {
              "paramName": "LOAD_TYPE",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "F",
              "high": ""
            },
            {
              "paramName": "TABLE_NAME",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "SFLIGHT",
              "high": ""
            }
          ]
        }
      ],
      "consumer": [
        {
          "id": "ZTS_SFLIGHT_C",
          "description": "SF.",
          "type": "GLUE Table Consumer",
          "parameters": [
            {
              "paramName": "GLUE_TABLE_NAME",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "ZTS_SFLIGHT",
              "high": ""
            },
            {
              "paramName": "TRUNCATE_TARGET",
              "numb": 0,
              "sign": "",
              "opti": "",
              "low": "",
              "high": ""
            }
          ]
        }
      ]
    }
  ]
}

Functionality is implemented in the SAP class /DVD/GL_EXT2_API_PROCESSES_V3.

Edit a process

The endpoint PATCH /processes allow editing process parameters like fetcher delta type, filters, etc.

Parameter name	Description	Usage	Type

Parameter name	Description	Usage	Type
processes	Array of processes to be patched, the format is the same as the get /processes output	Mandatory	JSON object

All input parameters are case insensitive.

When changing components “parameters”, all the parameters need to be specified, including the ones that will not be modified.

When passing filter parameters, the field “numb” needs to be set to value 1.

   ... {
            "paramName": "FILTER",
            "numb": 1,
            "sign": "",
            "opti": "",
            "low": "CARRID",
            "high": ""
       }, ...

For all the other parameters, the field “numb” needs to be set to value 0.

Example of the REST API call:

PATCH	http://servername:portnumber/dvd/glue/api/v3_1/processes?sap-client=clientnumber

Functionality is implemented in the SAP class /DVD/GL_EXT2_API_PROCESSES_V3