Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 @ 1:11 PM
Points: 12,905, Visits: 32,161
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1589828
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse