Step by Step JSON (or REST) to Excel handholding

[Joe Robison]

I'm working with the Raven API Testing Console (https://api.raventools.com/docs/#) that spits out the Google rankings for my website to a URL in JSON or XML format. Choosing JSON I get all the JSON data but don't know how to bring this into excel neatly.

I tried reading this post - http://ramblings.mcpher.com/Home/excelquirks/json/excel-json-conversion as well as this one http://excelramblings.blogspot.com/2011/11/rest-json-excel-in-one-line-of-code.html

But it's too advanced for me at the moment, how do I start by parsing the JSON into excel. I don't know where to begin with any of this for example:

Get a jSon response from a web service and populate a worksheet with the result.

    Dim dSet As New cDataSet, cb As New cBrowser, jo As New cJobject

    dSet.populateJSON jo.deSerialize( _

       cb.httpGET( _

           "http://dl.dropbox.com/u/14196218/files/jSon1.html" _

           ) _

       ).Child("cDataSet"), Range("json1!$a$1")

create and print a jSon string from a worksheet.

    Dim dSet As New cDataSet

    Debug.Print dSet.populateData( _
        Range("jSon2!$a$1"), , , , , , True _
        ).jObject.Serialize(True)

Thanks for any help you can provide!

Joe

[Bruce McPherson]

Hi

You need to be looking at this ... http://ramblings.mcpher.com/Home/excelquirks/json/rest . 

If you let me have a sample of your json , the fields you need to extract, and a URL sample I can get you started. 

Regards

Bruce

Sent from my iPad

--
 
 

[Joe Robison]

Awesome, thanks so much for the quick response Bruce. Yes I'll take a look at this and then send you a sample.

Thanks!