How To Create A Table Record In A Dataverse Environment From Postman

Arun Potti
2y
5.4k
3
1

Article

PostmanDataverseCreateAccountRecordJSon.zip

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

In this article, will explain about creating a record in Accounts Table in the Dataverse environment from Postman.

Will create an Account record with the below values.

Field Display Name	Field Schema Name	Data Type	Field Value
Account Name	name	Single Line of Text	Arun Potti – Microsoft
Contact Method	preferredcontactmethodcode	Choice	1 (Email)
Phone	donotphone	Boolean	true
Primary Contact	primarycontactid	Lookup (Contact)	13736f40-3955-ed11-bba2-000d3a36d83f (Provide existing contact GUID)
Last On Hold Time	lastonholdtime	Date	2022-10-26
Annual Revenue	revenue	Currency	15000000
Latitude	address1_latitude	Float	17.38714
Description	description	Multiple Lines of Text	Record created from Postman

Pre-requisite

How to setup and connect to the Dataverse environment in Postman?

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.

Create A Table Record in A Dataverse Environment From Postman

Step 2

Click on Rename to change the Web API Request name.

Create A Table Record in A Dataverse Environment From Postman

Renamed to Create Account record.

Create A Table Record in A Dataverse Environment From Postman

Step 3

Select POST Http Verb and provide the below text to create the Account record.

{{webapiurl}}accounts

Step 4

Provide the below values under Headers section.

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

Headers will look like below.

Create A Table Record in A Dataverse Environment From Postman

Step 5

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

Create A Table Record in A Dataverse Environment From Postman

Step 6

Copy and paste the below JSON text to create Account record.

{

    "name": "Arun Potti – Microsoft",

    "preferredcontactmethodcode": 2,

    "donotphone": true,

    "primarycontactid@odata.bind": "/contacts(13736f40-3955-ed11-bba2-000d3a36d83f)",

    "lastonholdtime": "2022-10-26",

    "revenue": 5000000,

    "address1_latitude": 17.38714,

    "description": "Record created from Postman"

}

You can find the JSON in the article attachment.

Create A Table Record in A Dataverse Environment From Postman

Step 7

Click on Save and Send.

Create A Table Record in A Dataverse Environment From Postman

You can see a message 204 No Content, which means the request was executed successfully, and can see the Account GUID in the Headers section in the OData-EntityId key value pair in the Web API URL format.

Create A Table Record in A Dataverse Environment From Postman