Parsing JSON to extract values ...

JSON (JavaScript Object Notation) is a light weight Data-Interchange in Text format completely Language independant. It is used as a alternative to using XML, though both are structured approaches to mark up data. JSON like XML, has a structure with nesting of Data Elements. Both are Text based and both use Unicode. But the subtle benefits are - JSON is more clean and a little less verbose. Each instance of a JSON document describes one object with nested objects, arrays, strings, numbers, boolean values, or null values. Application may prefer using JSON over a XML structure since it is a subset of Javascript and you can use JavaScript’s own compiler to do the parsing. Also, navigating an object synthesized from JSON is identical to navigating any JavaScript object. It’s far easier than navigating through the DOM tree.

An object, in JSON parlance, is an unordered set of name/value pairs. An object begins with { (left brace) and ends with } (right brace). Each name is followed by : (colon) and the name/value pairs are separated by , (comma).

VSTS is able to record and playback Ajax/JSON requests. However, there’s no built-in support for doing things like Validating the contents of a JSON Response or extracting values if needed.

Parsing JSON embedded in a XML DOM Tree structure

    <?xml version=”1.0″ encoding=”utf-8″?>
      <soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”    xmlns:xsd=”http://www.w3.org/2001/XMLSchema“>
        <soap:Header>
          <SessionInfoHeader xmlns=”http://<whatever_the_domain>.com/webservices/“>
             <SessionInfo>{”SessionInfo”: {”SetOnLogin”: “True”, “CompanyID”: “my_Company_ID”, “Company_Name”: “my_Company_Name”, “LanguageID”: “enu”, ”LanguageVersion”: “1″, “User_ID”: “MANAGER”,   “UserName”: “my_User_Name”, “UserEmail”: ”user1@test.com” } }
             </SessionInfo>
          </SessionInfoHeader>
        </soap:Header>
      <soap:Body>
        <LogInResponse xmlns=”http://<whatever_the_domain>.com/webservices/” />
      </soap:Body>
    </soap:Envelope>

In the above XML DOM structure, the this is the JSON text.

Inside the Extract method, read the innertext property for the XML Node that contains the JSON instance, load the text to an XML Document Object, and then further using XPATH expression to reach the particular *Keys* , parse out the values for the same.

You can further learn about writing custom extraction Rules

public override void Extract(object sender, ExtractionEventArgs e)

        {

           if (e.Response.HtmlDocument != null)

            {

                if (e.Response.IsXml )

                {

                    myDoc = e.Response.XmlDocument;

                    XmlNodeList myXMLNodeList = myDoc.GetElementsByTagName(jsonTextVal);

                    foreach (XmlNode myXMLNode in myXMLNodeList)

                    {

                        myXMLNodeInnerText = myXMLNode.InnerText;

                    }

                }

            }

            //Covert the Json Text into Byte Array

            System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();

            jsonTextInByteArray = encoding.GetBytes(myXMLNodeInnerText);

          

            //Call to parse the JSON and convert that into a XML infoset

            myXMLDocForJasonString = parseJsonToXML(jsonTextInByteArray);

            e.WebTest.Context.Add(this.ContextParameterName, myXMLDocForJasonString.InnerXml);

          

            //using XPATH Expression to further extract Elements

            jsonTagsToExtractArray = JSONValueTagsList.Split((new Char [] {‘ ‘, ‘,’}));

            for (int i = 0; i < jsonTagsToExtractArray.Length; i++)

            {

                XmlElement root = myXMLDocForJasonString.DocumentElement;

                myxpathExpression = jsonTextVal+“/” + jsonTagsToExtractArray[i];

                elementList = root.SelectNodes(myxpathExpression);

                foreach (XmlNode myXMLNode in elementList)

                {

                    e.WebTest.Context.Add(jsonTagsToExtractArray[i], myXMLNode.InnerText);

                }

 

            }

        }

        public XmlDocument  parseJsonToXML(Byte[] jsonTextInByteArray_param)

        {

            XmlDocument myXMLDocument = new XmlDocument();

            XmlDictionaryReader xmlReader = JsonReaderWriterFactory.CreateJsonReader(jsonTextInByteArray_param, XmlDictionaryReaderQuotas.Max);

            xmlReader.Read();

            String XMLString = xmlReader.ReadOuterXml();

            myXMLDocument.LoadXml(XMLString);

            return myXMLDocument;

        }