Hello
I am new to the community, as well as new to Web Services in a whole. I have succesfully implemented one web service project through SSIS through a different vendor, but on this vendor I am stumped.
First of all, here is the link to the list of web services: https://login.incontact.com/insidews/inSideWS.asmx"
Second of all, here is a link to the WSDL file I get from adding the ?WSDL to the end of the link above: https://login.incontact.com/insidews/inSideWS.asmx?wsdl
My goal is to use the command "Agent_GetList" to pull data from the Web Service, into SSIS, then into SQL Server. When I use the link above, and generate a WSDL from the link by clicking "Download WSDL" from the Web Service Task in SSIS, it then gives me a list of methods to pull. The "Agent_GetList" is included in these methods, yet there is no where to verify my password, or any other login information. When I use the "Agent_GetList" as the method, and try and test Executing the Task in SSIS, I get the following error:
[Web Service Task] Error: An error occurred with the following error
message:
The Web Service threw an error during method execution. The error
is: System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.NullReferenceException: Object reference
not set to an instance of an object.
at
inSideWebService.proxySoapExtensions.ProcessMessage(SoapMessage
message)
at
System.Web.Services.Protocols.SoapMessage.RunExtensions
(SoapExtension[] extensions, Boolean throwOnException)
at
System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()
at
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
--- End of inner exception stack trace ---.
at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.In
vokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object
connection)
at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invok
e(DTSWebMethodInfo methodInfo, String serviceName, Object connection,
VariableDispenser taskVariableDispenser)
at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeTh
read()".
I simply just want to pull the data from Agent_GetList. Please help with what I am doing wrong, or anything I may be missing.
Thank you
It looks like you're new here. If you want to get involved, click one of these buttons!