masking API | dissociate a masking algorithm from a column

  • 2
  • 1
  • Question
  • Updated 5 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,

Omar.


Photo of Omar

Omar

  • 100 Points 100 badge 2x thumb

Posted 5 months ago

  • 2
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 800 Points 500 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.

Thanks,
Michael
Photo of Omar

Omar

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

..is enough.

 
best regards,
Omar.