Intro
See a REST API call as a Google search - you do a request and get a response back. Today we work with the sample Star Wars API.
Learning Objectives
- HTTP Requests (REST API)
- JSON Parsing
- Error-handling
Description
- Download the Excel book
- API address: https://swapi.dev/
- For each row, do an HTTP Request and update the row with the results from the response
- Perform error handling if an ID doesn't exist at the API
Hints
- HTTP Request
- Parse JSON
- Apply to each
- For the Excel
- List rows present in a table
- Update a row
- Error-handling
- Use a switch on the Status code
