Unfortunately, I'm not familiar with the capabilities of ColdFusion, so I'm not sure I'll be of much more help. For the authentication information, though, I seem to recall that we had to do something odd in .NET to call Remedy web services. I don't recall the details, but I think we had to add the authentication information to the HTTP headers somehow or something along those lines. I don't know if that will help any, though...
Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Monday, January 25, 2010 5:39 PM To: [email protected] Subject: Re: Sort Order for Web Service ** Thanks! They are using Cold Fusion. We already had a few hurdles with how Remedy wants to serve up the WS/SOAP and what and how CF wants to call/consume it. They are still trying to figure out how to include authentication info in the call were as it is really easy when I test with soapUI. I have sent them the sample soapUI XML but I am not sure how that translates into CF's capabilities. Jason On Mon, Jan 25, 2010 at 4:23 PM, Lyle Taylor <[email protected]<mailto:[email protected]>> wrote: ** Controlling sort order is not a fundamental aspect of web services; if the ability exists in other web services, it's simply because someone explicitly implemented it. With a more general programming language, or something more directly tied to, say, a database query, this would be relatively easy to do. I can understand why they may want to sort data in various ways, but if they're consuming the web service with a more general purpose program language (e.g., Java or .NET), it should also be relatively easy to simply throw the results of the web service into data structures that allows them to slice and dice it the way they want. For example a DataTable in .NET or whatever the Java equivalent is. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Jason Miller Sent: Monday, January 25, 2010 4:57 PM To: [email protected]<mailto:[email protected]> Subject: Re: Sort Order for Web Service ** Thanks Fred! It is true that the form soft order controls the web service sort order. Problem is they they want to choose the sort order and order by column at run time. Good idea, I'll throw it back to them and as for an example. I really only know web services from a Remedy point of view so they could tell me that the WS is supposed to make their morning coffee and I would take their word for it. Jason On Mon, Jan 25, 2010 at 3:36 PM, Grooms, Frederick W <[email protected]<mailto:[email protected]>> wrote: I believe the sort order is based on the default order for the form(s) the service is built against. FYI: I have never seen a web service that allows you to send a parameter to control the output sort order. Have them give you an example of one. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Jason Miller Sent: Monday, January 25, 2010 5:18 PM To: [email protected]<mailto:[email protected]> Subject: Sort Order for Web Service ** Does anybody know of a way to change the sort order from/for a web service? I created a web service for our web team who is building a reporting console for their users. They can filter records based on a few different parameters. They would like to have the ability to control the sort order based on parameters so they do not have to load all of the records, sort them on their side and then display the results. They think I am crazy when I tell them there is not a way to do this with Remedy web services and that this is a fundamental function of any web service. Thanks, Jason ARS 7.5 p1 MT 7.5 MS SQL 2005 Windows 2008 64bit db/app servers Windows 2008 32bit Mid-Tier _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> Platinum Sponsor:[email protected]<mailto:sponsor%[email protected]> ARSlist: "Where the Answers Are" _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
