Get the User Profile through MOSS Web Services

InfoPath 2007 - Get the User Profile through MOSS Web Services

Meron Fridman's Blog — Wed, 07 Mar 2007 22:25:38 GMT

עלתה השאלה איך לטעון לתוך הטופס את פרטי המשתמש office user group במפגש האחרון של ה VSTO דרך שירותי ws

InfoPath - Get the current user without writing code

itaysk — Thu, 05 Apr 2007 14:07:55 GMT

I've just read Meron Fridman's post from about a month ago about getting current user details into InfoPath

re: Get the User Profile through MOSS Web Services

planier — Wed, 09 May 2007 09:25:12 GMT

Great article!

Let's take it one step further and make it a no-code solution! How? Throw out steps 3 and 4. Instead:

3) Create a new data connection to retrieve information from the specified web service (http://<yourServerName>/_vti_bin/UserProfileService.asmx?WSDL), and select the "GetUserProfileByName" web method.

4) Use an XPath query on your secondary data source to populate the fields you want. For instance, use a formula to set the default value for an "email address" field. You'll be selecting the "dataFields/.../Value" field. The trick is to ensure you select the correct PropertyData node, as it is a repeating field - you'll have to edit the XPath to do so. Assuming your secondary data source is called "GetUserProfileByName", the XPath query required to get the current user's email address looks as follows:

xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData[s0:Name = "WorkEmail"]/s0:Values/s0:ValueData/s0:Value

Works beautifully, and without needing to bust out any code!

re: Get the User Profile through MOSS Web Services

planier — Wed, 09 May 2007 20:29:54 GMT

Update: Note that the track-back above my post by Itay goes over the secondary data source option in more detail, with screenshots and all. Nice work Itay!

re: Get the User Profile through MOSS Web Services

dwumpus — Tue, 22 May 2007 23:37:31 GMT

You are in-fact my Hero. I just got through writing this complicated webservice to return information from a the users context and deployed it to a document library and hadn't finished getting all that working when I realized that there really should be an easier way.

Thank you so much, you made my day!

MOSS: Leyendo los user profiles

Blog del CIIN — Mon, 18 Jun 2007 13:15:05 GMT

Uno de los retos que se nos ha planteado en el CIIN es como visualizar el directorio de empleados de

re: Get the User Profile through MOSS Web Services

ultragc — Wed, 20 Jun 2007 18:11:39 GMT

Hi,

This is a nice post. I am an InfoPath newbie and I've been looking for something list this. I tested your code... it works good. However, it won't work if I use it thru the SharePoint portal. I think this has to do with the security/trust option.

Basically, what I want to do is perform the same thing but under a web browser (SharePoint portal) environment. If a user login to portal on a "share" PC, it would be wrong to pickup the PC's login credential. So, what do your recommend?

Thanks in advance.

Ultra

re: Get the User Profile through MOSS Web Services

ultragc — Wed, 20 Jun 2007 22:05:21 GMT

Planier... I tested your "no code" approach. What's strange is that it works if I create a brand now form but it won't work if I do this on an existing form.

This is what I enter...

"xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData[s0:Name = "WorkEmail"]/s0:Values/s0:ValueData/s0:Value"

and I get this error...

''"xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData/s0:Values/s0:ValueData/s0:Value" does not point to a valid location path of a field or group."

Any idea?

Thanks

re: Get the User Profile through MOSS Web Services

ultragc — Wed, 20 Jun 2007 23:33:48 GMT

I had to modify the GetUserProfileByName data source to initialize the default value with a space.

re: Get the User Profile through MOSS Web Services

Gyan Penrose-Kafka — Fri, 22 Jun 2007 17:21:50 GMT

Got this working perfectly with the codeless method. What I'm wondering is where can I get information about this XPath information. (e.g. how do you come up with the XPath string "xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData[s0:Name = "WorkEmail"]/s0:Values/s0:ValueData/s0:Value"? Is there a book or a reference that could get me going on understanding how to access this kind of information?

Thanks,

Gyan.

re: Get the User Profile through MOSS Web Services

needo — Fri, 31 Aug 2007 17:20:35 GMT

Hello

I have refrence to Microsoft.Office.InfoPath and can see the xmlForm class in code but i receive error at "MainDataSource" error is "The name MainDataSource does not exist in the current context " if i use "this." there is no MaindataSource, the same kinf of problem exists with "NamespaceManager".

I am dealing with these refrence errors from a long time, please help me how to fix above error.

Thanks

Needo

re: Get the User Profile through MOSS Web Services

SKBG — Mon, 08 Oct 2007 12:29:02 GMT

Hi,

What if the WSS was configured for Forms Authentication, how can we get the current user's identity or profile in say infopath form to populate some data specific to user's role etc in actions pane.

Kind Regards

Satish.

Get the User Profile through MOSS Web Services

Aziz — Mon, 28 Jan 2008 11:44:51 GMT

i was trying to make a form with a field that contain Employee name i found the best way to do so is

re: Get the User Profile through MOSS Web Services

sukiep — Wed, 30 Jan 2008 00:21:04 GMT

In Step 4, when I select Tools | Programming | Loading Event, I see UserProfileDemo open in VSTA, and I find FormEvents_Loading in a FormCode.vb file. This looks like Visual Basic to me, but the code snippet looks like C.

Obviously I'm not much of a programmer, so don't know how to proceed. Any help appreciated -- thank you.

re: Get the User Profile through MOSS Web Services

vuthy — Thu, 27 Mar 2008 09:40:48 GMT

Hi All,

I'd like to populate a list of users into infopath form based on a selected profile property. Could anyone give some idea on how to go through.

Thanks in advance!

re: Get the User Profile through MOSS Web Services

HyperGO — Mon, 26 May 2008 18:29:47 GMT

Hello All:

I got this error after previewing the IP form:

"The query cannot be run for the following DataObject: GetUserProfileByName

InfoPath cannot run the specified query.

The SOAP response indicates that an error occurred on the server:

The User Profile Manager object could not be loaded. ---> Value cannot be null.

Parameter name: serverContext"

* Note : I have my form "full trust"

Thanks in advance

InfoPath - Get the current user without writing code 取得当前用户

aguest — Tue, 15 Jul 2008 08:38:49 GMT

www.ceapet.com InfoPath-Getthecurrentuserwithoutwritingcode

I'vejust

MOSS: Cómo actualizar los User Profiles!

Blog del CIIN — Fri, 01 Aug 2008 01:03:40 GMT

Hace un tiempo os comentaba como podemos leer User Profiles de MOSS . Como sabéis, cuando hablamos de

FBA in SharePoint – Everything you’ve ever wanted to do - continued

justguy's — Fri, 01 Aug 2008 10:23:15 GMT

Hi, This is my 2nd post on this subject. This post will get down and dirty with code samples. The first

re: Get the User Profile through MOSS Web Services

gsardinha — Thu, 20 Nov 2008 17:59:24 GMT

Hi everyone. I know you are going to hate me for this one, but here we go:

I designed a form in 2003 and though publishing it in WSS 2.0 I am using this service from MOSS (GetUserProfile). Though me and a colleague do not have a problem when opening and submiting a form, several colleagues have either:

"The following DataObject either cannot be created or cannot be initialized: GetUserProfileByName

The query cannot be run for the following DataObject: GetUserProfileByName

InfoPath cannot run the specified query.

Access is denied."

"The following DataObject either cannot be created or cannot be initialized: GetCommonManager

The query cannot be run for the following DataObject: GetCommonManager

InfoPath cannot run the specified query.

The SOAP response indicates that an error occurred on the server:

Server was unable to process request. ---> Object reference not set to an instance of an object."

I already removed the one of the services and still I have the same problem. I know it is asking a bit too much, but if you guys can through me a light, I'll appreciate it.

Best,

Gonçalo Sardinha

WSS 3.0 & MOSS: Preguntas & Respuestas (I)!

Blog del CIIN — Mon, 27 Apr 2009 18:44:30 GMT

Sin duda, una de las ventajas de realizar formación tecnológica especializada es que aprenden

re: Get the User Profile through MOSS Web Services

lvirden — Fri, 22 May 2009 15:18:17 GMT

Is there a "no coding" method of getting the user profile for someone other than the current user?

I want to provide a field where the user could type in someone's account name and other fields in the form are filled in.

re: Get the User Profile through MOSS Web Services

infopath — Fri, 22 May 2009 15:43:09 GMT

Hi lvirden,

You should be able to use a Rule. As you have probably seen, when you create the connection to the UserProfileService and select the GetUserProfileByName method, you have a "queryField" in your data connection: AccountName. What you can do is something like this:

- Have a textbox on your View where the user would enter the name

- Have a button that contains a Rule with the following actions:

- Set a field's value (this would set the "AccountName" queryField to the field that contains the name the user entered)

- Query using a data connection (this would execute the web service data connection...in this scenario, you would want to make sure when you setup the data connection it does *not* automatically get the data when the form loads)

This should allow the user to enter someone else's name and still retrieve data for that user.

Scott

re: Get the User Profile through MOSS Web Services

prasadsm — Tue, 09 Jun 2009 11:52:23 GMT

hi,

if i want to find out a user or users with matching a specific criteria, using this userprofileweb service, how can i find it ?

like if i want to find out the users whose names are starting with tim* (like timothy, tim john, tim hanss etc etc)

is there any kind of filtering kind of methods available or is possible through this web service?

re: Get the User Profile through MOSS Web Services

dvn — Wed, 17 Jun 2009 18:24:11 GMT

The Add Reference button is disabled when i try to Add Web Reference: http://myserver/_vti_bin/UserProfileService.asmx.

Can someone tell me why?

Since the sharepoint server setup by someone else who is no longer with the company, how do i verify if the the following assumptions are correct?

1. The default MOSS web application is configured to use Windows Authentication.

2. The MOSS server has an SSP with a User Profile Database that has been loaded from Active Directory

3. The end-user has a profile in the User Profile Database of the MOSS server

re: Get the User Profile through MOSS Web Services

ClaytonCobb — Sun, 21 Jun 2009 17:58:07 GMT

For lvirden and infopath, I have created an entire write-up that shows how to use the codeless method shown by Itay to get user information for people other than the current user: InfoPath – Get user information without writing code (extended): http://claytoncobb.wordpress.com/2009/06/21/userprofileservice-extended/.