Visualizing Rest Results with treeview explorer

Today’s post is about how to use the jSon to treeView capability in a previous post, and apply it to explore results returned by Rest- Excel library.

The library, itself a jSon structure, is visualized like this. For details on how this is created see visualizing the rest excel library

Taking this a stage further, we can simply execute any of these queries (or others you might add or enter directly in the Query URL textbox), and get the results back right on the same form.

Here’s the response to a geoCoding query from the yahoo Maps API for example.

As you continue to build up your own rest to excel library, this tool will help you figure out which excel fields you want to populate and what the structure of the data is. See Rest Excel Explorer for the code behind this and to download examples.

About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.