Hi,
Try this code, you might have to edit some minor stuff since I edited it to suit your needs in a text editor.
Verify the exact name of the entity by editing it in crm and copying the name from the name field there, this query returns dynamic entities in the response.
/// <summary>
/// Function that handles querying the crm system with the sent in data.
/// </summary>
/// <param name="crmService">CrmService object used to send the query.</param>
/// <returns>Collection of found objects as dynamic entity</returns>
public RetrieveMultipleResponse QueryCrmDynamic(CrmService crmService)
{
//Condition to add to the search that the record must be active.
ConditionExpression _conditionStatus = new ConditionExpression();
_conditionStatus.AttributeName = "statecode";
_conditionStatus.Operator = ConditionOperator.Equal;
_conditionStatus.Values = new object[] { 0 };
//Create the query expression
QueryExpression expression = new QueryExpression();
//Set the entity name
expression.EntityName = "ugl_teammemberid"; //Verify the correct name by editing the entity and copy the name direct.
//Add the condition to the query expression
expression.Criteria.Conditions.Add(_conditionStatus);
//Define the columns returned from the search.
expression.ColumnSet = new AllColumns();
//Create a retrieve request.
RetrieveMultipleRequest retrieveMultipleRequest = new RetrieveMultipleRequest();
retrieveMultipleRequest.Query = expression;
//Make sure to return dynamic entities.
retrieveMultipleRequest.ReturnDynamicEntities = true;
//Execute the request.
RetrieveMultipleResponse retrieveMultipleResponse = (RetrieveMultipleResponse)crmService.Execute(retrieveMultipleRequest);
//Return the multiple request response.
return retrieveMultipleResponse;
}
Halldór Jóhannsson
