How To Update The Table Row Values In A Dataverse Environment From Postman

Update The Table Row Values In A Dataverse Environment From Postman

Postman is an API platform for developers to design, build, test, and iterate their APIs.

In this article, will explain about updating row values in Accounts Table in the Dataverse environment from Postman.

Pre-requisite

Follow all the steps mentioned in the article mentioned above and then follow the below steps.

Step 1

Click on the Collection … and Click on Add request to create a new Web API Request.

Update The Table Row Values In A Dataverse Environment From Postman

Step 2 

Click on the New Request  and Click on Rename to change the Web API Request name.

Update The Table Row Values In A Dataverse Environment From Postman

Renamed to Update Account record.

Update The Table Row Values In A Dataverse Environment From Postman

Step 3

Select PATCH HTTP Verb and provide the below text to update the Account record.

{{webapiurl}}accounts(ProvideAccountRecordGUID)

Update The Table Row Values In A Dataverse Environment From Postman

Step 4 

Provide the below values under Headers section.

If-Match *
OData-Version 4.0
OData-MaxVersion 4.0
Content-Type application/json
Accept application/json

 

Note: If-Match value set to * in the header, it ensures that it doesn’t create any new record by accidentally performing an upsert operation.

Headers will look like the below.

Update The Table Row Values In A Dataverse Environment From Postman

Step 5 

Click on Body, select raw and make sure that JSON is selected.

Update The Table Row Values In A Dataverse Environment From Postman

Step 6 

Copy and paste the below JSON text to update Account’s Name and Description values.

{
    "name": "Arun Potti – Microsoft – Updated",
    "description": "Record updated from Postman"
}

Update The Table Row Values In A Dataverse Environment From Postman

Step 7 

Click on Save and Send.

Update The Table Row Values In A Dataverse Environment From Postman

You can see a message 204 No Content, which means the request was executed successfully.

Update The Table Row Values In A Dataverse Environment From Postman

Note: If you see 401 Unauthorized access issue on Send, then follow the below article and fix the problem and try again.

How to resolve 401 Unauthorized access issue in Postman while connecting to Dataverse?

You can check the record updated information in the Advanced Find.

Update The Table Row Values In A Dataverse Environment From Postman

Hope you have followed all the steps and updated the Account Table row values from Postman.

Like and share your valuable feedback on this article.


Similar Articles