Infopath Browser Form - Webservice return value

[arduk]

I have an infopath form which I would like to browser enable. The form
retrieves some data from an Excel spreadsheet via an Excel Services
webservice (GetRangeA1).

The form works fine when it runs in the client, however when I try to deploy
it as a browser form the compatibility checker gives the following error:
"Unsupported Expression"
and the details are:
"The following expression could not be parsed because of a syntax error or
because it uses an undefined namespace prefix or unsupported function:
xsXDocument:GetDOM("GetPriceData")/dfs:myFields/dfs:dataFields/tns:getRangeA1Response/tns:GetRangeA1Result/tns:anyType[1]."

The problem, I believe, is that the GetRangeA1 web service returns an array
of data, so in order to use a particular value, I am having to index into the
array. I am doing this as shown above by referencing as "anyType[1]", to get
the first array value.

My questions are:
Is this method of retrieving an array value not supported by Forms Services?
If this is not supported by Forms Services, how do I reference the
individual fields of the array which is returned by the web service?
Is there a method of getting individual values that will work in both
client, and Forms Services browser forms?

Thanks in advance for any assistance on this

[Steven Cheng]

Hi Arduk,

As for reading range and values through Excel service, here is a MSDN
reference which mentioned how to get rows and fields from results returned
by GetRangeA1 and other methods:

#How to: Get Values from Ranges
http://msdn2.microsoft.com/en-us/library/ms500767.aspx

for your scenario, have you tried simply call the webservice method to see
whether it can return the correct results? Also, I think you can try some
simpler data(for the excel sheet on server) to see whether the problem also
specific to some data in the sheet.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we

can improve the support we provide to you. Please feel free to let my
manager know what you think of

the level of service provided. You can send feedback directly to my manager
at: msd...@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to

http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response

from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take

approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution.

The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump

analysis issues. Issues of this nature are best handled working with a
dedicated Microsoft Support

Engineer by contacting Microsoft Customer Support Services (CSS) at

http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: =?Utf-8?B?YXJkdWs=?= <ar...@nospam.nospam>
Subject: Infopath Browser Form - Webservice return value
Date: Mon, 10 Mar 2008 21:30:00 -0700

[arduk]

Hi Steven, thanks for getting back to me.

As mentioned in my first post, I can get the range, and reference individual
values fine from the infopath form (without code) when it runs in the client,
using the expression that I included in my original post (ie for a return
value called AnyType, I am using an expression that ends with AnyType[1] to
get the first value)

The problem occurs when I try to create a browser compatible form - the
compatibility checker returns the error which I quoted in my original post.

So my questions are:

Is this method of retrieving an array value not supported by Forms Services?
If this is not supported by Forms Services, how do I reference the

individual fields of the array which is returned by the web service (without
code)?

Is there a method of getting individual values that will work in both

client, and Forms Services browser forms (again, without using code)?

I have tried to do this using a simple range (ie one cell) but the problem
is the same.

Thanks in advance

[Steven Cheng]

Thanks for your reply Arduk,

So the problem seems quite related to the infopath form side. I'll do some
further research and discuss with some other infopath and xls service
engineers to see whether they have any ideas. I'll keep informing you of
any update I get.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: =?Utf-8?B?YXJkdWs=?= <ar...@nospam.nospam>
References: <3E9B3FBB-5BAA-4987...@microsoft.com>
<3oNvXz1g...@TK2MSFTNGHUB02.phx.gbl>
Subject: RE: Infopath Browser Form - Webservice return value
Date: Tue, 11 Mar 2008 14:00:05 -0700

[Steven Cheng]

Hi Arduk,

Just inform you that I'm still doing research on this.

Steven Cheng
Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: stc...@online.microsoft.com ("Steven Cheng")
Organization: Microsoft
Date: Thu, 13 Mar 2008 03:26:02 GMT

[arduk]

Hi Steven,

Have you made any progress on this?

thanks in advance

[Steven Cheng [MSFT]]

Hi Arduk,

Sorry for keep you waiting.

Yes, I've got one of the Form service team engineer who would like to have
a look at this issue. If convenient, would you create a very simple sample
packge that contains the webservice code and a simple Form which can repro
the problem? You can also include a clear step to do it so that I can
forward it to that engineer for some further testing. You can reach me at
the following address:

"stcheng" + "@" + "microsoft.com"

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: =?Utf-8?B?YXJkdWs=?= <ar...@nospam.nospam>
References: <3E9B3FBB-5BAA-4987...@microsoft.com>
<3oNvXz1g...@TK2MSFTNGHUB02.phx.gbl>

<97501DE4-060C-4D5D...@microsoft.com>
<BqjU#nLhIH...@TK2MSFTNGHUB02.phx.gbl>
<Y$zcQyMiI...@TK2MSFTNGHUB02.phx.gbl>

Subject: RE: Infopath Browser Form - Webservice return value

Date: Tue, 1 Apr 2008 15:08:03 -0700

[Steven Cheng [MSFT]]

Hi Arduk,

I haven't received message from you, have you sent me any repro package?
I'm still monitoring this issue, and feel free to let me know if there is
any problem.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

--------------------
From: stc...@online.microsoft.com (Steven Cheng [MSFT])
Organization: Microsoft
Date: Wed, 02 Apr 2008 02:02:20 GMT

[arduk]

Hi Steven,

Note that I sent through the form and information on how to reproduce the
problem.

Thanks for your assistance - I look forward to hearing from you.

[Steven Cheng [MSFT]]

Thanks for your followup Arduk,

Yes, I've forwarded it to some dev engineers who will take a look. However,
it may take some time since the dev engineers current also have some other
works on hande. I'll keep contacting with them and let you informed.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msd...@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: =?Utf-8?B?YXJkdWs=?= <ar...@nospam.nospam>
Date: Wed, 9 Apr 2008 21:08:09 -0700