Using Sharepoint web services to establish data connections

[David Baldacchino]

Hi all,

I'm after a solution to create an infopath query form with data residing in
Sharepoint lists. After lots of reading, it seems that the best solution to
query data in Sharepoint lists is to use a web service. I'm quite new to all
this and I'm after a solution without coding if at all possible. If that's
not realistic, please let me know as it would save me from going in circles,
and I'm already getting quite dizzy

I simply need to query a large SP list based on a number of fields in
drop-down list boxes that users will be selecting from, just like one would
do in a form tied to Access as the data source. That's not my problem and I
know how to do that and filter the data, etc. The difficulty is with querying
based on those fields. If you establish a data connection to a SP list, you
get the whole enchilada. That's not what I want obviously and after further
reading, I found pieces of information that led me to believe that using the
"lists" web service would do the trick. See the following site:

http://www.developer.com/tech/article.php/3104621

I was able to connect to some of the services such as the GetListCollection
and GetList (I don't know how to use them and I don't think they're what I
need), but I have been unable to connect to the GetListItems. Please click
the link below for an image that explains what is happening:

http://www.infopathdev.com/forums/storage/46/32747/Web service.jpg

If I can get a data connection with query fields and data fields for the
columns I need (all of the ones in the list), then I'd know how to proceed,
which is identical to when using an Access database for the data connections.
I'm hoping this is not a dead end and without some serious guidance, I
probably won't be able to code a solution. Thanks in advance for your help!

 

[Santhosh]

Hi,

You can get this by using GetListItems data connection. But it includes some
code part. Go through this blog to connect to GetListItems.

http://www.infopathdev.com/blogs/ag...rm-Library-Using-GetListItems-Web-Method.aspx

 

[David Baldacchino]

Thanks, I have looked at that blog post before posting here in fact, but
unfortunately I don't have Visual Studio. I tried installing VS Express
(Visual Basic) but did not have an option for a new Infopath project. I was
trying to follow that tutorial example to see if I could understand it deep
enough to try and adapt it to my particular situation (a Sharepoint list).
One of the pieces that needs edited is "manifest.xsn" and that seems to be
created only when you create a new VS Infopath project. Any ideas?