Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #139: Spooky API Connection

sprodger
8 - Asteroid
 
CHarrison
8 - Asteroid

Cadbury's Heroes all Halloween for me!

OliverW
Alteryx Alumni (Retired)

Hi all,

 

here is my Solution, just quickly built this together, so there is probably room to improve it. I was lazy about parsing the JSON really, so I just used a filter looking for kcal and then, knowing that the actual value is in the next row, just used a RecordID +1 Formula to create a "RecordID Kcal" and then use a Join tool with the original data coming back from the Download tool to get the Kcal value, its a common technique I use usually when building Website Connectors with Alteryx.

 

Cheers

Olli

paul_f
6 - Meteoroid

My first ever Weekly Challenge attempt

Hakimipous
10 - Fireball

Not as easy as I thought :p

 

Also I assume Atmoic Fireball is a typo

 

 

Here is my solution!

 

ponraj
13 - Pulsar

Here is my solution!

 

Spoiler
Workflow & ResultsWorkflow & Results
danilang
19 - Altair
19 - Altair

That's one big, bloated tummy!

 

tummy.png

 

Spoiler
I took advantage of the fact that the USDA provides XML data and use the XML parse tools to find what I needed

Solution.png



Dan

tan_mingh_ui
6 - Meteoroid

First submission, not the most elegant though!

CharlieS
17 - Castor
17 - Castor

I also changed the spelling. 

Thableaus
17 - Castor
17 - Castor
Spoiler
Cool exercise!

Here's my solution. 

Solution_Challenge_139.PNG