No-Code Enrichment with
May the 4th be with you! Retrieve Star Wars Data using the SWAPI Star Wars API.
Sign Up Free

Star Wars API

May the 4th be with you! To celebrate the occasion, we are using Gigasheet to access the Star Wars API from SWAPI (Swah-pee). This contains the world's first quantified and programmatically-accessible data source for the Star Wars canon universe through The Force Awakens. And honestly, that probably a good stopping point. We can all just pretend The Last Jedi and The Rise of Skywalker never happened, right?

Provider Website:
Provider Enrichment Docs:
Token / Registration Required:

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTPs request from the SWAPI website. 

Running the SWAPI Star Wars API

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the latitude and longitude. In this case, we first highlight the term“people” in the input, and then select our Star Wars Data Type column and click +Insert Column Reference. We then repeat the same thing for the number, replacing “1”, with our Item Number Column. Then click Next.

Customizing the Star Wars API Request
Ready to execute the Star Wars API

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the SWAPI Star Wars API response. At this point select the fields you want to be inserted into your sheet. We suggest hitting Select All, because you can always delete columns later.

Response of the SWAPI Star Wars API

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Confirm how many rows to execute the Star Wars API on

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the SWAPI Star Wars API. 

Star Wars API data added to sheet

And here are some stats on some of our favorite characters!

Star Wars characters returned by the Star Wars API

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever