Build XRMServices Request for Microsoft Dynamics CRM

Use the CRM 2011 OData Query Designer tool. In addition, here’s some examples: Get Quote details for a specific quote /XRMServices/2011/OrganizationData.svc/QuoteDetailSet?$filter=QuoteId/Id eq guid'<RECORD_GUID>’ Get specific property details (e.g. ExtendedAmount and Quantity) for a specific entity (e.g. Quote Detail) /XRMServices/2011/OrganizationData.svc/QuoteDetailSet?$select=ExtendedAmount,Quantity&$filter=QuoteId/Id eq guid'<RECORD_GUID>’ Filter on custom entities and how to use multiple …

MSSQL Collation Conflict

Ever get the following error? Cannot resolve the collation conflict between “Latin1_General_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. I had separate databases on different servers that I needed to query off of. In my case, it was a join between a table on the local server and a table …