The 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:

Parameter

Description

Example

URL
Required

The URL of the API endpoint you are calling. If you wish to pass parameters in the URL, use {paramName} to detonate the place of the parameter. You can supply the parameter in the parameters section of the function call.

"https://investors-exchange-iex-trading.p.rapidapi.com/stock/{symbol}/book"

Select Path
Required

This is the part of the returned JSON you want to pull into the sheet. The path should be detonated in JSON dot notation.
For instance, given object {a:{b:1}}, to pull the value of b use the path a.b.
If you want to pull multiple values, comma seperate them. Each value will be presented in a new column, based in the order they were supplied.

"quote.companyName,quote.latestPrice"

API Key
Required

Your RapidAPI API key.

Parameter(s)
Optional

For each parameter you wish to supply to the API, you should pass two arguments to the function - the parameterName and parameterValue.
If the parameters apear in the URL path like {parameterName}, they'll be used there. Otherwise, they'll be attached as query parameters (?parameterName=parameterValue).

"symbol","AAPL"