Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

karlhansen
9 - Comet

Sadly, the website is no longer operating.  I do wish the data were available someplace else.

martinding
13 - Pulsar

Seems like the relevant links no longer work?

grazitti_sapna
17 - Castor

My Solution:

Sapna Gupta
JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1669288030936.png

 

Used the link found by @leozhang2work for the updated API. Going to attribute the difference in answer to the change. First time I've messed about with an API in ages so that was a lot of fun

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1673677039204.png

 

peter_gb
10 - Fireball

Pleeeeaaaase update this challenge, was a pain finding the information!


I did a search for the food names to get the FDCIDs, which were then sent in one call to fetch the calorie values.

 

Would be a great API challenge if the ask was clearer 

I also used this API: https://fdc.nal.usda.gov/api-guide.html#bkmk-2

 

Spoiler
challenge_139_pgb.png

kristiadiuisan
8 - Asteroid

Slightly different total calories, probably due to the API keep getting updated

 

Spoiler
Alteryx_challenge_139_KU.png
leonhekkert
8 - Asteroid

My solution:

 

Spoiler
Challenge_139.png
CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1680249431548.png

Just like others, the API does not work anymore so I use the one provided by others in this post.

alacoume
9 - Comet

Interesting!