API Ninjas is a data company that enables you to build real applications using real data. API Ninjas maintains 78 APIs that cover subjects from airlines to vocabulary words. API Ninjas validates the quality and quantity of the APIs, so that you are guaranteed to be returned data that you can trust. In this example, we are going to use Gigasheet’s custom enrichment feature and API Ninjas’ Thesaurus API to enrich our sheet with synonyms and antonyms of vocabulary words.
Provider Website: https://api-ninjas.com/
Provider Enrichment Docs: https://api-ninjas.com/api/thesaurus
Endpoint: https://api.api-ninjas.com/v1/thesaurus?word=X -H "X-Api-Key: ${API_KEY}" \
Token / Registration Required: Yes
How To Enrich A Spreadsheet With API Ninjas Thesaurus API:
For this example, my data is a simple list of 15 words. Let’s use the API Ninjas Thesaurus API to retrieve their synonyms.
Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from API Ninjas.
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 word placeholder, “X”, in the input, and then select our Word column and click +Insert Column Reference. We also need to highlight the “${API_KEY}” and paste our real key from API Ninjas. 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 API Ninjas Thesaurus API response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.
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 refresh the page and the result will show generation of new columns based on the API Ninjas Thesaurus API. API Ninjas has added synonyms and an antonym, where available, for each word in my sheet..