Upon pasting the complete formula (which is composed of the function and the randomly-generated string) into a specific cell, Apipheny runs the API request associated with that specific string, and loads the API data into the cell that the function was pasted in.
In other words, if you paste the complete formula into cell E4 (like in the image below), Apipheny runs the associated request for that formula and loads the API data right into that same cell.
This function comes in handy when you need your API data in a specific area on your spreadsheet. This lets you continue working on your main workspace with the data right beside it.
You can paste the complete formula anywhere on the spreadsheet and as many times as you like.
You can also run multiple requests in a single spreadsheet. Just be careful not to overwrite other data.
Using the APIPHENY function is easy.
Just save your API request, copy the randomly-generated formula, and paste it into the cell of your choice.
When you save an API request, Apipheny generates a formula containing the APIPHENY function and a randomly-generated string.
If you’re new to Apipheny, just follow the steps below and you’ll be ready to use the custom function in no time.
To begin, go to your spreadsheet then click Add-ons > Apipheny – API Tool > Import API. If you don’t already have the add-on, install it here.
If the endpoint is working as intended, press Save to store the request into Apipheny. Once you save your request, you can reuse it for future use.
Pick an appropriate name for your Saved Request, one that’s easy to remember, then click Save.
Apipheny generates formulas for Saved Requests so you can reuse them whenever you like. To find the formula for your saved request, navigate to the Manage tab.
In the Manage tab, you’ll see a list of all your Saved Requests. Find and click the name of the request you wish to use.
Upon clicking the name of your saved request, you’ll be taken to a menu that allows you to edit the details of your request.
Scroll down to the very bottom to see your formula.
Copy and paste the formula into any cell. You can do this as many times as you like and for as many different requests as you like.
The requested data appears starting from the cell on which you pasted the formula.
And that’s it!
Congratulations, you now know how to use the APIPHENY custom function.
Learn more about APIs by reading these next: