Edit Masking Policy

curl --request POST \
     --url {{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --header 'x-xsrf-token: {{csrftoken}}' \
     --data '"{\r\n    \"dbId\": 390577,\r\n    \"name\": \"Masking new\",\r\n    \"description\": \"Masking\",\r\n    \"deviceDbId\": 390457,\r\n    \"active\": null,\r\n    \"rowLimit\": null,\r\n    \"schema\": \"*\",\r\n    \"table\": \"*\",\r\n    \"column\": \"*\",\r\n    \"methodDbId\": -261965\r\n}\r\n"'

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    \"dbId\": 390577,\r\n    \"name\": \"Masking new\",\r\n    \"description\": \"Masking\",\r\n    \"deviceDbId\": 390457,\r\n    \"active\": null,\r\n    \"rowLimit\": null,\r\n    \"schema\": \"*\",\r\n    \"table\": \"*\",\r\n    \"column\": \"*\",\r\n    \"methodDbId\": -261965\r\n}\r\n");

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

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

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

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

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    \"dbId\": 390577,\r\n    \"name\": \"Masking new\",\r\n    \"description\": \"Masking\",\r\n    \"deviceDbId\": 390457,\r\n    \"active\": null,\r\n    \"rowLimit\": null,\r\n    \"schema\": \"*\",\r\n    \"table\": \"*\",\r\n    \"column\": \"*\",\r\n    \"methodDbId\": -261965\r\n}\r\n")

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

import requests
import json

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

payload = json.dumps("{\r\n    \"dbId\": 390577,\r\n    \"name\": \"Masking new\",\r\n    \"description\": \"Masking\",\r\n    \"deviceDbId\": 390457,\r\n    \"active\": null,\r\n    \"rowLimit\": null,\r\n    \"schema\": \"*\",\r\n    \"table\": \"*\",\r\n    \"column\": \"*\",\r\n    \"methodDbId\": -261965\r\n}\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)

{
    "dbId": 390577,
    "userCreate": null,
    "userUpdate": null,
    "creationDate": null,
    "lastUpdate": null,
    "name": "Masking new",
    "description": "Masking",
    "date": 1695905980448,
    "tableName": "*",
    "maskBase": null,
    "columnName": "*",
    "maskingMethod": {
        "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
    },
    "device": {
        "dbId": 390457,
        "id": "f340b899-a8df-4dde-b37d-241e2f487ee1",
        "name": "MSSQL - 19",
        "accessProtocol": "MSSQL",
        "managementIp": "10.20.42.96",
        "elementType": {
            "dbId": -444,
            "elementTypeId": "mssql",
            "elementTypeName": "MsSQL",
            "vendor": null,
            "category": null,
            "elementTypeProperties": [],
            "tags": [
                "INFRASTRUCTURE"
            ]
        },
        "discoveryTime": 1695900168322,
        "properties": {
            "db.password": null,
            "portNum": "1433",
            "discoverySource": "REST",
            "pseudoDevice": "true",
            "db.name": "master",
            "db.username": "sa",
            "sql.proxy.bind.port": "2002"
        },
        "deviceGroups": [],
        "availability": null,
        "currentMaintenanceWindow": null,
        "interfaceName": null,
        "nameManagementIp": "MSSQL - 19-10.20.42.96",
        "regionName": null,
        "filterRecordLimit": null,
        "filterSearchPhrase": null,
        "filterGroupId": null,
        "filterRoleGroupIds": null,
        "filterOnlyUnassignedDevices": null,
        "firstResult": null,
        "maxResult": null,
        "filterCheckPermission": false,
        "filterUserId": null,
        "filterOnlyApprovalRequired": false,
        "checkTagsForSearchPhrase": false,
        "connectorNodeIpAddress": null,
        "deviceGroupNames": null,
        "filterIdList": null,
        "filterGroupIdList": null,
        "filterByGroupTree": false,
        "pseudoDevice": true,
        "domainController": null,
        "dbPassword": null,
        "dbUsername": "sa",
        "dbServiceName": "master",
        "dbConnectionNumber": null,
        "discoverySource": "REST",
        "connectorSiteName": null,
        "connectorPortNum": null
    },
    "schema": "*",
    "rowLimit": null,
    "enabled": null,
    "allTable": null,
    "columnType": "VARCHAR",
    "type": null,
    "key": null
}