In this blog, we will learn how to use aggregate in FetchXml. Available Aggregate Count CountColumn Avg Sum Min Max 1. Count It aggregates data based on specified conditions and returns a numerical value representing the count of records meeting those conditions. Output: 2. CountColumn This attribute helps group data…
In this blog, we will learn how to use operators like, not-like, on, in, not-in, on-or-before, and on-or-after in Web API. What is “like” operator? The like operator in FetchXML is used for performing partial string matching in a query. It allows you to filter records based on a specific…
This blog post will provide instructions on retrieving or removing the metadata of an Option Set or Multi-Select Option Set using the Web API. 1.1 Get Option Set/Multi-Select Option Set metadata from Web API In MSCRM, the String Map table can be utilized to retrieve details regarding option sets. This…
Batch Request allows us to make multiple API calls within a single API call. We’re limited to 1000 API calls in a single batch request. The HTTP method only supports POST, PATCH & DELETE in Batch Request. In this Blog, We’re calling 3 API calls in a single Batch Request.…
Introduction: In this Blog, we will learn how to use filter in expand of OData. Example: Let’s say we have an account with multiple contacts, and we want to filter out only the contacts who have their contact method listed as ‘Email’. How to write API Request: a. You can…
Set up a Postman Environment and Application User for Dynamics 365 CE This blog explains how to set up postman environment to query D365 CE data and how to create application user. Create Azure App Create new App Registration in Azure, under Azure Active Directory. Click on New Registration to register…
Create Notes with Attachment using Web API in Dynamics 365 Create Notes record with Attachment for Contact Entity var note = {}; note.subject = "Notes Subject"; note.notetext = "Notes Text"; note.filename = "FileName.txt"; note.documentbody = "Base64String"; note["objectid_contact@odata.bind"] = "/contacts(00000000-0000-0000-000000000000)"; Xrm.WebApi.createRecord("annotation", note).then( function success(result) { alert("Success"); }, function(error) { alert(error.message); });…
POST request is used to create a record, So we’ll use POST request to create Parent – Child record. Select the POST request, Set the Dynamics API URL and entity set name in the header. 1.1 Create a Contact Entity Record with New Parent Account Record To create Parent Account…
Use postman to Create record in Dynamics with the Web API POST request is used to send data to create a record. Select the POST request, Set the Dynamics API URL and entity set name in the header. How to get API URL : Advance Settings >> Customizations >> Developer…
How to open panel on click of record of basic list in PCF? Introduction In this blog, I am going to show you how to open a panel when a hyperlink is clicked using PCF control. Solution I have created a sample detail list that has some data which is…