Delete Metadata for All Tables(View)

If user wants to delete metadata for all of tables of a database in a go, this service can fulfill the purpose. What this service will be doing is reading all of the entities of the connected database, sort them in order in such a way that child’s metadata should be delete before parent, and use the existing service ( /metadata/write/deleteMetadata) to delete metadata for all of the entities.

The explanation of request packet is as below:

tableType (mandatory): This param is used to determine against what type of table, metadata is to be deleted. This param should contain only below values and is mandatory.

  • table (for deleting metadata of tables only)

  • view (for deleting metadata of views only)

  • table_view (for deleting metadata for both tables and views)

1. Request URL

/{PDM Server domain}link:/metadata/write/DeleteMetaForAll

Method： POST

2. Request headers

Name Value

Content-Type

application/json

3. Request body

{
    "BUSINESS OBJECT": {
        "language": "en",
        "readBack": true,
        "timezone": "GMT+08:00",
        "data": [
            {
                "tableType": "table_view"
            }
        ]
    }
}
Try it myself /

4. Responses

{
    "status": {
        "statusCode": 1,
        "statusLabel": "Success"
    },
    "messages": [
        {
            "message": "1 business objects(s) metadata deleted successfully.",
            "status": {
                "statusCode": 1,
                "statusLabel": "Success"
            }
        }
    ],
    "exception": {},
    "data": {},
    "version": "0.0.0.0A",
    "threadName": "**system_52184",
    "requestTime": "2021-06-01 13:03:56.325 +08:00",
    "responseTime": "2021-06-01 13:03:57.053 +08:00"
}