Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #7: Download Data and Parse JSON

mek201gs
6 - Meteoroid

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

ipeng
8 - Asteroid

Attached

CapriceW
8 - Asteroid

Here goes!

AJauniskis
8 - Asteroid

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

 

Spoiler
workflow.JPG
hugolees
7 - Meteor
Spoiler
2018-12-20_17-00-14.png could definitely have been more succinct on this one!
OliverW
Alteryx Alumni (Retired)

My Solution

 

 

 

 

Spoiler
grafik.png
nathandwalker
5 - Atom

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

EW
11 - Bolide

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!

007EW.PNG
Sajeel_Kershi
8 - Asteroid

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
Alteryx Alumni (Retired)

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