Challenge #7: Download Data and Parse JSON

[mek201gs]

Would be cool to have a macro that iterates through JSON groups. Thanks!

[ipeng]

Attached

[CapriceW]

Here goes!

[AJauniskis]

This one was fun, thanks. Even got some ideas how to utilize web scraping at work.

Spoiler

[hugolees]

Spoiler

 could definitely have been more succinct on this one!

[OliverW]

My Solution

Spoiler

[nathandwalker]

I ended up just regexing the downloaded JSON instead of splitting it by rows with the JSON tool.

[EW]

My (slightly brute forcey) solution:  

Spoiler

I couldn't figure out how to get the StripQuotes formula to strip the quotes so I've got a workaround.  Going to see how everyone else did it!

[Sajeel_Kershi]

Similar to solution but I specifically filtered for "dataset.column_names." and "dataset.data.".

I guess the regex solution of [word].[word].[digit] is more generic but not sure that every json file where that is the pattern only refers to column names and data values.

[DavidThorpe]

Interesting challenge, really enjoyed this one as API downloads are quite a new concept to me!