Chintan and LJ,
I’m going to have to get more info from the service provider. Their website for the “API” states “You can access the service with any platform or programming language capable of making a web request, and the service can be tested by simply entering the URL into any web browser's address bar.“ Since the returned values cannot be selected I get the entire tuple and will need to parse through it to get at the specific field values. I guess I’ll try Perl. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, November 03, 2011 9:32 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Consuming Web Service not WSDL ** I think this would be a good use of a Perl or Java plugin…the values needed could be passed as input…the libraries can do their needed work and provide the output back to remedy. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah Sent: Thursday, November 03, 2011 12:47 AM To: arslist@ARSLIST.ORG Subject: Re: Consuming Web Service not WSDL ** Hi John, No, I have not tried doing that using in built Remedy workflow. How many values do you need to parse? The below approach might work if your data-set that needs to be parsed is less. There are JSON parsers available outside of Remedy(like http://code.google.com/p/google-gson/). 1. Make a call using $PROCESS$ to external HTTP Client from an Active Link(using java or perl or whichever language you feel comfortable with) which would in-turn call ur REST Web-service by building URL. 2. Parse the returned JSON object. There are libraries available for this. 3. Return the data back to Remedy. e.g. Lets say you want to get contact name and phone # of an employee by supplying employee ID in INPUT Parameter of REST URL(which looks like this http://abc.com/employeeid/<employeeIDhere>). 1. Set Fields on "Common Data field":Run An Active Link with following (you are providing employee id as an argument to HTTP Client) $PROCESS$:@@ GetEmployeeInfo.jar $employeeid$ 2. GetEmployee.jar would do this. a) Construct URL by appending employee id after the last "/".e.g.(http://abc.com/employeeid/12345 where 12345 is argument passed from Remedy) b) Send the request. c) JSON Parser would extract the contact name and phone # on JSON Response. d) Return data back with some kind of separator to Remedy. 3. When data is returned back use SUBSTRC(and maybe a few other functions to parse out delimiter) to populate data from "Common Data field" to 2 separate fields. Now, if there are more than 2 fields, I would suggest you do it in a filter as a Run Process and then later update the record. Although it will be a little cumbersome since you will need to use Remedy API or Web-services to first get the employee ID from Remedy, use it, build URL, call REST web-service, parse JSON Response, send result set by updating individual fields to Remedy record. Hope this helps. Thanks Chintan. _____ From: "Reiser, John J" <john.j.rei...@lmco.com> To: arslist@ARSLIST.ORG Sent: Wednesday, November 2, 2011 2:19 PM Subject: Re: Consuming Web Service not WSDL Chintan, I have a similar request. I am trying to interface with a REST API which can display the returned values in JSON? or XML. There is no WSDl available to load. The administrator of the site replied to my request for the WSDL location with "We are using REST, so you don’t need a WSDL file to make a REST web service call. You just need to make a URL call." Is there a simple way to retrieve and parse the resulting XML output so I can populate fields in Remedy ARS from an Active Link or Filter? Thank you, John Reiser LMCO _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
