APIPythonOpen-Source Solutions

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.

#Masking

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

Thanks Michael. this worked perfectly. Actually :

"isMasked": false

..is enough.

 
best regards,
Omar.