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

simbert
8 - Asteroid

Surely there is a way to clean the Bag input with one RegEx tool...

Spoiler
clipboard_image_0.png

 

ecarter-93
8 - Asteroid

Complete!

 

solution 139 image.PNG

Spoiler
 
Bluemoon
8 - Asteroid

Accidentally did it on 2019.3, then downgraded (for server), but I promise it worked...

Spoiler
clipboard_image_0.png
OllieClarke
15 - Aurora
15 - Aurora

Slight spanner in the works...

clipboard_image_1.png

OllieClarke
15 - Aurora
15 - Aurora

So the API stopped working on the 1st of October, and has been replaced with the FDC API. However, despite following the documentation I could not get this to work. So instead I used Alteryx to download the entire FDC dataset and then worked from there.

Spoiler
challenge 139.png
My answer was slightly different as I had to manually lookup the FDCID, and there were sometimes more than one per candy name. It's still a lot of calories though 🙂
mbogusz
9 - Comet

@SeanAdams I tried opening up your solution to see the use case of fuzzy matching in action, but the attachment is the start file, not the solution file 😞

mbogusz
9 - Comet
Spoiler
2019-11-17 17_13_20-Greenshot.png
edgarl
8 - Asteroid
Spoiler
edgarl_0-1579751914501.png
rmassambane
10 - Fireball
 
danicahui
8 - Asteroid
Spoiler
Challenge 139 2020-01-28.jpg