Last post Nov 15, 2011 06:11 AM by richardterris
Sep 26, 2011 04:33 PM|richardterris|LINK
I've written a CLR stored procedure which passes data into a web service.
it works except for the fact that I can't figure out how to grab the response back into the stored proc output parameters.
So I submit details to the service and I should be getting back a transaction ID and other data but I can't get at it.
Anyone have any ideas at all?
Thanks a lot,
Sep 27, 2011 10:26 PM|decker dong - msft|LINK
Show us your codes, please:)
Sep 28, 2011 03:01 AM|richardterris|LINK
I'll post some code tonight, I don't have access to it just now.
But in the meantime, maybe you can answer this...
As I have referenced the web service in Visual Studio, which creates the proxy class etc for me, should it be the case that I simply
need to return the return value as part of a web method, or do I need to bring back the whole SOAP envelope and parse it to get the
value I want?
Sep 30, 2011 03:11 AM|richardterris|LINK
I'm getting quite good at answering my own threads haha :)
Ok so again, in case anyone else has a similar issue - if using HTTP GET then raw XML is returned in a SOAP enevlope, which then has
to be parsed... some cool techniques like XMLElement would allow you to select specific nodes of the XML.
However, as I'm using .NET and Visual Studio, all of the XML is already deserialised so no need for any parsing.
Turns out the values were available to me, I had just missed a step which set up a parameter for the response to be passed into.
Nov 14, 2011 08:07 PM|ugs123|LINK
I have the exact same issue and it is driving me nuts.
Can you please explain 'I had just missed a step which set up a parameter for the response to be passed into'?
Nov 15, 2011 06:11 AM|richardterris|LINK
PM me your code and I'll see if I can help.