Delphix Products

 View Only
  • 1.  Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-22-2022 05:15:00 AM
    Hi,

    We are trying to leverage Delphix Masking APIs to perform profiling. We are able to perform profiling using the APIs, but are not able to export the results of profiling using an API. Is there any API that can help us with it ? There is a file-downloads API, but it needs fileDownloadId. Not sure how to get that one for exporting Delphix Inventory

    ------------------------------
    Ruchit Doshi
    ------------------------------


  • 2.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-23-2022 02:42:00 PM
    Edited by Claire McManus 06-23-2022 02:58:32 PM
    Hi Ruchit,

    We do not currently have a specific API that allows for the export of the profiling results.

    ------------------------------
    Claire McManus
    Senior Member of Technical Staff I
    Delphix
    ------------------------------



  • 3.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API
    Best Answer

    Posted 06-23-2022 03:06:00 PM
    Edited by Michael Torok 06-23-2022 03:25:55 PM
    Hi Ruchit,

         Claire and I connected and tested with our API Client.  Please follow the below steps.

    1.) Get the execution ID from the profile job ID. http://<masking_engine>/masking/api/v5.1.13/executions?job_id=<job_id>&page_number=1
    2.) From the response body, pass the execution ID to execution logs http://<masking_engine>/masking/api/v5.1.13/execution-logs/<execution_id>
    3.) From the response body, get the fileDownloadID http://<masking_engine>/masking/api/v5.1.13/execution-logs/<execution_id>
    4.) From the response body, pass the fileDownloadID http://<masking_engine>/masking/api/v5.1.13/file-downloads/<fileDownloadID>
    5.) The response body will have the option to download the Profiling Job results.

    ------------------------------
    Robert Henning
    Senior Solutions Engineer
    Delphix
    ------------------------------



  • 4.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-24-2022 02:28:00 AM

    Hi Robert,

    Thank you very much for your response.

    We tried the steps you suggested, but could only download the execution logs for the profile job. We could not find any option to download Profile results. Please find attached screenshot for reference. 

    Please let us know your thoughts on the same 

    Thank you



    ------------------------------
    Ruchit Doshi
    ------------------------------



  • 5.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-24-2022 08:45:00 AM
    Hi Ruchit,

    There is no API endpoint to retrieve only the profiler results. Currently, the only way to get this is through the PDF generated in the UI on the monitoring page for the job.

    ------------------------------
    Claire McManus
    Senior Member of Technical Staff I
    Delphix
    ------------------------------



  • 6.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-26-2022 02:03:00 PM
    Hi Ruchit,

    We were looking for the same functionality and ended up writing a script that creates a CSV file with pretty much the same information and in our preferred format using API calls.  We called get table-metadata and get column-metadata for each of masked and unmasked columns. Then wrote to CSV.  Fairly straight forward with Powershell.

    The one thing we couldn't get was the indicator of whether a field was an identity field or not.  This is not available through the API.

    ------------------------------
    Murray Penno
    IT Business Consultant
    ANZ Bank New Zealand Limited
    ------------------------------



  • 7.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-27-2022 03:42:00 AM

    Hi @Murray Penno,

    Thank you for your response. We are also using the same logic and facing the same challenge of not being able to fetch identity column.

    Thanks,



    ------------------------------
    Ruchit Doshi
    ------------------------------



  • 8.  RE: Delphix Continuous Compliance (Masking Engine) Export Inventory using API

    Posted 06-27-2022 07:59:00 PM
    @Ruchit Doshi We had bug DLPX-80304 raised for this issue.  You might be able to support for faster resolution :)




    ------------------------------
    Murray Penno
    IT Business Consultant
    ANZ Bank New Zealand Limited
    ------------------------------