Hi All,

I have below list of queries regarding BizTalk SharePoint Adapter:

1. Does the BizTalk out of box SharePoint Adapter supports condition based polling (i.e. we check the value of some specfic column in the SharePoint document library and then take decesion to pick the record or not)
2. Similary does it support condition based updation of document/metadata in the document library

From what I see on the Configuration section for both BizTalk 2010 and 2013 we cannot poll or send documents to SharePoint library based on some condition.

I am assuming for this kind of requirement we need to use c# code to interact to SharePoint service, please do let me know if my understanding is correct.

Cheers,
Umesh

It is my understanding that you can create a view in SP that only shows documents with certain conditions met (status = approved for instance), and then have BizTalk poll from only this view.

Morten la Cour

And no, you cannot put any kind of filter or condition on a Send operation.

You can have BizTalk post the document to a 'staging' library, then a SharePoint WorkFlow will decide whether or not to update the 'main' library.

Morten la Cour is correct.  Create a view in SharePoint using columns in whatever view filter you like.  Then only items in that view will be received.  Works quite well actually - you can even have the columns be based on content in the document if you use an InfoPath form type. 

As to conditionally sending - is the condition really in the SharePoint list or in the document itself?  If in the document, the filter is easy: make the send port match the filter.  For documents that don't match you can just write them to a File send port with the Overwrite option (i.e. send them to bit heaven). 

Otherwise, you can use an orchestration and call the SharePoint web services / API to get the details of the item columns then decide if you want to do your SharePoint send from there. 

Basically, when doing BizTalk avoid C# as much as possible - it's normally not needed.

-Dan

Thanks all, my question was based on a value of certain column within SharePoint library and this column could have multiple values and we are suppose to poll the record/documents based on certain values only within this column and hence I think this is not supported using OOB SharePoint Adapter be it BizTalk 2010 or 2013.

So, I guess I would end up using SharePoint web service proxy of /_vti_bin/listdata.svc  especially when I would develop my code using VS 2010 or BizTalk 2010.

And If we have to access the documents from SharePoint 2013 I am aware that CSOM and REST support is there but I guess assemblies like Microsoft.SharePoint.Client.dll is only available in VS 2012 and not in VS 2010.

So, even if we want integrate/work with SharePoint 2013 but we have VS 2010 then won't be able to use CSOM or REST but would still have to work with /_vti_bin/listdata.svc  which is SharePoint web service.

Please let me know if my understanding is correct.

Cheers,
Umesh

Ok looks like I could still use the CSOM from VS 2010 as well as long as I get the below dll's from the SharePoint server (i.e. either 2010 or 2013)  to the Client machine:

Microsoft.SharePoint.Client.dll
Microsoft.SharePoint.Client.Runtime.dll