4.6.3 Populate Metadata for Data Survival in the Compliance Studio Schema

The FCC_M_ER_ATTRIBUTE_PREC table in Compliance Studio Schema stores information about the attribute column name, code of the attribute value, and the precedence value.

Table 4-4 Metadata

v_metadata_type	v_column_cd	n_precedence
Occupation	teacher	2
Geo-location	US	3

REST API to Load Metadata into Compliance Studio Schema

This is used to upload metadata and precedence and update the precedence for existing metadata types in the FCC_M_ER_ATTRIBUTE_PREC table.

URL: http://<hostname>:7051/datasurvival/loadDataSurvMetadata

Request Method: POST

Request Headers: Content-Type: application/json

Request body:

[{
"vmetadataType": "Geo Risk",
"vcolumnCd": "UK",
"nprecedence": "6"
},
{
"vmetadataType": "Geo Risk",
"vcolumnCd": "US",
"nprecedence": "5"
},
{
"vmetadataType": "Geo Risk",
"vcolumnCd": "FIN",
"nprecedence": "3"
}
]

REST API to Update Metadata Type

This is used to delete the existing set of metadata and update the metadata type and precedence with a new set of metadata.

URL: http://<hostname>:7051/datasurvival/updateMetadataType

Request Method: POST

Request Headers: Content-Type: application/json

Request body:

[{
"vmetadataType": "Geo Risk",
"vcolumnCd": "UK",
"nprecedence": "6"
},
{
"vmetadataType": "Geo Risk",
"vcolumnCd": "US",
"nprecedence": "5"
}
]

REST API to Get Metadata Type and Precedence

This is used to get the records available in the precedence table.

URL: http://<hostname>:7051/datasurvival/getAttributePrecMetadata

Request Method: GET

Request Headers: Content-Type: application/json

REST API to Delete any Metadata Type

This is used to delete all records for a specific metadata type in the precedence table.

URL: http://<hostname>:7051/datasurvival/ deleteMetadataType?vMetadataType=<Metadata Type>

For example,http://testserver.oracle.com:7051/datasurvival/ deleteMetadataType?vMetadataType=Occupation

Request Method: POST

Request Headers: Content-Type: application/json