Enrichments /
The Metropolitan Museum of Art
No-Code Enrichment with
The Metropolitan Museum of Art
Use The Metropolitan Museum’s Open Access API to Enrich Your Sheet with Museum Data
Sign Up Free

Use The MET Open Access API to Enrich Museum Data

Located in two iconic sites in New York City, the Metropolitan Museum of Art presents over 5,000 years of art from around the world for everyone to enjoy. Additionally, "The Met" provides a dataset of information on more than 470,000 artworks in its collection to anyone online using The Met API. You can use the their Open Access API to further enrich your own dataset with metadata on select artwork, including artist, country of origin, and materials used.

The Met API docs
The Met API Request

Provider Website: https://www.metmuseum.org/about-the-met/policies-and-documents/open-access
Provider Enrichment Docs: https://metmuseum.github.io/
Endpoint: https://collectionapi.metmuseum.org/public/collection/v1/objects/[objectID]
Token / Registration Required: No

How To Enrich A Spreadsheet With The MET Open Access API:

For this example, my data looks like this. This dataset includes a list of objects, or artworks, their object ID, their department, and other metadata.

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

The Met API call

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 [objectID] in the input, and then select our Object ID column and click +Insert Column Reference. Then click Next.

Customizing the Met API call with Gigasheet columns

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the response. At this point select the fields you want to be inserted into your sheet.

preview response from The Met 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 The Met 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 The MET Open Access API.

the met API data in Gigasheet

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