通过 Web 服务列出活动

Question

我正在尝试通过 Web 服务重现 Microsoft CRM 4.0 中的“活动”页面。我可以检索活动列表，并且我相信我需要使用 ActivityPointers 来检索实体，但到目前为止尚未成功。我是否需要循环遍历第一个查询返回的每个实体来检索它的 ActivityPointer？如果是这样，我将如何获取活动的“关于”字段或主题（例如：电子邮件）。

检索活动的代码是：

    var svc = GetCrmService();
    var cols = new ColumnSet();
    cols.Attributes = new[] { "activityid", "addressused", "scheduledstart", "scheduledend", "partyid", "activitypartyid", "participationtypemask", "ownerid" };
    var query = new QueryExpression();
    query.EntityName = EntityName.activityparty.ToString();
    query.ColumnSet = cols;

    LinkEntity link = new LinkEntity();
    //link.LinkCriteria = filter;
    link.LinkFromEntityName = EntityName.activitypointer.ToString();
    link.LinkFromAttributeName = "activityid";
    link.LinkToEntityName = EntityName.activityparty.ToString();
    link.LinkToAttributeName = "activityid";
    query.LinkEntities = new[] {link};

    var activities = svc.RetrieveMultiple(query);
    var entities = new List<ICWebServices.activityparty>();
    RetrieveMultipleResponse retrieved = (RetrieveMultipleResponse) svc.Execute(request);
    //var pointers = new List<activitypointer>();
    foreach (activityparty c in activities.BusinessEntities)
    {
        entities.Add(((activityparty)c));
       //the entities don't seem to contain a link to the email which they came from
    }

Answer 1

不确定我是否理解您的问题，但 ActivityPointer 对象中的字段“activityid”与基础活动（电子邮件、任务、电话等）相同。 aboutobjectid 是相关实体的链接。

这是获得相当于“活动”页面所需的内容

        ColumnSet cols = new ColumnSet()
        {
           Attributes = new string[] { "subject", "regardingobjectid", "regardingobjectidname", "regardingobjectidtypecode", "activitytypecodename", "createdon", "scheduledstart", "scheduledend"  }
        };
        ConditionExpression condition = new ConditionExpression()
        {
           AttributeName = "ownerid",
           Operator = ConditionOperator.Equal,
           Values = new object[] { CurrentUser.systemuserid.Value } //CurrentUser is an systemuser object that represents the current user (WhoAmIRequest)
        };
        FilterExpression filter = new FilterExpression()
        {
           Conditions = new ConditionExpression[] { condition },
           FilterOperator = LogicalOperator.And
        };
        QueryExpression query = new QueryExpression()
        {
           EntityName = EntityName.activitypointer.ToString(),
           ColumnSet = cols,
           Criteria = filter
        };

        BusinessEntityCollection activities = svc.RetrieveMultiple(query);

        foreach (activitypointer activity in activities)
        {
           //do something with the activity

           //or get the email object
           email originalEmail = (email)svc.Retrieve(EntityName.email.ToString(), activity.activityid.Value, new AllColumns());

        }