---
title: List Masking Policy by Name
slug: kron-pam-api-collection-3-9-0/list-masking-policy-by-name
docTags:
createdAt: 2026-10-21T06:10:28.166Z
---
{
"id": "OeIrb6Hwpurl0lVJKEEpF",
"type": "api-oas-v2",
"data": {
"method": "POST",
"url": "{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingPolicy",
"name": "",
"description": "Request Overview
\nThis request is used to list masking policies by name. The request body includes the name parameter, which specifies the name of the masking policy to be retrieved. The body is formatted as a JSON object with key-value pairs.
",
"contentType": "application/json",
"request": {
"headerParameters": [
{
"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 \"name\": \"\"\r\n}",
"value": "{\r\n \"name\": \"\"\r\n}",
"type": "object"
}
],
"formDataParameters": [],
"oAuthParameters": []
},
"responses": [
{
"statusCode": "200",
"description": "List Masking Policy by Name",
"jsonExample": "[\n {\n \"dbId\": 397619,\n \"userCreate\": {\n \"id\": \"abbccd16-b31f-4449-8cc4-131d08cdebca\",\n \"eid\": \"Device\",\n \"personelId\": null,\n \"name\": \"Device\",\n \"passwordAlgorithm\": null,\n \"password\": null,\n \"secondPassword\": null,\n \"email\": \"iremgul.durmus@krontech.com\",\n \"surname\": \"durmus\",\n \"internal\": true,\n \"properties\": {\n \"ubaThreshold\": \"50\"\n },\n \"groups\": [\n \"DEFAULT_GROUP_SYSYEM_USERS\",\n \"0482ee83-aec0-4c89-bd42-6d31f4ae8ad5\",\n \"DEFAULT_GROUP_SYSYEM_ADMINS\"\n ],\n \"managerGroups\": [\n \"0482ee83-aec0-4c89-bd42-6d31f4ae8ad5\"\n ],\n \"lastLogin\": 1695929572407,\n \"lastLoginIp\": \"10.0.8.82\",\n \"groupPropertyKey4Search\": null,\n \"groupPropertyValue4Search\": null,\n \"recordLimit4Search\": null,\n \"checkPermission4Search\": false,\n \"passwordDirty\": false,\n \"secondPasswordChange\": false,\n \"passwordAutoGenerated\": false,\n \"filterFunctionName\": null,\n \"filterMembershipUserId\": null,\n \"filterManagerId\": null,\n \"filterEidList\": null,\n \"filterIdList\": null,\n \"filterManagerOfUserId\": null,\n \"passwordSalt\": null,\n \"creationTime\": 1695642004340,\n \"delegations\": [],\n \"firstResult\": null,\n \"maxResult\": null,\n \"locked\": false,\n \"unlockOnPasswordChanged\": false,\n \"unlockTime\": null,\n \"tempUserStartTime\": null,\n \"tempUser\": false,\n \"externalDirectorySource\": null,\n \"userPropertyKey4Search\": null,\n \"userPropertyValue4Search\": null,\n \"phoneNumber\": null,\n \"adLineManager\": null,\n \"forceChangePasswordOnNextLogin\": false,\n \"lockReason\": null,\n \"tempUserEndTime\": null\n },\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"new podsflicy\",\n \"description\": \"new maskinfasg policy\",\n \"date\": 1695930389413,\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\": true,\n \"allTable\": null,\n \"columnType\": \"VARCHAR\",\n \"type\": null,\n \"key\": null\n }\n]"
}
],
"examples": {
"languages": [
{
"id": "9S-OETkBfeB_LQ-AkFuww",
"language": "curl",
"label": "cURL",
"code": "curl --request POST \\\n --url {{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingPolicy \\\n --header 'accept: application/json' \\\n --header 'content-type: application/json' \\\n --header 'x-xsrf-token: {{csrftoken}}' \\\n --data '\"{\\r\\n \\\"name\\\": \\\"\\\"\\r\\n}\"'"
},
{
"id": "jM8Zo3MQd2JA1WoTxC-ao",
"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 \\\"name\\\": \\\"\\\"\\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/listMaskingPolicy\", requestOptions)\n .then(response => response.text())\n .then(result => console.log(result))\n .catch(error => console.log('error', error));"
},
{
"id": "9bnOsgET-Do9wOL51DO66",
"language": "ruby",
"label": "Ruby",
"code": "require \"uri\"\nrequire \"json\"\nrequire \"net/http\"\n\nurl = URI(\"{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingPolicy\")\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 \\\"name\\\": \\\"\\\"\\r\\n}\")\n\nresponse = http.request(request)\nputs response.read_body\n"
},
{
"id": "MGHqcfuoJjRydbs6c-MEN",
"language": "python",
"label": "Python",
"code": "import requests\nimport json\n\nurl = \"{{url}}/aioc-rest-web/rest/sc/sqlproxy/listMaskingPolicy\"\n\npayload = json.dumps(\"{\\r\\n \\\"name\\\": \\\"\\\"\\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": "9S-OETkBfeB_LQ-AkFuww"
},
"results": {
"languages": [
{
"id": "8KvzIxJvilSx_8OuqOKvO",
"language": "200",
"code": "[\n {\n \"dbId\": 397619,\n \"userCreate\": {\n \"id\": \"abbccd16-b31f-4449-8cc4-131d08cdebca\",\n \"eid\": \"Device\",\n \"personelId\": null,\n \"name\": \"Device\",\n \"passwordAlgorithm\": null,\n \"password\": null,\n \"secondPassword\": null,\n \"email\": \"iremgul.durmus@krontech.com\",\n \"surname\": \"durmus\",\n \"internal\": true,\n \"properties\": {\n \"ubaThreshold\": \"50\"\n },\n \"groups\": [\n \"DEFAULT_GROUP_SYSYEM_USERS\",\n \"0482ee83-aec0-4c89-bd42-6d31f4ae8ad5\",\n \"DEFAULT_GROUP_SYSYEM_ADMINS\"\n ],\n \"managerGroups\": [\n \"0482ee83-aec0-4c89-bd42-6d31f4ae8ad5\"\n ],\n \"lastLogin\": 1695929572407,\n \"lastLoginIp\": \"10.0.8.82\",\n \"groupPropertyKey4Search\": null,\n \"groupPropertyValue4Search\": null,\n \"recordLimit4Search\": null,\n \"checkPermission4Search\": false,\n \"passwordDirty\": false,\n \"secondPasswordChange\": false,\n \"passwordAutoGenerated\": false,\n \"filterFunctionName\": null,\n \"filterMembershipUserId\": null,\n \"filterManagerId\": null,\n \"filterEidList\": null,\n \"filterIdList\": null,\n \"filterManagerOfUserId\": null,\n \"passwordSalt\": null,\n \"creationTime\": 1695642004340,\n \"delegations\": [],\n \"firstResult\": null,\n \"maxResult\": null,\n \"locked\": false,\n \"unlockOnPasswordChanged\": false,\n \"unlockTime\": null,\n \"tempUserStartTime\": null,\n \"tempUser\": false,\n \"externalDirectorySource\": null,\n \"userPropertyKey4Search\": null,\n \"userPropertyValue4Search\": null,\n \"phoneNumber\": null,\n \"adLineManager\": null,\n \"forceChangePasswordOnNextLogin\": false,\n \"lockReason\": null,\n \"tempUserEndTime\": null\n },\n \"userUpdate\": null,\n \"creationDate\": null,\n \"lastUpdate\": null,\n \"name\": \"new podsflicy\",\n \"description\": \"new maskinfasg policy\",\n \"date\": 1695930389413,\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\": true,\n \"allTable\": null,\n \"columnType\": \"VARCHAR\",\n \"type\": null,\n \"key\": null\n }\n]"
}
],
"selectedLanguageId": "8KvzIxJvilSx_8OuqOKvO"
}
},
"children": [
{
"text": ""
}
]
}