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

Additional Material