InfoPath Dev

I like the webservice, real easy to set up and use. The only problem I am having is I can get the manager info but I get the Cn, ou and everything else. Is there a way to pull just the CN portion of the manager information.
What I am getting?
(Example:manager CN=testgp,OU=IT Department,DC=crmc,DC=com)

What I need?
(Example: testgp)

Any help would be appreciated.

Thanks

Which webservice are you referring to?

I'm assuming you have key/value pairs. If so, then you get the webservice/returnvalue/value[../key = 'CN'] --or equivelent-- webservice/returnvalue[key = 'CN']/value

QDABRA AD web service.

I've moved this discussion to the Qdabra AD WebService forum...

Yes, you should be able to filter using the key/value pairs, as described before, to get the value you want. I don't have the exact xpath for you, but you should be able to decipher what I wrote earlier to understand how to get the value you want. If you have further specific questions, please ask.

I will keep trying, but so far I get the distinguished name info and when I try to filter out even further to just get the CN= portion of the distinguished name I am getting nothing at all. If you can get the xpath that would do this I would appreciate it, but I am not going to give up trying to work it out.

Thanks
David Quick

The distinguishedName key provides a concatenation of comma seperated values. You can use string-before(string-after(<field>, "CN="), ",") to pull out the particular value you are looking for.

However, if you place a repeating table on your view bound to the repeating ADProp group from the web service, it will show you all the key value pairs. Most likely one of the other keys will give you the value you are looking for.

For example, perhaps you can use the following keys to get the same data:

"cn", "displayName", or "name"

In my test, each of those keys give me the same data as is contained in the distinguishedName under CN=xyz. Results may vary based on your actual Active Directory data.

Hope this helps.

Oh, I should mention that the reason the key "CN" didn't work from my example above was because it is actually a lowercase key "cn".

Sorry if I misunderstood your original question -- now that I'm looking back on it. You can certainly use the string-before/string-after functions to get what you need... but first take a look and see if your data is more readily available from another key, without needing to go through all the trouble.

Good luck and let me know how it works out!

Thanks I will definitely give it a try.

I had same issue and this is how I solved it.

1) Created a text field called managerGet

default value is

Value[Key = "manager"]

 Note Value is the Value in ADProp

2) Created second text field that will be displayed on form called singleName

default value is

substring-after(substring-before(managerGet, ","), "CN=")

Now I am trying to figure out how to take that and get the managers email address.  Anyone have an idea?  I went through the setup reference about adding GetUserInfo, repeating table and button.  But I want it to populate a field to use when submitting.

 

Chris