APIMaskingSidekickPythonOpen-Source Solutions

 View Only
  • 1.  masking API | dissociate a masking algorithm from a column

    Posted 06-25-2018 01:36:00 PM

    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


  • 2.  RE: masking API | dissociate a masking algorithm from a column

    Posted 06-25-2018 02:38:00 PM
    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


  • 3.  RE: masking API | dissociate a masking algorithm from a column
    Best Answer

    Posted 06-26-2018 08:45:00 AM
    Thanks Michael. this worked perfectly. Actually :
    "isMasked": false

    ..is enough.

     
    best regards,
    Omar.