VasilyU

My orchestration consist a part of shapes to retrieve list from SharePoint portal by GetListItems web service method.

Construct shape have the following code to prepare request to the web service:

GetListItemsReqMsg.listName = "{...GUID...}";

GetListItemsReqMsg.listView = "{...GUID...}";

GetListItemsReqMsg.rowFilter = "";

GetListItemsReqMsg.query = new System.Xml.XmlDocument();

GetListItemsReqMsg.query.LoadXml ("<Query/>");

GetListItemsReqMsg.viewFields = new System.Xml.XmlDocument();

GetListItemsReqMsg.viewFields.LoadXml ("<ViewFields/>");

GetListItemsReqMsg.queryOptions = new System.Xml.XmlDocument();

GetListItemsReqMsg.queryOptions.LoadXml ("<QueryOptions/>");

When i started my orchestration SoapException occurred with the message "Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown.".

Where is an error at my Construct shape code




Re: SharePoint - General Question and Answers and Discussion Can`t retrieve SharePoint GetListItems from the BizTalk 2006 orchestration

Ishai Sagi

umm...listname parameter is not a guid, and the same for the viewname.

The only GUID you need is the web ID guid. try:

GetListItemsReqMsg.listName = "Announcements";

GetListItemsReqMsg.listView = ""; //this will get the default view. if you want a specific one, put in the name

GetListItemsReqMsg.webID = "{....}";

Note - to get the webID, you can use the SiteData web service, which returns a class wrapper for the web (_sWebMetaData) containing the ID, given the path you activated the web service with.

Also, there maybe an easier method of getting list items. I will be posting about this in my blog today, when I get all the screen shots ready. keep an eye open.

Ishai Sagi
www.spstips.blogspot.com






Re: SharePoint - General Question and Answers and Discussion Can`t retrieve SharePoint GetListItems from the BizTalk 2006 orchestration

VasilyU

I have ListID == listName, it is not a problem, cause i have test win application with all of SharePoint Web Services methods.In it all of my setting worked. I think problem with the following parameters(query, viewfields, queryOptions), but i am not sure




Re: SharePoint - General Question and Answers and Discussion Can`t retrieve SharePoint GetListItems from the BizTalk 2006 orchestration

VasilyU

the problem was incorrect URL of the WEBService. BizTalk change URL to admin (like http://{compName}/_Vtinbin/LIsts.asmx), but i need the full path to the concrete site path (http://{compName}/_vtinBin/sites/site/dir/Lists.asmx)




Re: SharePoint - General Question and Answers and Discussion Can`t retrieve SharePoint GetListItems from the BizTalk 2006 orchestration

Dani Berria

Hi Vasily,

I think the right format is http://{compName}/sites/site/dir/_vtinBin/Lists.asmx instead of http://{compName}/_vtinBin/sites/site/dir/Lists.asmx, that's how it works in my case.

On the other hand, I have a question maybe you could solve: I have just been able to connect to Sharepoint with basic authentication. Do you know how could I connect with kerberos (negociate)

One point before answering: My Biztalk Server is in a different domain than the one with Sharepoint.

Thanks, Dani.