Enrichments /
Magic: The Gathering Developers
No-Code Enrichment with
Magic: The Gathering Developers
How To Use Magic: The Gathering API To Get Card Artist Names
Sign Up Free

Use Magic: The Gathering API To Get Information on Cards

The Magic: The Gathering API provides an endpoint that returns different possible information about a card, including the set, name, and artist. 

magic the gathering api request

Provider Website: https://docs.magicthegathering.io/
Provider Enrichment Docs:
curl "https://api.magicthegathering.io/v1/cards/386616"
Token / Registration Required:

How To Enrich A Spreadsheet With Magic: The Gathering API:

For this example, my data looks contains a list of card names from two sets titled: Adventures in the Forgotten Realms and Innistrad: Midnight Hunt.

Gigasheet sheet for use with magic the gathering api

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from Magic The Gathering API.

paste magic the gathering api into Gigasheet

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the name, “avacyn”, in the input, and then select our “Adventures in the Forgotten Realms” column and click +Insert Column Reference. Then click Next.

customizing the request to the magic the gathering api
ready to call magic the gathering api

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Ziptastic response. At this point select the fields you want to be inserted into your sheet. Select “cards/0/artist” to insert a new column into your Gigasheet sheet for the artists of the cards.

select response fields to add from magic the gathering 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 execution of magic the gathering api

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 Magic: The Gathering API. The API has added a new column titled “Adventures in the Forgotten Realms - cards/0/artist”.

Gigasheet sheet containing data from magic the gathering api
Try it Out

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Database
No Training
Sign Up, Free Forever