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

Video Guide