Purview Updating Entity, Assets column, description etc

Question

Purview Updating Entity, Assets column, description etc

Jadhav, Karan 10

Hello,

I am trying to update an entity in Azure Purview from Spark Notebook or through Postman. We have a default purview setup in Azure. However, through both ways I am able to fetch the data but I am unable to post anything.

Following are the POST API calls that I have tried :

⁠https://{{purview_acc_name}}.catalog.purview.azure.com/api/atlas/v2/entity/

⁠https://{{purview_acc_name}}.catalog.purview.azure.com/api/atlas/v2/entity/bulk/

The error I receive always is : {"error":{"code":"Unauthenticated","message":"Token expired"}}
I also tried creating a new token and it hits the API correctly but just not able to authenticate the token.

There is already several discussions on it without any concrete solution :

One solution was to check Content-Type, I tried out by selecting JSON as well(https://techcommunity.microsoft.com/t5/microsoft-purview/create-entity-api/m-p/3549161))
2. https://techcommunity.microsoft.com/t5/microsoft-purview/adding-custom-properties-to-an-entity-in-pu...
3. https://techcommunity.microsoft.com/t5/microsoft-purview/api-to-azure-purview/m-p/3602951#M313

Documentation reference :
https://learn.microsoft.com/en-us/rest/api/purview/catalogdataplane/entity/create-or-update?tabs=HTT...
https://learn.microsoft.com/en-us/rest/api/purview/catalogdataplane/entity/create-or-update-entities...

Can you please let me know, if there is a solution to this issue.

Thanks & Regards,
Karan token_issue

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-31T05:38:51.4566667+00:00

@Jadhav, Karan - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-05-31T05:38:51.4566667+00:00

@Jadhav, Karan - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

PRADEEPCHEEKATLA 90,641 Moderator

@Jadhav, Karan - Thanks for the question and using MS Q&A platform.

There could be two reason, for the above issue - you are using the expired access_token or the client_secret has been expired. Make sure to validate both and see if that works.

As per the repro from my end, I was experiencing the same issue because I was using the access_token which is generated on the last use (almost a month ago).

User's image

When I replaced with the new access_tokenwith a newer access_token it working as excepted.

MSPurviewRestUpload

There could be another issue which would leads to this error message, that can be client_secret expired. Make sure that you have a valid client_secret incase, if it expired try to create a new client_secret and re-generate the token.

User's image

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

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Jadhav, Karan 10 Reputation points

2023-05-31T12:37:44.7366667+00:00
Hi PRADEEPCHEEKATLA-MSFT,

I managed to resolve the issue, it was not with the token or client secret as the I had already highlighted with a ticket created newly but with the same issue. It was something related to the body. The error when I create or update entity using post request does not give accurate message which makes it very difficult for the end users to understand.

The body has to be perfect with the parameters when you try to update.

Following is the body I used when using POST request and it worked for me when updating the description of any column of an entity.

{ "referredEntities": {}, "entity": { "typeName": "azure_synapse_dedicated_sql_column", "attributes": { "modifiedTime": 0, "createTime": 0, "qualifiedName": "mssql://(purview name).sql.azuresynapse.net/(column name url)", "name": "(column name)", "description": "(Column Description that needs to be updated)", "data_type": "decimal", "publicAccessLevel": null } } }

Thanks,
Karan
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-06-05T05:09:10.3633333+00:00

@Jadhav, Karan - Glad to know that your issue has been resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.

Share via

Purview Updating Entity, Assets column, description etc

1 answer

Your answer