sharepoint - 在 SPServices 中获取用户的电子邮件 ID

Question

我正在使用 SPServices(GetListItems 方法)从共享点列表中获取一些信息。该列表包含一个“People or Group”类型字段，它返回用户的数字 ID 和名称(显示名称)，用分号分隔，如“43#;John Doe”。我需要该字段中所有用户的电子邮件地址(在返回的所有行中)。谁能帮忙？提前致谢。

Answer 1

保罗，你摇滚:)

从 Paul 的最后一条评论中，我得到了所需的东西。这是完美的。 :)

您唯一需要做的就是将以下内容添加到调用中

CAMLQueryOptions: "<QueryOptions><ExpandUserField>True</ExpandUserField></QueryOptions>",

所以我的示例调用变成了这个

$().SPServices({ operation: "GetListItems", async: false, listName: "Assignees", webURL: "https://col.wow.telenor.com/sites/go/",
            CAMLViewFields: "<ViewFields Properties='True'/>",
            CAMLQuery: "",
            CAMLQueryOptions: "<QueryOptions><ExpandUserField>True</ExpandUserField></QueryOptions>",
            completefunc: function (xData,Status) {

                $(xData.responseXML).SPFilterNode("z:row").each(function () {

                    try {
                    //ows_Name1 is a field of type "People or Group" the after adding CAMLQueryOptions this field returns all the fields
                    // propeties of user i.e. Displayname,ID,email id, domain login, sip ID etc all separate by #
                        var title = $(this).attr("ows_Name1"); 
                    // Splitting the resultant string with # give you string array of all the properties. In my case email ID is at 
                    // index 3.
                        var userEmail = userText.split('#')[3];
                    // Below line is added to remove the trailing "," from email id
                        userEmail = userEmail.substring(0,userEmail.indexOf(','));

                    }
                    catch (e) {
                        alert('Exception: ' + e.message);
                    }
                });
            }
        });

抱歉，保罗，我必须取消标记您的回答并做出这个回答:)