Writing CRM callouts with filtered views

Aaron Elder, a valued Microsoft MVP and CRM solutions provider provides this guest blog today. A common problem that we often face when writing CRM callouts is how to call Filtered Views from within the callout. We might want to do this, for a variety of reasons such as performing T-SQL operations, JOINs and the like. The problem of course is that the CRM Filtered Views “filter” / provide row-level security based on the AD user that is making the request. This is why you normally cannot use SQL Authentication...(read more)