GET() function performs a simple get request, passing parameters in the URL (as part of the path or as query params), and fills one ore more columns in the same row.
It's parameters are listed bellow:
The URL of the API endpoint you are calling. If you wish to pass parameters in the URL, use
This is the part of the returned JSON you want to pull into the sheet. The path should be detonated in JSON dot notation.
Your RapidAPI API key.
For each parameter you wish to supply to the API, you should pass two arguments to the function - the
Updated almost 3 years ago