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" <[email protected]> To: [email protected] 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
