General

Re: Parse string array from web service

jyehwyle — Wed, 22 Dec 2010 19:33:56 GMT

The web service is something I actually designed, but other applications from my company use it besides the one I'm making now. So I'd rather not change the web service.

Well, perhaps I'll duplicate the method I'm using for my Infopath form and change the output format. Seems like the only option in Infopath to parse string arrays is to use custom code, and I really want to avoid that since I have a lot of rules in place.

Re: Parse string array from web service

Jimmy — Wed, 22 Dec 2010 16:58:07 GMT

After some searching around, it looks like this is a limitation of IPFS. It seems browser-based forms don't allow using XPath with filters (i.e. using brackets []).

Is the Web Service you're calling something that your organization designed, or a third-party service? If there's any way to get the service to return the values in XML with named nodes, that might be an ideal solution to this issue.

Re: Parse string array from web service

jyehwyle — Wed, 22 Dec 2010 16:33:12 GMT

Yeah, the expression works without the [] part. Here's what I just tested.

xdXDocument:GetDOM("GetADUser")/dfs:myFields/dfs:dataFields/tns:GetADUserResponse/tns:GetADUserResult/tns:string[2]

Without the [] is what I posted in my original message. Is it possible an issue w/ Infopath Form Services? I'm publishing the form to Sharepoint.

Re: Parse string array from web service

Jimmy — Wed, 22 Dec 2010 16:29:08 GMT

Well, that should work. Are you saying it the expression is fine without the [] part, but as soon as you add the [] part it gives that error? Could you paste the exact expressions you're using with and without the [] part (and check the Show XPath checkbox before you do).

Re: Parse string array from web service

jyehwyle — Wed, 22 Dec 2010 16:20:45 GMT

Jimmy:
xdXDocument:GetDOM("GetADUser")/dfs:myFields/dfs:dataFields/tns:GetADUserResponse/tns:GetADUserResult/tns:string[index]

should work. Note that index here is 1-based, not 0-based.

That was the first thing I tried and it didn't work. I tried it again, but every time I publish the form Infopath throws the below error. If only it was that easy to specify a specific item in the array.

"The following expression could not be parsed because of a syntax error or because it uses an undefined namespace prefix or unsupported function."

Re: Parse string array from web service

Jimmy — Wed, 22 Dec 2010 16:08:50 GMT

xdXDocument:GetDOM("GetADUser")/dfs:myFields/dfs:dataFields/tns:GetADUserResponse/tns:GetADUserResult/tns:string[index]

should work. Note that index here is 1-based, not 0-based.

Re: Parse string array from web service

jyehwyle — Wed, 22 Dec 2010 15:59:03 GMT

Thanks for the reply Ernesto.

However I don't think filtering will work in my case since the AD web service I'm using returns a single dimension string array. The Qdabra web service seems to return key value pairs (or maybe a multi-dimensional array). I need to somehow specify the index of the string array in Infopath.

Re: Parse string array from web service

ErnestoM — Wed, 22 Dec 2010 14:15:40 GMT

You can use filtering to pull down one specific item. We document this for our AD web service here:

http://www.infopathdev.com/files/folders/other_topics/entry56832.aspx

Hope it helps!

Parse string array from web service

jyehwyle — Wed, 22 Dec 2010 00:18:57 GMT

I'm looking for some help with pulling data from a web service. The web service pulls user account info from Active Directory and returns a string array. The string array shows up as simply "string" under the web service data source in Infopath. When I set a field with the returned data and submit the form, only the first item in the array is actually returned. Is there a way to pull a specific item in the string array without using code? I've tried tweaking the xpath, but haven't been successful. Here's what the xpath looks like.

xdXDocument:GetDOM("GetADUser")/dfs:myFields/dfs:dataFields/tns:GetADUserResponse/tns:GetADUserResult/tns:string