Step by Step JSON (or REST) to Excel handholding

2660 views
Skip to first unread message

Joe Robison

unread,
Dec 3, 2012, 2:34:36 PM12/3/12
to excel-r...@googlegroups.com
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.


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( _
           ) _
       ).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

unread,
Dec 3, 2012, 5:22:29 PM12/3/12
to excel-r...@googlegroups.com
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

unread,
Dec 4, 2012, 11:11:14 AM12/4/12
to excel-r...@googlegroups.com
Awesome, thanks so much for the quick response Bruce. Yes I'll take a look at this and then send you a sample.

Thanks!
Reply all
Reply to author
Forward
0 new messages