Monday, October 15, 2018
In part 1 of this post I demonstrated building and using a service which receives a FetchXML query and returns Dynamics 365 data to any Portal page in an asynchronous manner as a JSON object. This service is similar to the SDK’s RetrieveMultiple message.
In this part 2, I’ll demonstrate a different service, which like the SDK Retrieve message, receives a record type, record id (GUID) and columns set to return the required data as a JSON object.
This is useful when you already have a specific Dynamics 365 record id at hand and you want to retrieve additional data for...
Friday, October 12, 2018
Leveraging Colin Vermander brilliant article on using Liquid Templates to return JSON, I would like to demonstrate creating and using a ‘service’ to asynchronously retrieve Dynamics 365 data into any portal page.
Why is this useful?
Liquid Templates tags are rendered on server side before a response is returned to the browser, so FetchXML tag will return a static result once the page is returned.
But what about responding dynamically to client side events such as option selection, button click or expending an element to view more details?
Sending the page to the server again is no longer an option if you want...
Friday, August 12, 2011
Updating CRM records via Excel Export in Microsoft Dynamics CRM 2011 In Microsoft Dynamics CRM 2011 data can be exported to Excel file. This feature can be used to update CRM data externally and then import back while updating the matching CRM records. When exporting data to Excel, select the ‘Static worksheet option’ and check the ‘Make this data available for re-importing’ checkbox. Off course, the re-importing functionality relies on the CRM records GUIDs to uniquely identify each CRM records that requires an update. But when you open...