Issue Description

An error occurs when executing a List method on a View or Form at runtime for Microsoft CRM and Microsoft NAV using the OData Service Broker.

Error

“Exception has been thrown by the target of an invocation”.

Cause

Microsoft CRM and Microsoft NAV do not support all the parameters of OData.

Resolution

  1. Ensure you have K2 4.7 installed.
  2. Download and Install the K2 4.7 May 2017 Cumulative Update from K2 Partner and Customer Portal.
  3. Get the K2 4.7 May 2017 Cumulative Update FP5 from Regional Support.
  4. Install the K2 4.7 May 2017 Cumulative Update FP5 to apply the fix.
  5. Edit the OData Service Instance and note that a new Service Key is available called “Exclude query parameters”.
  6. Enter the parameters to be excluded (enter excluded parameters separated by a comma) :
    • $top,$skip,$orderby,$inlinecount
  7. Refresh the SmartObject created from the OData Service Instance.