Solutions to “Just KNIME It!” Challenge 4 - Season 4

:sun_with_face: Good morning, community! Are you ready for a new Just KNIME It! challenge? :eyes:

:diving_mask: This time we are going to dive into the world of TV shows (Rick & Morty, more specifically) and sharpen our JSON and API skills along the way. :tv:

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason4-4 .

:sos: Need help with tags? To add tag JKISeason4-4 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :blush: Let us know if you have any problems!

4 Likes

Hi All,

Big fan of Rick and Morty!!! :partying_face:

Here is my solution.

Output:

Finally numbers seems to match :sweat_smile:
Will optimize it later :sweat_smile:

Happy Analyzing : )
atcodedog05 - Kiran

7 Likes

Hi everyone,

this is my solution to this week’s challenge!


short and sweet :blush:

As always, any feedback is greatly appreciated :wink:

Have a great day everyone!

7 Likes

Hi everyone!

My solution to this challenge:

Tried to keep it as simple as possible :slight_smile:

I think one of the strongest point of KNIME is how easy it is to get data directly from the internet — whether it’s scraping a website or calling an API, it’s all visual and super flexible. And this challenge was a great example of that! :slight_smile:

7 Likes

I really like your solution :smiley:. Will definitely use it as reference for learning :grin:.

4 Likes

Hello Everyone,

Here is my Solution for this challenge:- JKISeason4-4 – KNIME Community Hub

Workflow -

Have a great day everyone
Sampath

6 Likes

Hello all,

My solution: JKISeason4-4 – KNIME Community Hub
Took me a while to get this loop to work properly. Had to reference the other colleagues here.

image

4 Likes

Hi everyone,

Just able to complete the Rick-and-Morty API pagination challenge! :tada:

My solution as following: JKISeason4-4 – KNIME Community Hub

Built a recursive loop to crawl all pages. Learned loads about REST calls, JSON Path, and loop logic along the way. Huge thanks to the KNIME community for the support/tips that kept me on track.

Would love any feedback or suggestions to make the workflow even smoother!

#JKISeason4-4

4 Likes

Good afternoon, fellow KNIME’ers! :wave: :slightly_smiling_face:

This week’s challenge had me diving into the Rick and Morty universe… which, I have to admit, I’ve never actually watched before! :sweat_smile:

So, just to make sure I wasn’t cataloging a bunch of total strangers, I added images of each character to my solution — visual data enrichment, KNIME-style! :test_tube::framed_picture:

Now I finally know what a Pickle Rick looks like… and yes, it was worth it. :joy:

Happy KNIME’ing and see you in the next multiverse loop! :rocket:

11 Likes

Hi all,

My solution for this challenge available here: JKISeason 4-4 - Rick and Morty Catalog – KNIME Community Hub

Overall, the 2 first objectives are in the first 2 parts of the workflows. An extra part is included in the third green box.

  • Beginner-friendly objective 1: get the number of pages that will be returned by the API. I then used a Bootstrap sampling to generate 1 row per page, followed by a GET Request getting all the information for each page.
  • Intermediate-friendly objective 1: this part include the recursive loop allowing to follow each page link to next page. It ends when the next page field is empty.
  • I have added an extra part to include a data app, allowing the user to do some filtering. Also, the workflow is ready to include episodes information - data available but not shown in the Data App.

The Data App, allowing some filtering on the data available, includes also the more detailed information about the characters and the image of this character.

Enjoy this challenge all!

Cheers
Jerome

6 Likes

Wow, adding character images? That’s pure genius! :fire:
I completely missed that dimension of the API — what a brilliant way to bring the dataset to life.
Definitely stealing that idea for my next interdimensional analysis :smile::test_tube:
Love how KNIME lets us go from JSON to fully visual insights in just a few nodes!
Hats off, sir — that was sharp!

3 Likes

:test_tube::rocket: Rick and Morty API Challenge – My KNIME Solution

Here’s my take on Challenge 4: Rick and Morty Catalog, where the goal was to extract all characters from the paginated public API.

My Solution JKI 4-4

:inbox_tray: What was requested?
Build a recursive loop to collect all pages and extract just two fields: id and name.

:sparkles: What I added beyond the brief:
I extended the dataset to include even more character insights:

:repeat: The workflow includes:

  • A recursive loop driven by info.next
  • Dynamic GET requests
  • JSON parsing with JSON Path
  • Final unified table ready for analysis or export

:brain: It’s been fun to explore not just the structure of the data, but its narrative as well — because every dataset tells a story… even across dimensions :slight_smile: .

:hammer_and_wrench: Built entirely without multiverse collapse.
Curious to know how others approached it!

:speech_balloon: Feedback welcome — or feel free to remix it with even more creative twists.

5 Likes

Hahaha thanks, @PVergati ! :smile:

Glad you liked the character image idea, sometimes data just needs a little personality to shine! :man_artist::sparkles:

To be honest, I added the images because… I had no idea what cartoon we were analyzing! :joy::tv:
So I figured, if I can’t understand the story, at least I can make the dataset look cool! :sunglasses::art:

3 Likes

Wow, that was a challenge!! Mostly because I have never used the recursive loop nodes before, and it looks like it may be a big part of my workflows going forward.


Had to be very creative to make it work, but here is my solution for the challenge.,JKISeason4-4 - Rick And Morty Catalog - Leo_wynter

5 Likes

Not the most special, but a simple solution - workflow:

3 Likes

JKI Challenge :four: :white_check_mark:
Here is my solution

2 Likes

Really enjoyed this challenge! It was fun to use a recursive loop to handle the pagination :slight_smile:

Love the solutions that display the character images!!

My solution is on the hub here: Challenge 4 Rick and Morty Catalog – KNIME Community Hub

It is very similar to everyone elses, but I wanted to show a different way of ending the recursive loop by using a boolean variable :slight_smile:

2 Likes

I copied the character URL and used it directly. I also removed duplicate character names.

3 Likes

Hello all,

Here is my submission for this week’s challenge:

Also big shoutout to @berti093! I don’t have much experience with APIs or loops, but your workflow was very easy to follow. My submission is pretty much the same, but I was able to bring in images for the characters as well (this made it take a lot longer to go through the loop).


4 Likes

I went a little crazy with this one and created three solutions.

Rick and Morty JKI - 4-4 – KNIME Community Hub

4 Likes