masking API | dissociate a masking algorithm from a column

  • 2
  • 1
  • Question
  • Updated 11 months ago
  • Answered

hi guys,

I would like to know if there's a way to "cancel" or dissociate a masking algorithm from a table column.

as you know, through the masking API it is possible to create a columnMetadata, hence, associate an algorithm to a column in order to mask it. However, sometimes we need to cancel this operation (an update from the project spec..).. unfortunately the API doesn't provide any DELETE method for columnMetadata..

using the maskin API (columnMetadata) I tried an update (PUT) with several values  :

- { "algorithmName" : null , "domainName" : null }

- { "algorithmName" : "" , "domainName" : "" }

- { "algorithmName" : "-", "domainName" : "-" } (since "-" is the default value in import files.. )

but nothing works..

of course it's always possible to cancel this masking throught the interface, but it's not a reliable solution considering the high number of updates we are facing.

if anyone can help us we would appreciate it.

thanks a lot,

best regards,


Photo of Omar


  • 100 Points 100 badge 2x thumb

Posted 11 months ago

  • 2
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 2,110 Points 2k badge 2x thumb
Hi Omar,
Had a quick chat with the Masking team here and the suggestion is to not include the algorithmName or domainName in the request:
  "columnMetadataId": 5,
  "columnName": "col_name",
  "tableMetadataId": 1,
  "dataType": "VARCHAR2",
  "columnLength": 50,
  "isMasked": false,
  "isProfilerWritable": true,
  "isPrimaryKey": false,
  "isIndex": false,
  "isForeignKey": false,
  "notes": ""
Hope that helps.

Photo of Omar


  • 100 Points 100 badge 2x thumb
Thanks Michael. this worked perfectly. Actually :
"isMasked": false enough.

best regards,