Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Kyle Doouss
Yak Posting Veteran
64 Posts |
Posted - 2013-02-13 : 11:10:19
|
Hello, I would really apreciate it if someone could help me regards the following. It is the first time I have ever done anything with calling httpBelow is what I have got working if you call it from a browser...https://csv.business.tomtom.com/extern?account=xxxx&username=xxxxx&password=xxxxx&lang=gb&action=sendDestinationOrderExtern&objectno=EU53 SXG&orderid=12372&ordertext=Test&addrnr=001The above basically creates an order on the tomtom. I need to send quite a few orders which I can retrieve from a view. I need to basically send all the lines in the view.Please help... thanks |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-13 : 11:20:16
|
why not send it as a xml value and shred the data out in sql using xml functions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
Kyle Doouss
Yak Posting Veteran
64 Posts |
Posted - 2013-02-13 : 11:34:24
|
Thanks.. could you point me in the right direction on how to do this.Sorry I am very new to this. Do you use a stored procedure? XML is someithing I have not really used with SQL before. |
|
|
Kyle Doouss
Yak Posting Veteran
64 Posts |
Posted - 2013-02-14 : 08:35:45
|
I have been looking to see if I could do this with the belowSELECT top 100 percent objectno, orderid, ordertext, addrnrFROM UDEF_KD_TOMTOM_SendDestinationOrderExternFOR XML AUTOGOHow do I then call this for the multiple lines to the followinghttps://csv.business.tomtom.com/extern?account=xxxx&username=xxxxx&password=xxxxx&lang=gb&action=sendDestinationOrderExternShould I also be hard coding in the &lang=gb&action=sendDestinationOrderExtern or should I actually put everything from extern? in the table/view?We be very glad of any help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-14 : 09:47:09
|
what do you mean call this for multiple lines? where are you generating the url?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
Kyle Doouss
Yak Posting Veteran
64 Posts |
|
Kyle Doouss
Yak Posting Veteran
64 Posts |
|
|
|
|