SharePoint List with lookup and "Person or group"

#1

I have a SharePoint list that has some Lookups and I am able to pull that list it is looking up and join it to get at that data in the Metric Sets I make from the Data Cube.

What I want is the information from "Person or Group", like their email and phone number excreta.

I thought it might be like a list so I tried pulling in the List where the Person and Groups data is but no luck there.

Any suggestions or is the going to become a Feature Request?

#2

I believe you are refering to the SharePoint list called User Information List. It is somewhat hidden and only accessible to SharePoint administrators, but it is accessible through Dundas BI.


I think the following blog post will be able to help you with this:

https://blogs.technet.microsoft.com/marj/2016/03/14/what-is-hidden-user-information-userinfo-list-in-sharepoint-20102013-and-how-to-fix-when-it-causes-a-site-collection-to-show-old-user-metadata-properties-in-people-picker-control-or-in-a-person-or/

#3

I only get list when I put in "https://my.site.com/sites/abc/".

i have tried "https://my.site.com/sites/abc/_catalogs/" and "https://my.site.com/sites/abc/_catalogs//users/" and "https://my.site.com/sites/abc/_catalogs//users/simple.aspx".

All I get then is 3 errors:

Title: The connection cannot be established.
Details:
Web response code: 503 Service Unavailable (Dundas.BI.Data.DataConnectionException)

Error 2 of 3
Title: There was no endpoint listening at https://my.site.com/sites/abc/_catalogs/users/_vti_bin/Lists.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.
Details:
Web response code: 503 Service Unavailable (System.ServiceModel.EndpointNotFoundException)

Error 3 of 3
Title: The remote server returned an error: (404) Not Found.
Details:
Web response code: 503 Service Unavailable (System.Net.WebException)


I can go to https://my.site.com/sites/abc/_catalogs/users and see data and I am using Specified Windows creds with my log in, no I am not an admin, does this have to be an admins username and password?

#4

This list is accessible only for SharePoint admins. Can you try using an account that has administrative access on SharePoint?

#5

Well turns out that list does not have the email and phone number I need. Found that out before I dug deeper into pulling it into Dundas.