Consuming REST services in OpenSpan

This topic is about consuming REST web services in OpenSpan.

Problem Statement

Process to be automated involves REST service calls to retrieve data from a website.

OpenSpan only supports WSDL services and therefore calls for creating a custom component that can be integrated with OpenSpan.

Solution

Creation of C# based custom component that takes 3 parameters namely URL, Method and Body

and output the JSON string result. This result can be further parsed by converting it into XML and later on iterating through the required nodes.

Automation Logic

Calling Rest Web Service via C#

public void CreateObject(string _URL, string _BODY, string _method, out string response)

{

string URL = _URL.Trim();

string DATA = _BODY.Trim();

response=string.Empty;

HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);

            request.Method = _method;

            request.ContentType = "application/json";

            request.ContentLength = DATA.Length;

            using (Stream webStream = request.GetRequestStream())

            using (StreamWriter requestWriter = new StreamWriter(webStream, System.Text.Encoding.ASCII))

            {

                requestWriter.Write(DATA);

            }

try

            {

                WebResponse webResponse = request.GetResponse();

                using (Stream webStream = webResponse.GetResponseStream())

                {

                    if (webStream != null)

                    {

                        using (StreamReader responseReader = new StreamReader(webStream))

                        {

                            response = responseReader.ReadToEnd();

                         }

                    }

                }

            }

            catch (Exception e)

            {

                MessageBox.Show(e.Message);

            }

}

Converting JSON string into XML

Namespace Required: 

using Newtonsoft.Json;

public string ConvertJsonToXML(string json)

{

XNode node = JsonConvert.DeserializeXNode(json, "Root");

return node.ToString();

}