This request is used to list masking policies in the system. To retrieve all records, no properties should be included in the request body. To filter specific properties, the relevant property and value can be provided in the body, 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 \"name\": \"new policy\",\r\n \"description\": \"new masking policy\",\r\n \"datasourceDbId\": 582647,\r\n \"active\": true,\r\n \"rowLimit\": 50,\r\n \"schema\": \"*\",\r\n \"table\": \"EMPLOYEES\",\r\n \"column\": \"FIRST_NAME\",\r\n \"methodDbId\": 465445\r\n}\r\n", "value": "{\r\n \"name\": \"new policy\",\r\n \"description\": \"new masking policy\",\r\n \"datasourceDbId\": 582647,\r\n \"active\": true,\r\n \"rowLimit\": 50,\r\n \"schema\": \"*\",\r\n \"table\": \"EMPLOYEES\",\r\n \"column\": \"FIRST_NAME\",\r\n \"methodDbId\": 465445\r\n}\r\n", "type": "object" } ], "formDataParameters": [], "oAuthParameters": [] }, "responses": [ { "statusCode": "200", "description": "", "jsonExample": "" } ], "examples": { "languages": [ { "id": "rUNIGv2usKvkkzthYuNMi", "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\\\": \\\"new policy\\\",\\r\\n \\\"description\\\": \\\"new masking policy\\\",\\r\\n \\\"datasourceDbId\\\": 582647,\\r\\n \\\"active\\\": true,\\r\\n \\\"rowLimit\\\": 50,\\r\\n \\\"schema\\\": \\\"*\\\",\\r\\n \\\"table\\\": \\\"EMPLOYEES\\\",\\r\\n \\\"column\\\": \\\"FIRST_NAME\\\",\\r\\n \\\"methodDbId\\\": 465445\\r\\n}\\r\\n\"'" }, { "id": "SL5J4PGtFFG3iaE2uodXX", "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\\\": \\\"new policy\\\",\\r\\n \\\"description\\\": \\\"new masking policy\\\",\\r\\n \\\"datasourceDbId\\\": 582647,\\r\\n \\\"active\\\": true,\\r\\n \\\"rowLimit\\\": 50,\\r\\n \\\"schema\\\": \\\"*\\\",\\r\\n \\\"table\\\": \\\"EMPLOYEES\\\",\\r\\n \\\"column\\\": \\\"FIRST_NAME\\\",\\r\\n \\\"methodDbId\\\": 465445\\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/listMaskingPolicy\", requestOptions)\n .then(response => response.text())\n .then(result => console.log(result))\n .catch(error => console.log('error', error));" }, { "id": "0Z3wshyNd4ppL4uTPHRGA", "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\\\": \\\"new policy\\\",\\r\\n \\\"description\\\": \\\"new masking policy\\\",\\r\\n \\\"datasourceDbId\\\": 582647,\\r\\n \\\"active\\\": true,\\r\\n \\\"rowLimit\\\": 50,\\r\\n \\\"schema\\\": \\\"*\\\",\\r\\n \\\"table\\\": \\\"EMPLOYEES\\\",\\r\\n \\\"column\\\": \\\"FIRST_NAME\\\",\\r\\n \\\"methodDbId\\\": 465445\\r\\n}\\r\\n\")\n\nresponse = http.request(request)\nputs response.read_body\n" }, { "id": "IXksj5oI67KGHQRl7RtmY", "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\\\": \\\"new policy\\\",\\r\\n \\\"description\\\": \\\"new masking policy\\\",\\r\\n \\\"datasourceDbId\\\": 582647,\\r\\n \\\"active\\\": true,\\r\\n \\\"rowLimit\\\": 50,\\r\\n \\\"schema\\\": \\\"*\\\",\\r\\n \\\"table\\\": \\\"EMPLOYEES\\\",\\r\\n \\\"column\\\": \\\"FIRST_NAME\\\",\\r\\n \\\"methodDbId\\\": 465445\\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": "rUNIGv2usKvkkzthYuNMi" }, "results": { "languages": [ { "id": "UpiwmJNBn6x_hSDE-X8gh", "language": "200", "code": "" } ], "selectedLanguageId": "UpiwmJNBn6x_hSDE-X8gh" } }, "children": [ { "text": "" } ] }