Invoking Test Data Management REST APIs Using cURL

Back Next

View Columns to identify the Column ID

Identify the column to which you want to assign the masking rule.

You require the column ID to use REST APIs to assign a rule to a column.

You can run the

/tdm/v1/projects/{projectId}/columns

API to view a list of columns in the project.

Enter the following cURL API request:

curl -X GET "http://<host>:<port>/api/public/tdm/v1/projects/2412/columns" -H "accept: application/json" -H "authorization: Basic TmF0aXZlL0FkbWluaXN0cmF0b3I6QWRtaW5pc3RyYXRvcg=="

Press Enter.

Review the response to identify the connection ID.

The following code is the response that the sample request returns:


[
{"ds_name":"DB01","source":"BONUS","owner":"DB01","name":"COMM","version":0,"id":79398,"data_type":"number",
"sensitive":false,"data_domain":"","restricted":false,"constraint_keys":null,"readonly":false,"policy":null,"rule":null,
"rule_id":0,"details":null,"override":null,"assignment_id":null},
{"ds_name":"DB01","source":"BONUS","owner":"DB01","name":"ENAME","version":0,"id":79395,"data_type":"varchar2",
"sensitive":false,"data_domain":"","restricted":false,"constraint_keys":null,"readonly":false,"policy":null,"rule":null,
"rule_id":0,"details":null,"override":null,"assignment_id":null},
{"ds_name":"DB01","source":"BONUS","owner":"DB01","name":"JOB","version":0,"id":79396,"data_type":"varchar2",
"sensitive":false,"data_domain":"","restricted":false,"constraint_keys":null,"readonly":false,"policy":null,"rule":null,
"rule_id":0,"details":null,"override":null,"assignment_id":null},
{"ds_name":"DB01","source":"BONUS","owner":"DB01","name":"SAL","version":0,"id":79397,"data_type":"number",
"sensitive":false,"data_domain":"","restricted":false,"constraint_keys":null,"readonly":false,"policy":null,"rule":null,
"rule_id":0,"details":null,"override":null,"assignment_id":null}
]

You view a list of all the columns in the Project_RestAPI01 project. From the list you identify the column that you want to mask in your plan and the column ID:

ENAME

with column ID 79395.

Create and Run the Required REST API Requests

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal