API to get schema and corresponding curation status and partially currated for assets in Azure Purview

Question

Business need :

To generate power bi report on schema name , description , partially curated, curation status.

Process :

For that I tried to fetch the details with the help of REST api using entity, catalog, glossary and tried generating JSON which later on will upload to power bi for report generation.

Issue: With the help of REST Api I tried to fetch detail of assests but the JSON which is creating doesn't contain Schema, Curation status and Partially curated.

I need something like this in my JSON after fetching:

 "curation_status": {
                "partially_curated": false,
                "has_classifications": false,
                "has_meanings": false,
                "is_certified": false,
                "status": "Not Curated"
            }

Below is the overall Json that will help me if i get JSON structure like this after using Entity API or Catalog but it is not getting like this JSON missing schema and curation status part .

 "referredEntities": {},
            "entity": {
                "typeName": "",
                "attributes": {
                    "owner": null,
                    "resourceGroupName": null,
                    "replicatedTo": null,
                    "userDescription": null,
                    "replicatedFrom": null,
                    "qualifiedName": "",
                    "displayName": null,
                    "description": null,
                    "createTime": 0,
                    "compatibilityLevel": 0,
                    "name": "DW",
                    "location": null,
                    "ownerSid": null,
                    "collation": null,
                    "subscriptionId": null
                },
                "lastModifiedTS": "1",
                "guid": "",
                "isIncomplete": false,
                "provenanceType": 0,
                "status": "ACTIVE",
                "createdBy": "",
                "updatedBy": "",
                "createTime": ,
                "updateTime": ,
                "version": 0,
                "isIndexed": true,
                "source": "DataScan",
                "relationshipAttributes": {
                    "server": {
                        "guid": "",
                        "typeName": "",
                        "entityStatus": "ACTIVE",
                        "displayText": "",
                        "relationshipType": "",
                        "relationshipGuid": "",
                        "relationshipStatus": "ACTIVE",
                        "relationshipAttributes": {
                            "typeName": ""
                        }
                    },
                    "schemas": [],
                    "meanings": []
                },
                "labels": [],
                "displayText": "DW",
                "proxy": false
            },
            "curation_status": {
                "partially_curated": false,
                "has_classifications": false,
                "has_meanings": false,
                "is_certified": false,
                "status": "Not Curated"
            }
        }

Accepted Answer

@Utsav Mori - Thanks for the question and using MS Q&A platform.

Based on the provided document, it seems that the REST API for Azure Purview does not provide the schema and curation status information in the JSON response. Therefore, it is not possible to generate the desired JSON structure using the Entity API or Catalog API.

However, there might be other ways to obtain the required information. One possible solution could be to use the Purview SDK for Python or .NET to fetch the schema and curation status information and then generate the desired JSON structure. You can find more information about the Purview SDK in the following links:

Alternatively, you can try to use the Purview REST API to fetch the required information separately and then merge it with the JSON response obtained from the Entity API or Catalog API. For example, you can use the following REST API to fetch the curation status information for a specific asset:

GET https://.catalog.purview.azure.com/api/atlas/v2/entity/guid//classification

You can find more information about the Purview REST API in the following link:

Purview REST API: https://docs.microsoft.com/en-us/rest/api/purview/

Hope this helps. Do let us know if you any further queries.

Share via

API to get schema and corresponding curation status and partially currated for assets in Azure Purview

0 additional answers