Skip to main content

Posts

Showing posts with the label Microsoft Dynamics CRM

Deep Dive into Dynamics 365 & Azure Cosmos DB using Azure Logic Apps

Logic Apps Logic Apps helps you build, schedule, and automate processes as workflows so you can integrate apps, data, systems, and services across enterprises or organizations. To build integration solutions with logic apps, we can choose from a growing gallery of ~200 built-in connectors, such as Dynamics 365, SQL Database, Azure services (Azure Cosmos DB, Azure Table Service, etc.), Office 365, Salesforce, Google, and more. These connectors provide triggers, actions, or both for creating logic apps that securely access and process data in real time. Benefits of using Azure Logic Apps: Out-of-the-box connectors reduce integration challenges Faster development using Logic App Templates Re-usability of the Logic Apps Pay only for what you use Use Case Today, we'll be looking at listing Dynamics 365 records, using Logic Apps, and then performing some processing on the data (sending email to retrieved accounts, storing contact email id in an Array Variable) and finall...

Retrieve 5000+ Records in Dynamics 365 CE using CRM OData, Fetch XML and C#

If you want to retrieve 5000+ records in Dynamics 365 CE, you need to make use of Paging concept of CRM. By default 5000 records are retrieved in a single OData call in CRM. To get more, you need to make subsequent calls to OData Endpoint by passing a paging cookie in the request. I will be using a simple C# Console Application to retrieve 5000+ records from Dynamics 365 CE, by making use of OData API Endpoint provided by CRM and passing Fetch XML in OData Call . Concept: CRM OData Endpoints allows us to use Fetch XML to retrieve data from Microsoft Dynamics 365 CE.  If your resultset has more than 5000 records, you will be returned with first 5000 records ONLY in one OData call. To know if the resultset has more than 5000 records, we make use of the response from OData call. The response is added with a cookie value contained in a key - "@Microsoft.Dynamics.CRM.fetchxmlpagingcookie" If you wish to fetch the next set of resultset data, you will have to pass this c...