List Masking Method by Name

1 min

POST

{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingMethod

Request Overview

This request is used to list masking methods by name. The request body includes the name parameter, which specifies the name of the masking method to be retrieved. The body is formatted as a JSON object with key-value pairs.

Path Parameters

urlstring
Default
url

Header Parameters

x-xsrf-tokenstring
Default
{{csrftoken}}

Body Parameters

bodyobject
Default
{ "name": "" }

Responses

200List Masking Method by Name

curl

curl --request POST \
     --url {{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingMethod \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --header 'x-xsrf-token: {{csrftoken}}' \
     --data '"{\r\n    \"name\": \"\"\r\n}"'

javascript

var myHeaders = new Headers();
myHeaders.append("accept", "application/json");
myHeaders.append("content-type", "application/json");
myHeaders.append("x-xsrf-token", "{{csrftoken}}");

var raw = JSON.stringify("{\r\n    \"name\": \"\"\r\n}");

var requestOptions = {
   method: 'POST',
   headers: myHeaders,
   body: raw,
   redirect: 'follow'
};

fetch("{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingMethod", requestOptions)
   .then(response => response.text())
   .then(result => console.log(result))
   .catch(error => console.log('error', error));

ruby

require "uri"
require "json"
require "net/http"

url = URI("{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingMethod")

http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::Post.new(url)
request["accept"] = "application/json"
request["content-type"] = "application/json"
request["x-xsrf-token"] = "{{csrftoken}}"
request.body = JSON.dump("{\r\n    \"name\": \"\"\r\n}")

response = http.request(request)
puts response.read_body

python

import requests
import json

url = "{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingMethod"

payload = json.dumps("{\r\n    \"name\": \"\"\r\n}")
headers = {
   'accept': 'application/json',
   'content-type': 'application/json',
   'x-xsrf-token': '{{csrftoken}}'
}

response = requests.request("POST", url, headers=headers, data=payload)

print(response.text)

200

[
    {
        "dbId": -261965,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mssql_Email",
        "description": null,
        "methodPattern": "STUFF(${column},1,7,'MASKED*')",
        "date": null,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261964,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mssql_First_Name",
        "description": null,
        "methodPattern": "REPLACE(${column},'a', 'XXXXX')",
        "date": null,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6791,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MSSQL Masking - Email",
        "description": "MSSQL Masking - Email",
        "methodPattern": "STUFF(${column},1,7,'MASKED*')",
        "date": 1547081014209,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6786,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MSSQL Masking - FIRST_NAME",
        "description": "MSSQL Masking - FIRST_NAME",
        "methodPattern": "REPLACE(${column},'a', 'XXXXX')",
        "date": 1546931296899,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6793,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MSSQL Masking - PhoneNum",
        "description": "MSSQL Masking - PhoneNum",
        "methodPattern": "STUFF(${column},1,5,'xxxxx')",
        "date": 1547083334533,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261966,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mssql_Phone_Number",
        "description": null,
        "methodPattern": "STUFF(${column},1,5,'xxxxx')",
        "date": null,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261968,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mysql_Email",
        "description": null,
        "methodPattern": "REPLACE(${column}, SUBSTRING(${column},1,6), '******')",
        "date": null,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261967,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mysql_First_Name",
        "description": null,
        "methodPattern": "REPLACE(${column}, SUBSTRING(${column},1,3), '***')",
        "date": null,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6790,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MySQL Masking - Email",
        "description": "MySQL Masking - Email",
        "methodPattern": "REPLACE(${column}, SUBSTRING(${column},1,6), '******')",
        "date": 1547016479545,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6787,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MySQL Masking - FIRST_NAME",
        "description": "MySQL Masking - FIRST_NAME",
        "methodPattern": "REPLACE(${column}, SUBSTRING(${column},1,3), '***')",
        "date": 1546931307302,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6792,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "MySQL Masking - PhoneNum",
        "description": "MySQL Masking - PhoneNum",
        "methodPattern": " REPLACE(${column}, SUBSTRING(${column},-4,4), 'xxxx')",
        "date": 1547081823325,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261969,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Mysql_Phone_Number",
        "description": null,
        "methodPattern": "REPLACE(${column}, SUBSTRING(${column},-4,4), 'xxxx')",
        "date": null,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261962,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle_Email",
        "description": null,
        "methodPattern": "REGEXP_REPLACE(${column}, '[A-Za-z]', 'x')",
        "date": null,
        "columnType": "VARCHAR2",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261961,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle_First_Name",
        "description": null,
        "methodPattern": "REGEXP_REPLACE(${column},'(.){3}','*')",
        "date": null,
        "columnType": "VARCHAR2",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6794,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle Masking - Email",
        "description": "Oracle Masking - Email",
        "methodPattern": "REGEXP_REPLACE(${column}, '[A-Za-z]', 'x')",
        "date": 1547084721598,
        "columnType": "varchar",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6788,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle Masking - FIRST_NAME",
        "description": "Oracle Masking - FIRST_NAME",
        "methodPattern": "REGEXP_REPLACE(${column},'(.){3}','***')",
        "date": 1546931311876,
        "columnType": "VARCHAR2",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6795,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle Masking - PhoneNum",
        "description": "Oracle Masking - PhoneNum",
        "methodPattern": "REGEXP_REPLACE(${column}, '[1-4]', 'x')",
        "date": 1547625540153,
        "columnType": "VARCHAR2",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -261963,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Oracle_Phone_Number",
        "description": null,
        "methodPattern": "REGEXP_REPLACE(${column}, '[1-4]', 'x')",
        "date": null,
        "columnType": "VARCHAR2",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    },
    {
        "dbId": -6789,
        "userCreate": null,
        "userUpdate": null,
        "creationDate": null,
        "lastUpdate": null,
        "name": "Teradata Masking - FIRST_NAME",
        "description": "Teradata Masking - FIRST_NAME",
        "methodPattern": "REGEXP_REPLACE(${column}, '(\\w+)(\\s+(\\w+))*', '*') ",
        "date": 1546931318489,
        "columnType": "VARCHAR",
        "hideColumn": false,
        "databaseType": null,
        "firstResult": null,
        "maxResult": null
    }
]