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.

‍

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. 

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

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

‍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 The MET Open Access API.

‍