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. 

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

‍

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.

‍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.

‍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.

‍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.

‍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. 

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”.