Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to post xml string to url in storedproc? Expand / Collapse
Author
Message
Posted Monday, July 7, 2014 4:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:11 AM
Points: 12, Visits: 60
Hi,

I want to post a XML string to an url

ex : http://mytestsite.com/adiunit/samp.aspx?xml=nxml
where nxml is an xml string

so when user hits the url he can view the xml content on the browser.

How can I do this using storedproc.?

Thanks in advance.
Post #1589799
Posted Monday, July 7, 2014 6:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 13,975, Visits: 36,292
SQL server is probably not the target platform you want to use for this; is this supposed to send / retrieve information from the web service and return it to a user, or just blindly send to your web service?

anyway, to do it via SQL server,you will have to create and use a CLR(Common Language Runtime) procedure which is specifically designed to call your web service with the appropriate parameters, and consume any answers back.

there's lots of examples out there, does this help?
https://www.google.com/search?q=SQL+CLR+to+call+a+web+service&oq=SQL+CLR+to+call+a+web+service


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1589828
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse