Set jsonObject = JsonConverter.What the XML file looks like in a browser HttpReq.SetRequestHeader “User-Agent”, “Mozilla/4.0 (compatible MSIE 6.0 Windows NT 5.0)” HttpReq.SetRequestHeader “Content-Type”, “application/json-rpc” HttpReq.SetCredentials “YOUR USER ID”, “PASSWORD”, 0 JSON ObjectĪ JSON object always begins with ” This site gives a great high level, cross-language overview of JSON. Other languages might have other terminology such as hash table for object, or vector for an array. It’s important to note that object/dictionary and array are the terminology applicable to the. Objects are made up of key/value pairs (often called a dictionary) and arrays are simply collections of values or objects separated by a comma. It is made up of objects, or arrays, or a combination of both. It’s made simple because JSON, at it’s most basic, is only two data types. It is easy for humans to read (when formatted properly) and, because of the universal structure, it is very easy and fast for machines to parse and generate. In layman’s terms, it is a string of text that represents a universal data structure. JSON stands for JavaScript Object Notation and is a lightweight data-interchange format. Before we begin on that route, let’s take a quick moment to talk about what JSON is for those that aren’t familiar with it.Ĭurious how to do this in VSTO? Click Here! What is JSON? Therefore, as excel ninjas, it’s important to understand how to import JSON to Excel for analysis.

Many REST APIs have the option to return both but the majority that I interact with default to returning JSON formatted data. XML was widely used for years, but recently JSON has started to become the preferred method of data exchange. Howdee! It’s becoming increasingly more common for data to be generated in a JSON format as opposed to XML.

Import json into excel 2013