---
title: Edit Masking Policy
slug: kron-pam-api-collection-3-7-0/edit-masking-policy
docTags:
createdAt: 2025-05-08T12:58:23.519Z
---
{
"id": "dzLyDyhq7TEucbPGxAVEW",
"type": "api-oas-v2",
"data": {
"method": "POST",
"url": "{{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy",
"name": "",
"description": "Request Overview
\nThis request is used to edit previously saved masking policies in the system. The request body must include the dbId of the policy, along with other properties such as name, description, deviceDbId, schema, table, column, and methodDbId, which can be edited. The body is formatted as a JSON object with key-value pairs.
",
"contentType": "application/json",
"request": {
"headerParameters": [
{
"name": "Content-Type",
"description": "",
"default": "application/json",
"value": "application/json",
"type": "string"
},
{
"name": "X-XSRF-TOKEN",
"description": "",
"default": "{{csrftoken}}",
"value": "{{csrftoken}}",
"type": "string"
}
],
"queryParameters": [],
"pathParameters": [
{
"name": "url",
"description": "",
"default": "url",
"value": "url",
"type": "string"
}
],
"bodyDataParameters": [
{
"name": "body",
"description": "",
"default": "{\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",
"value": "{\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",
"type": "object"
}
],
"formDataParameters": [],
"oAuthParameters": []
},
"responses": [
{
"statusCode": "200",
"description": "Edit Masking Policy",
"jsonExample": "{\n \"dbId\": 390577,\n \"userCreate\": null,\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"Masking new\",\n \"description\": \"Masking\",\n \"date\": 1695905980448,\n \"tableName\": \"*\",\n \"maskBase\": null,\n \"columnName\": \"*\",\n \"maskingMethod\": {\n \"dbId\": -261965,\n \"userCreate\": null,\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"Mssql_Email\",\n \"description\": null,\n \"methodPattern\": \"STUFF(${column},1,7,'MASKED*')\",\n \"date\": null,\n \"columnType\": \"VARCHAR\",\n \"hideColumn\": false,\n \"databaseType\": null,\n \"firstResult\": null,\n \"maxResult\": null\n },\n \"device\": {\n \"dbId\": 390457,\n \"id\": \"f340b899-a8df-4dde-b37d-241e2f487ee1\",\n \"name\": \"MSSQL - 19\",\n \"accessProtocol\": \"MSSQL\",\n \"managementIp\": \"10.20.42.96\",\n \"elementType\": {\n \"dbId\": -444,\n \"elementTypeId\": \"mssql\",\n \"elementTypeName\": \"MsSQL\",\n \"vendor\": null,\n \"category\": null,\n \"elementTypeProperties\": [],\n \"tags\": [\n \"INFRASTRUCTURE\"\n ]\n },\n \"discoveryTime\": 1695900168322,\n \"properties\": {\n \"db.password\": null,\n \"portNum\": \"1433\",\n \"discoverySource\": \"REST\",\n \"pseudoDevice\": \"true\",\n \"db.name\": \"master\",\n \"db.username\": \"sa\",\n \"sql.proxy.bind.port\": \"2002\"\n },\n \"deviceGroups\": [],\n \"availability\": null,\n \"currentMaintenanceWindow\": null,\n \"interfaceName\": null,\n \"nameManagementIp\": \"MSSQL - 19-10.20.42.96\",\n \"regionName\": null,\n \"filterRecordLimit\": null,\n \"filterSearchPhrase\": null,\n \"filterGroupId\": null,\n \"filterRoleGroupIds\": null,\n \"filterOnlyUnassignedDevices\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"filterCheckPermission\": false,\n \"filterUserId\": null,\n \"filterOnlyApprovalRequired\": false,\n \"checkTagsForSearchPhrase\": false,\n \"connectorNodeIpAddress\": null,\n \"deviceGroupNames\": null,\n \"filterIdList\": null,\n \"filterGroupIdList\": null,\n \"filterByGroupTree\": false,\n \"pseudoDevice\": true,\n \"domainController\": null,\n \"dbPassword\": null,\n \"dbUsername\": \"sa\",\n \"dbServiceName\": \"master\",\n \"dbConnectionNumber\": null,\n \"discoverySource\": \"REST\",\n \"connectorSiteName\": null,\n \"connectorPortNum\": null\n },\n \"schema\": \"*\",\n \"rowLimit\": null,\n \"enabled\": null,\n \"allTable\": null,\n \"columnType\": \"VARCHAR\",\n \"type\": null,\n \"key\": null\n}"
}
],
"examples": {
"languages": [
{
"id": "NTl9noYKSyNKBWPhVMEzm",
"language": "curl",
"label": "cURL",
"code": "curl --request POST \\\n --url {{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy \\\n --header 'accept: application/json' \\\n --header 'content-type: application/json' \\\n --header 'x-xsrf-token: {{csrftoken}}' \\\n --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\"'"
},
{
"id": "WlohNLuSX5K7fIQW07WQ7",
"language": "javascript",
"label": "javascript",
"code": "var myHeaders = new Headers();\nmyHeaders.append(\"accept\", \"application/json\");\nmyHeaders.append(\"content-type\", \"application/json\");\nmyHeaders.append(\"x-xsrf-token\", \"{{csrftoken}}\");\n\nvar 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\");\n\nvar requestOptions = {\n method: 'POST',\n headers: myHeaders,\n body: raw,\n redirect: 'follow'\n};\n\nfetch(\"{{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy\", requestOptions)\n .then(response => response.text())\n .then(result => console.log(result))\n .catch(error => console.log('error', error));"
},
{
"id": "BXBiU1Bhf8JEhBpYL77l0",
"language": "ruby",
"label": "Ruby",
"code": "require \"uri\"\nrequire \"json\"\nrequire \"net/http\"\n\nurl = URI(\"{{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy\")\n\nhttp = Net::HTTP.new(url.host, url.port);\nrequest = Net::HTTP::Post.new(url)\nrequest[\"accept\"] = \"application/json\"\nrequest[\"content-type\"] = \"application/json\"\nrequest[\"x-xsrf-token\"] = \"{{csrftoken}}\"\nrequest.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\")\n\nresponse = http.request(request)\nputs response.read_body\n"
},
{
"id": "HfLCnpQwPibxSjvkQV551",
"language": "python",
"label": "Python",
"code": "import requests\nimport json\n\nurl = \"{{url}}/aioc-rest-web/rest/sc/sqlproxy/updateMaskingPolicy\"\n\npayload = 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\")\nheaders = {\n 'accept': 'application/json',\n 'content-type': 'application/json',\n 'x-xsrf-token': '{{csrftoken}}'\n}\n\nresponse = requests.request(\"POST\", url, headers=headers, data=payload)\n\nprint(response.text)\n"
}
],
"selectedLanguageId": "NTl9noYKSyNKBWPhVMEzm"
},
"results": {
"languages": [
{
"id": "z2IolcMfcqgZ6ZpGFweSr",
"language": "200",
"code": "{\n \"dbId\": 390577,\n \"userCreate\": null,\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"Masking new\",\n \"description\": \"Masking\",\n \"date\": 1695905980448,\n \"tableName\": \"*\",\n \"maskBase\": null,\n \"columnName\": \"*\",\n \"maskingMethod\": {\n \"dbId\": -261965,\n \"userCreate\": null,\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"Mssql_Email\",\n \"description\": null,\n \"methodPattern\": \"STUFF(${column},1,7,'MASKED*')\",\n \"date\": null,\n \"columnType\": \"VARCHAR\",\n \"hideColumn\": false,\n \"databaseType\": null,\n \"firstResult\": null,\n \"maxResult\": null\n },\n \"device\": {\n \"dbId\": 390457,\n \"id\": \"f340b899-a8df-4dde-b37d-241e2f487ee1\",\n \"name\": \"MSSQL - 19\",\n \"accessProtocol\": \"MSSQL\",\n \"managementIp\": \"10.20.42.96\",\n \"elementType\": {\n \"dbId\": -444,\n \"elementTypeId\": \"mssql\",\n \"elementTypeName\": \"MsSQL\",\n \"vendor\": null,\n \"category\": null,\n \"elementTypeProperties\": [],\n \"tags\": [\n \"INFRASTRUCTURE\"\n ]\n },\n \"discoveryTime\": 1695900168322,\n \"properties\": {\n \"db.password\": null,\n \"portNum\": \"1433\",\n \"discoverySource\": \"REST\",\n \"pseudoDevice\": \"true\",\n \"db.name\": \"master\",\n \"db.username\": \"sa\",\n \"sql.proxy.bind.port\": \"2002\"\n },\n \"deviceGroups\": [],\n \"availability\": null,\n \"currentMaintenanceWindow\": null,\n \"interfaceName\": null,\n \"nameManagementIp\": \"MSSQL - 19-10.20.42.96\",\n \"regionName\": null,\n \"filterRecordLimit\": null,\n \"filterSearchPhrase\": null,\n \"filterGroupId\": null,\n \"filterRoleGroupIds\": null,\n \"filterOnlyUnassignedDevices\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"filterCheckPermission\": false,\n \"filterUserId\": null,\n \"filterOnlyApprovalRequired\": false,\n \"checkTagsForSearchPhrase\": false,\n \"connectorNodeIpAddress\": null,\n \"deviceGroupNames\": null,\n \"filterIdList\": null,\n \"filterGroupIdList\": null,\n \"filterByGroupTree\": false,\n \"pseudoDevice\": true,\n \"domainController\": null,\n \"dbPassword\": null,\n \"dbUsername\": \"sa\",\n \"dbServiceName\": \"master\",\n \"dbConnectionNumber\": null,\n \"discoverySource\": \"REST\",\n \"connectorSiteName\": null,\n \"connectorPortNum\": null\n },\n \"schema\": \"*\",\n \"rowLimit\": null,\n \"enabled\": null,\n \"allTable\": null,\n \"columnType\": \"VARCHAR\",\n \"type\": null,\n \"key\": null\n}"
}
],
"selectedLanguageId": "z2IolcMfcqgZ6ZpGFweSr"
}
},
"children": [
{
"text": ""
}
]
}