This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
I'm trying to update the contact details of the table using the azure-purview-catalog python package.
from azure.purview.catalog import PurviewCatalogClient
from azure.identity import DefaultAzureCredential
credential = DefaultAzureCredential()
client = PurviewCatalogClient(endpoint=f"https://{os.environ['PURVIEW_NAME']}.purview.azure.com", credential=credential
I'm trying to use the function: create_or_update(), as per the argument received by the function which is a JSON object, I'm passing the below data
{'entity': {'contacts': {'Expert': [{'id': 'xxxxxxxxxxxx', 'info': 'xxxxxxxxxx'}], 'Owner': [{'id': 'xxxxxxxxxxxxxxxxxx', 'info': 'xxxxxxxxxxxxxxxxx'}]}, 'guid': 'table_guid'}}
Below is the error I'm receiving while trying to update the contact details of the table.
client.entity.create_or_update(contact_data)
Error:
HttpResponseError: Operation returned an invalid status 'Bad Request' Content: {"requestId":"967ceef8-cc1b-11ee-bb2e-00163ee189fd","errorCode":"ATLAS-400-00-014","errorMessage":"Type ENTITY with name null does not exist"}
I'm not sure what is being done wrong here, I've formatted the JSON input as it is supposed to be expected by the function. Please let me know, how to fix this. I can't find any suitable example for this task.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
Did you try any other operations on the same table?
Hi, Yes, I've tried to update the table description for the same table and it is working. However, to update the table description, I've used a different method provided by the PurviewCatalogClient The function that I've used for updating the table description is: parttial_update_entity_attribute_by_guid( )
from azure.purview.catalog import PurviewCatalogClient
from azure.identity import DefaultAzureCredential
credential = DefaultAzureCredential()
client = PurviewCatalogClient(endpoint=f"https://{os.environ['PURVIEW_NAME']}.purview.azure.com", credential=credential)
client.entity.partial_update_entity_attribute_by_guid(guid_of_table, table_description_to_be_updated, name="userDescription")
Response:
{'mutatedEntities': {'PARTIAL_UPDATE': [{'typeName': 'azure_sql_table', 'attributes': {'userDescription': "Hey, I'm a table description", 'createTime': 1667996424000,..........
I've tried to use the same function to update the contact details of the table, but it seems that this function is not appropriate to update the contacts of the table.
client.entity.partial_update_entity_attribute_by_guid(guid_of_table, contact_details, name="contacts") # this doesnt work, it says there is not contact
Response:
Operation returned an invalid status 'Bad Request' Content: {"requestId":"07fb26e0-ccc0-11ee-a0b6-00163ea6c70e","errorCode":"ATLAS-400-00-023","errorMessage":"Attribute contacts not found for type azure_sql_table"}
I've tried to read the table entity data using the purview cli client. And passed the attribute 'contacts' to the function but it seems the 'contacts' is not treated as attribute of the table.
Please guide me, on how to update the contact details of table through PurviewCatalogClient or PurviewCLI Client
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 11%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
@Ravineesh I have a sample script using native python/REST calls to bulk assign ownership. It might help: https://github.com/mrobson1975/purview-api-cookbook/blob/main/entity/entity-bulk-assign-owner.ipynb