Icon

Challenge 4 - Rick and Morty Characters Catalog

<p><strong>Challenge 4: Rick and Morty Characters Catalog</strong></p><p><strong>Level:</strong> Medium</p><p><strong>Description:</strong> You work for an entertainment company that wants to analyze various TV shows to gain insights into audience preferences. Your next project focuses on transforming data from the show “Rick and Morty” into a structured dataset that can be easily analyzed and queried. As a first step, you need to extract a complete list of characters featured in the series. However, the API that provides this information is paginated, returning separate JSON files for each page. How can you use the KNIME Analytics Platform to retrieve and merge all these pages into one unified catalog of the show’s characters?<br><br><strong>Dataset: </strong>Use the "https://rickandmortyapi.com/api" url.</p><p><strong>Beginner-friendly objective:</strong> 1. Successfully send a Get Request to receive the characters data from the API</p><p><strong>Intermediate-friendly objectives:</strong> 1. Implement a recursive loop to handle paginated API responses and ensure all data is collected. 2. Unify all the pages into a table with 2 string columns, id and character name.</p><p></p>

Challenge 4: Rick and Morty Catalog


Level: Medium

Description: You work for an entertainment company that wants to analyze various TV shows to gain insights into audience preferences. Your next project focuses on transforming data from the show “Rick and Morty” into a structured dataset that can be easily analyzed and queried. As a first step, you need to extract a complete list of characters featured in the series. However, the API that provides this information is paginated, returning separate JSON files for each page. How can you use KNIME to retrieve and merge all these pages into one unified catalog of the show’s characters?

Dataset: Use the "https://rickandmortyapi.com/api" url.

Beginner-friendly objective: 1. Successfully send a Get Request to receive the characters data from the API

Intermediate-friendly objectives: 1. Implement a recursive loop to handle paginated API responses and ensure all data is collected. 2. Unify all the pages into a table with 2 string columns, id and character name.

GET Request
GET Request
find next page url
JSON Path
Recursive Loop Start
JSON Path
Recursive Loop End
Column Filter
Column Filter
Column Filter
Ungroup
extract results
JSON to Table
Column Filter
JSON Path

Nodes

Extensions

Links