Challenge #139: Spooky API Connection

[CHarrison]

Cadbury's Heroes all Halloween for me!

[OliverW]

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]

My first ever Weekly Challenge attempt

[Hakimipous]

Not as easy as I thought :p

Also I assume Atmoic Fireball is a typo

Here is my solution!

[ponraj]

Here is my solution!

Spoiler

Workflow & Results

[danilang]

That's one big, bloated tummy!

Spoiler

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

Dan

[tan_mingh_ui]

First submission, not the most elegant though!

[CharlieS]

I also changed the spelling. 

[Thableaus]

Spoiler

Cool exercise!

Here's my solution.