SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm very new to using BCS in SharePoint 2010. I'm not really sure how to go about my problem or if it's even possible without coding a custom solution in Visual Studio using .NET.

I have a SOAP web service I want to connect to my SharePoint site in order to create a list containing students retrieved from a request. This seems like a pretty straight forward thing to achieve using SharePoint Designer and BCS.

The issue is the way the SOAP interface I'm communicating with deals with authentication (Just to clarify I wasn't the person who initially setup the SOAP service). In order to pull down this list of students I need to first call a soap action called StartWebService which takes a username and password as parameters. Then the response from this action is a session token which is used as a parameter in the GetStudentList action.

How do I deal with authenticating with the StartWebService action and using the result as a parameters in another request? Can this be achieved using SharePoint Designer?

share|improve this question
up vote 0 down vote accepted

SharePoint Designer wouldn't be able to do this. For your web service call, it only supports regular authentication methods, not calling another service first to get a token.

I see two options:

1) Write a custom BCS provider in Visual Studio that does it

2) Write a custom web service to act as a middle-man that does the multiple calls and presents itself as a simple web service to BCS in SPD.

share|improve this answer
Thank you for your prompt response and advice. I will look into these options. – MalcolmDurling Oct 16 '12 at 19:55
You are most certainly welcome. Welcome to the community. – John Chapman Oct 16 '12 at 19:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.