Challenge 4 - Rick and Morty Catalog
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? To solve this challenge, 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 two string columns, id and character name.
URL: Babak Khalilvandian https://hub.knime.com/bkhalilvandian?pk_vid=9bafb033c114759d1749118633d93d39
Nodes
- Column Filter3 ×
- GET Request3 ×
- JSON Path3 ×
- Table View2 ×
- Ungroup2 ×
- Recursive Loop End1 ×
- Recursive Loop Start1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME JSON-Processing
- FeatureKNIME REST Client Extension
- FeatureKNIME Views
Links
- No links available